Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] pg_standby

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
Cc: "Dave Page" <dpage(at)postgresql(dot)org>,<pgsql-patches(at)postgresql(dot)org>,"Doug Knight" <dknight(at)wsi(dot)com>
Subject: Re: [PATCHES] pg_standby
Date: 2007-01-22 13:06:53
Message-ID: 1169471213.3776.262.camel@silverbirch.site (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com


Attachment: pg_standby.v6.tar
Description: application/x-tar (30.0 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Merlin MoncureDate: 2007-01-22 14:25:35
Subject: Re: savepoint improvements
Previous:From: Michael MeskesDate: 2007-01-22 12:11:39
Subject: Re: Strange file in snapshot tarball

pgsql-patches by date

Next:From: Tom LaneDate: 2007-01-22 16:01:56
Subject: Re: server process (PID xxx) was terminated by signal 7
Previous:From: Achilleas MantziosDate: 2007-01-22 11:12:04
Subject: server process (PID xxx) was terminated by signal 7

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group