LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   postgres daily/weekly/ automated backups (https://www.linuxquestions.org/questions/linux-server-73/postgres-daily-weekly-automated-backups-641955/)

sir-lancealot 05-13-2008 02:43 PM

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

chrism01 05-13-2008 07:00 PM

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.