On-line backup and point-in-time recovery (PITR) - Mailing list pgsql-admin

From Enzo D'addario
Subject On-line backup and point-in-time recovery (PITR)
Date
Msg-id 1124418842.3492.34.camel@tuppy.pienetworks.com
Whole thread Raw
Responses Re: On-line backup and point-in-time recovery (PITR)  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Hi All,

I have a couple of questions regarding On-line backup and point-in-time
recovery (PITR) in the postgres documentation:

1.How is it that we can create a tar file of the PG Data directory
whilst postgres is running?

2.What happens with any DB inserts, updates, deletes etc that occur
between the SELECT pg_start_backup() and the end of the tar?
They would be already logged in the WAL files and already applied in the
tarball, do they then get duplicated during log replay in the recover
process?

Thanks In Advance


Enzo D'Addario...


pieNETWORK's Ltd...




pgsql-admin by date:

Previous
From: Guido Barosio
Date:
Subject: Re: How to Control the Persistence of A PostgreSQL Connection
Next
From: Bruce Momjian
Date:
Subject: Re: On-line backup and point-in-time recovery (PITR)