Re: Shutting down server from a backend process, e.g. walrceiver

On Mon, Sep 20, 2010 at 05:48:40PM -0700, fazool mein wrote:
> Hi,
>
> I want to shut down the server under certain conditions that can be
> checked inside a backend process.  For instance, while running
> symmetric

Synchronous?

> replication, if the primary dies, I want the the walreceiver to
> detect that and shutdown the standby.  The reason for shutdown is
> that I want to execute some other stuff before I start the standby
> as a primary.  Creating a trigger file doesn't help as it converts
> the standby into primary at run time.
>
> Using proc_exit() inside walreceiver only terminates the walreceiver
> process, which postgres starts again.  The other way I see is using
> ereport(PANIC, ...).  Is there some other way to shutdown the main
> server from within a backend process?

Perhaps I've misunderstood, but since there's already Something
Else(TM) which takes actions, why not send a message to it so it can
take appropriate action on the node, starting with shutting it down?