Re: [ADMIN] On-line backup and point-in-time recovery (PITR)

2005-08-18 Thread Alvaro Herrera
On Thu, Aug 18, 2005 at 11:01:27PM -0400, Bruce Momjian wrote: > Enzo D'addario wrote: > > 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 t

Re: [ADMIN] On-line backup and point-in-time recovery (PITR)

2005-08-18 Thread Bruce Momjian
Enzo D'addario wrote: > 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? Whe pg_xlog archived files contain inf

[ADMIN] On-line backup and point-in-time recovery (PITR)

2005-08-18 Thread Enzo D'addario
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 betwee