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
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.