Re: Postgres 8.0 Backups - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgres 8.0 Backups
Date
Msg-id 23396.1106591414@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres 8.0 Backups  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Postgres 8.0 Backups  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
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

            regards, tom lane

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Postgres 8.0 Backups
Next
From: "Kavan, Dan (IMS)"
Date:
Subject: Re: benchmarks with pgbench