Re: Warm standby failover mechanism - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Warm standby failover mechanism
Date
Msg-id 1235577256.16842.6.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Re: Warm standby failover mechanism  (Thom Brown <thombrown@gmail.com>)
Responses Re: Warm standby failover mechanism
List pgsql-general
On Wed, 2009-02-25 at 13:54 +0000, Thom Brown wrote:
> I'm still trying to work out how this file creation/deletion thing
> will work.  If I can tag a "&& touch /tmp/pg.trigger" command to the
> end of the recovery command, how often will that be called?  If I
> can't, I still need to ensure that it is created and deleted before
> the recovery command is called, otherwise it will see it before it is
> deleted and put itself online.
>
> Has anyone got a practical example of what they've set up, or know
> what others have set up?

You are doing this the hard way. Grab PITRTTools.

https://projects.commandprompt.com/public/pitrtools

Just pull down the stable branch:

svn co
https://projects.commandprompt.com/public/pitrtools/repo/branches/1.2

Sincerely,

Joshua D. Drake


--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


pgsql-general by date:

Previous
From: Andreas Wenk
Date:
Subject: cursor question
Next
From: Pavel Stehule
Date:
Subject: Re: cursor question