On 12/28/06, Simon Riggs <[EMAIL PROTECTED]> 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,

pg_standby is an example program for a warm standby script as discussed
on -hackers:

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.

I am currently working around this by rotating WAL files a couple of
versions back in the shell script I am using to receive log files via
netcat.  move mode is very desirable because it keeps the maintenance
down for the standby system.


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to