[HACKERS] Waiting for archive to complete

2007-06-25 Thread Simon Riggs
A number of people have complained that it is possible to make a base backup and then shutdown the server before the last xlog file has been archived. Others say they would like to be able to make a backup and know it is complete. Making the archiver continue while the file is archived can cause

Re: [HACKERS] Waiting for archive to complete

2007-06-25 Thread Simon Riggs
On Mon, 2007-06-25 at 18:14 -0400, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: A simple solution is to introduce a new function: pg_archive_wait(integer maxwait); maxwait = 0 means wait forever, otherwise time measured in seconds. maxwait is redundant; people who want a