I want to add a bit to a backup script that will transfer a file to another server, over the internet.
My cron currently does a pg_dump of a database into a file on the local machine, I want to then push that file to remote location, it needs to be secure (thinking SSH/SCP/SFTP but I'm open to suggestions).
I don't want to mount a directory from the remote server as I'm going over the internet, and my perception is that isn't very secure.
both machines are running ubuntu, 11.04 on one, and 12.04.2 on the source machine.
Additionally, I then want to push the file to multiple backup locations, but I'm assuming that once I have I commandline I can just rinse and repeat in the script.
I've looked at scp and sftp, but both require a password to be supplied interactively it seems.