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