On 2009-11-08, Bret <[email protected]> wrote: > > I need to back up a production database every night > on FreeBSD 7.2, running Postgresql 8.3. > > Any good backup tips I should be aware of.
I backup using pgdump and move the dumps offsite using rsync --compress overwriting a copy of yesterdays backup in this way I get better than 20:1 compression once offsite the backups are compressed and rotated, I keep 6 dailys and 6 weeklys, -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
