| From: | Chander Ganesan <chander(at)otg-nc(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Roberto Scattini <roberto(dot)scattini(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: standby questions |
| Date: | 2008-02-09 13:20:52 |
| Message-ID: | 47ADA8B4.4060804@otg-nc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Venks | 2008-02-09 14:23:32 | Re: Empty to NULL conversion - Ruby - Postgres ? |
| Previous Message | Simon Riggs | 2008-02-09 13:05:57 | Re: standby questions |