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

Re: [PATCHES] pg_standby

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Doug Knight <dknight(at)wsi(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCHES] pg_standby
Date: 2007-04-02 22:29:15
Message-ID: 200704022229.l32MTF210810@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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.

Should we be getting a patch for this for 8.3?

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-04-02 22:37:11
Subject: Re: Bug in UTF8-Validation Code?
Previous:From: Bruce MomjianDate: 2007-04-02 22:25:48
Subject: Re: Grouped Index Tuples / Clustered Indexes

pgsql-patches by date

Next:From: Bruce MomjianDate: 2007-04-02 22:47:06
Subject: Re: Updateable cursors patch
Previous:From: Bruce MomjianDate: 2007-04-02 22:19:52
Subject: Re: Warning about LISTEN names

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