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