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