postgres daily/weekly/ automated backups
Does anyone have, or know of an automated backup type app for postgres that does the above?
I have automake http://members.lycos.co.uk/wipe_out/automysqlbackup/ and the script is perfect. You simply give it the database(s) you want, location, etc. and then stick it in cron. Each day I get a backup (dbname.day.gz) for m-f, then it sticks fri in the weekly and starts overwriting the daily's, and once a month puts the last day of the month in a monthly for permanent archiving. It works flawless! Now I have a basic 3 line pgdumpall script that simply backs up the db, but I would like all the above bells/whistles, does any postgres dba's know of anything that compares? Thanks |
Well, according to that page, it's a shell script, so all you have to do is replace the MySQL specific cmds with the Pg equivalents ones. Just don't mess with the rest ie timing etc.
|
All times are GMT -5. The time now is 10:52 AM. |