Re: standby questions

[Chander Ganesan <chander@xxxxxxxxxx>]

Simon Riggs wrote:

On Sat, 2008-02-09 at 07:49 -0500, Chander Ganesan wrote:

  

Signalling components could be added to pg_standby at some point...
    

What sort of thing are you looking for?

pg_standby accepts a trigger file as well as various types of signal

I didn't see anything about signals in the documentation at (http://www.postgresql.org/docs/8.3/static/pgstandby.html). 

We use signals in shell scripts to trigger (in some cases) a WAL copy, and in others an immediate wake-from-sleep to copy a final WAL file to trigger a failover.

-- 
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
Phone: 877-258-8987/919-463-0999
http://www.otg-nc.com