| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
| Cc: | Steve Poe <steve(dot)poe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Planning hot/live backups? |
| Date: | 2008-03-24 22:23:48 |
| Message-ID: | 3769.1206397428@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"Matthew T. O'Connor" <matthew(at)zeut(dot)net> writes:
> Steve Poe wrote:
>> The owners of the animal hospital where I work at want to consider live/hot
>> backups through out the day so we're less likely to lose a whole
>> day of transaction. We use Postgresql 8.0.15. We do 3AM
>> backups, using pg_dumpall, to a file when there is very little activity.
> You probably want to look into PITR, you can have a constant ongoing
> backup of your data and never lose more than a few minutes of data. The
> overhead isn't all the big especially if you are shipping the log files
> to a separate server.
But note that you really need to update to a newer major release before
depending on PITR. While 8.0 nominally has support for it, it's taken
us several releases to really get the operational gotchas sorted out.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2008-03-24 22:28:27 | Re: Planning hot/live backups? |
| Previous Message | paul rivers | 2008-03-24 21:22:49 | Re: Planning hot/live backups? |