Re: [ADMIN] Backup issue

2005-09-19 Thread Scott Marlowe
On Sat, 2005-09-17 at 02:49, Marcin Giedz wrote: > Hello... > > This is what I have now: postgresql 8.0.1 - database weights about 60GB > and increases about 2GB per week. Nowadays I do backup every day - > according to simple procedure (pg_start_backup:rsync > data:pg_stop_backup:save wals pro

Re: [ADMIN] Backup issue

2005-09-17 Thread Jeff Frost
Marcin, What I have done in the past is setup a bi-monthly base backup (pg_start_backup:rsync data:pg_stop_backup) and archive the WAL files between base backups with the archive_command option in postgresql.conf, saving 2 base backups and removing anything older than the oldest base backup.