Re: [PATCHES] pg_standby

From: Doug Knight <dknight(at)wsi(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCHES] pg_standby
Date: 2007-03-08 19:33:46
Message-ID: 1173382426.4829.50.camel@arc-dknightlx.wsicorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Excellent. Once you're ready, fire it over and I'll test it on our
config.

Doug
On Thu, 2007-03-08 at 18:34 +0000, Simon Riggs wrote:
> On Thu, 2007-03-08 at 13:29 -0500, Doug Knight wrote:
>
> > I would preserve the existing trigger function as little t "-t", and
> > maybe implement a catchup trigger function as big t "-T"? Set it up so
> > that if the first attempt to find the WAL file postgres is currently
> > requesting succeeds, skip over the trigger check. If the first attempt
> > fails, then do your trigger check. That way, in the OCF script, the
> > postmaster can be started, the trigger file set, and connection to the
> > database looped on until it succeeds as an indication for when the
> > database is up and available. I think that's cleaner than comparing a
> > filename from a 'ps' command. Once I've completed the OCF script and
> > done some testing, I'll forward it to you for you to review and see if
> > you want to include it.
>
> I'm happy to do this, unless other objections.
>
> I'll be doing another version before feature freeze.
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christian Bird 2007-03-08 20:10:22 who gets paid for this
Previous Message Luke Lonergan 2007-03-08 19:16:51 Re: Estimating seq_page_fetch and random_page_fetch

Browse pgsql-patches by date

  From Date Subject
Next Message Shane Ambler 2007-03-08 20:10:29 Re: Auto creation of Partitions
Previous Message Jim C. Nasby 2007-03-08 18:54:57 Re: Auto creation of Partitions