From: | Greg Stark <gsstark(at)mit(dot)edu> |
---|---|
To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: WAL Info messages |
Date: | 2009-12-14 05:13:57 |
Message-ID: | 407d949e0912132113l2ebac358xec66c7e06802043a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, Dec 13, 2009 at 7:20 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Standby side, we would provide a plugin interface to allow the
> message to be read and handled by user-written code. This would then
> allow a simple value or notification to be passed to a waiting (polling)
> connection on standby. If new LISTEN/NOTIFY gets into 8.5 then this
> would be an obvious fit, but I have no need for message passing, just
> info passing, so no need to wait for that; something much simpler.
What happens on the slave when normal NOTIFYs are generated on the
master? IIRC NOTIFYs are wal-logged so I imagine LISTEN on the slave
would just work and a plain old NOTIFY/LISTEN would suffice for this
use case?
--
greg
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2009-12-14 05:35:21 | Re: Row-Level Security |
Previous Message | KaiGai Kohei | 2009-12-14 04:57:22 | Re: Row-Level Security |