Hi Simon,
Quick question on the -w option; setting it to zero "disables", do you
mean it waits until the file appears or a trigger file appears, or it
just doesn't wait at all?

Doug Knight
WSI Inc
Andover, MA

On Mon, 2007-01-22 at 13:06 +0000, Simon Riggs wrote:
> On Wed, 2007-01-17 at 16:15 +0000, Simon Riggs wrote:
> > On Wed, 2007-01-17 at 10:05 -0500, Merlin Moncure wrote:
> > > On 12/28/06, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> > > > On Thu, 2006-12-28 at 19:26 +0000, Simon Riggs wrote:
> > > > > On Thu, 2006-12-14 at 12:04 +0000, Simon Riggs wrote:
> > > > > > pg_standby and test framework, in separate .tar files
> > > > >
> > > > > New version (v2), following further testing.
> > > > >
> > > > > Signal handling not included in this version.
> > > >
> > > > Signal handling now added, tested and working correctly in version 3,
> > > > attached.
> > > >
> > > > pg_standby is an example program for a warm standby script as discussed
> > > > on -hackers:
> > > > http://archives.postgresql.org/pgsql-hackers/2006-08/msg00407.php
> > > >
> > > > Program looks complete and ready for review, to me.
> > > 
> > > I double checked and re-ran all my test and confirmed that pg_standby
> > > move (-m) mode is definitely busted in v3 in the sense that a restart
> > > of the standby will not resume recovery and requires a pg_resetxlog to
> > > become operational -- it needs one more WAL file back than  the oldest
> > > one available.
> > 
> > new v4
> > 
> > Changes
> > - removed -m command, design flaw in original spec, use -l instead
> > - added -k N command to cleanup archive and leave max N files
> > - fflush() points added to allow Windows debug 
> > - bug fix: when .history file present
> > - bug fix: command line switch cleanup
> > - readme updated
> 
> new v6 (v5 was Windows dev release)
> 
> Changes
> 
> - added -r option to specify maxretries
> - -l option for Windows Vista (only) using mklink
> - Windows examples and docs added to readme
> - code restructured to allow more easy customization
> - bug fix: -k 0 error fixed
> 
> - successful port report from Dave Page on Windows XP
> 

In response to

• Re: [PATCHES] pg_standby at 2007-01-22 13:06:53 from Simon Riggs

Responses

• Re: pg_standby at 2007-02-02 14:38:44 from Simon Riggs

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2007-02-01 20:19:34
	Subject: The may/can/might business
Previous:	From: Tom Lane	Date: 2007-02-01 19:59:07
	Subject: Re: Full page writes improvement

pgsql-patches by date

Next:	From: Jeremy Drake	Date: 2007-02-01 21:20:18
	Subject: writing new regexp functions
Previous:	From: Tom Lane	Date: 2007-02-01 19:59:07
	Subject: Re: Full page writes improvement