On 2009-11-08, Bret <bret_st...@machinemanagement.com> 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
