Postgres Backup Script Jun 11, 2009
I need a shell script that will run on Ubuntu 9.04. Prefer straight bash, but ok to use something like python or ruby as well.
The script needs to accomplish these things:
* Make a backup of an existing database in postgres 8.3.7
* Bzip2 the backup (and tar if backup is directory).
* append a datetime stamp to the file. (final file name “db_name.date_time.tar.bz2). Date stamp should be in format YYYY-MM-DD-hh-mm-ss)
* SCP the backup to an offsite server
The inputs to the script should be:
1) database name
2) database username
3) database password
4) remote machine username / domain (scp works over ssh, and ssh keys will be set up for passwordless auth, so no password needed for remote machine)
The script will never do anything destructive. No original files are ever changed. All temp files are cleaned up except the backup (tar.bz2) which remains on the localhost (as well as scp-ed to the remote machine).
The script should be cron-able
I will pay 50% more if you can provide the same script for both PostGres & MySQL (Postgres being more important in my case)
Place bid
Email This Project
