pg_standby exit codes

From: Mike Williams <mike(dot)williams(at)comodo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_standby exit codes
Date: 2009-05-06 12:12:31
Message-ID: 200905061312.31587.mike.williams@comodo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hey all,

For a variety of reasons, that aren't relevant here, I have had to implement
my own version of pg_standby.
At the moment it puts the WAL in the right place and "exit 0". Postgres then
processes it, and calls pg_standby again, as it should. It'll do this
basically forever.
It has a test for a "trigger" file which causes it to exit 1, making postgres
stop recovering and start.
I would very much like to be able to make pg_standby cause postgres to cleanly
shutdown, with or without removing recovery.conf. Is there a magic exit code
I can use to do this? Or a pg_ctl option to stop recovering and shutdown?

Thanks

--
Mike Williams

Browse pgsql-admin by date

  From Date Subject
Next Message Félix Sánchez Rodríguez 2009-05-06 12:14:46 Re: Creating functions
Previous Message Scott Marlowe 2009-05-06 09:48:51 Re: Pg_dump consistency.