Re: Postgres 8.0 Backups

Tom Lane wrote:
> Scott Marlowe <smarlowe@g2switchworks.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073