Re: Postgres 8.0 Backups

Tom Lane wrote:
> Scott Marlowe <smarlowe(at)g2switchworks(dot)com> writes:
> > On Mon, 2005-01-24 at 12:05, Tom Lane wrote:
> >> In the context of online backup operations, that advice isn't relevant
> >> anymore ...
>
> > Really, is this an 8.0 thing then, that I can make file system backups
> > and expect them to be coherent, or did I misunderhear what you meant and
> > this has to do with some other issue I'm not getting?
>
> No, it means that when doing PITR stuff you don't actually care that
> your base backup isn't consistent --- you expect WAL replay to fix it.
> See http://www.postgresql.org/docs/8.0/static/backup-online.html

Right, the big issue is that you have to be archiving the WAL logs
before you do the filesystem backup, and the WAL files will restore the
recovery to a consistent state.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073