On 2009-11-08, Bret <bret_stern(at)machinemanagement(dot)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,