Re: [HACKERS] Interaction of PITR backups and Bulk operationsavoiding WAL

2007-03-09 Thread Csaba Nagy
On Fri, 2007-03-09 at 17:47, Tom Lane wrote: > I don't think that people are very likely to need to turn archiving on > and off on-the-fly. We did need occasionally to turn archiving on on-the-fly. It did happen that I started up a new DB machine and I did not have yet the log archive available, s

Re: [HACKERS] Interaction of PITR backups and Bulk operationsavoiding WAL

2007-03-09 Thread Andreas Pflug
Tom Lane wrote: > "Simon Riggs" <[EMAIL PROTECTED]> writes: > >> On Fri, 2007-03-09 at 11:15 -0500, Tom Lane wrote: >> >>> It strikes me that allowing archive_command to be changed on the fly >>> might not be such a good idea though, or at least it shouldn't be >>> possible to flip it from

Re: [HACKERS] Interaction of PITR backups and Bulk operationsavoiding WAL

2007-03-09 Thread Tom Lane
"Simon Riggs" <[EMAIL PROTECTED]> writes: > On Fri, 2007-03-09 at 11:15 -0500, Tom Lane wrote: >> It strikes me that allowing archive_command to be changed on the fly >> might not be such a good idea though, or at least it shouldn't be >> possible to flip it from empty to nonempty during live opera

Re: [HACKERS] Interaction of PITR backups and Bulk operationsavoiding WAL

2007-03-09 Thread Simon Riggs
On Fri, 2007-03-09 at 11:15 -0500, Tom Lane wrote: > "Simon Riggs" <[EMAIL PROTECTED]> writes: > > Say you issue COPY, CREATE INDEX etc.. > > pg_start_backup() > > pg_stop_backup() > > ...then bulk operation ends. > > This will result in a base backup that does not contain the data written > > duri