| From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Backups |
| Date: | 2009-11-16 08:46:46 |
| Message-ID: | hdr3hmhjhdr3hm$7hj$1@reversiblemaps.ath.cx@reversiblemaps.ath.cx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasen Betts | 2009-11-16 09:14:44 | Re: Raise functionality |
| Previous Message | Jasen Betts | 2009-11-16 08:30:07 | Re: Absolute value of intervals |