Copying data from STDOUT to a remote machine using SFTP
- by freddie
In order to backup large database partitions to a remote machine using SFTP, I'd like to use the databases dump command and send it directly over using SFTP to a remote location.
This is useful when needing to dump large data sets when you don't have enough local disk space to create the backup file, and then copy it to a remote location.
I've tried using python + paramiko which provides this functionality, but the performance much worse than using the native openssh/sftp binary to transfer files.
Does anyone have any idea on how to do this either with the native sftp client on linux, or some library like paramiko? (but one that performs close to the native sftp client)?