Re: WAL Info messages

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

In response to

Responses

Browse pgsql-hackers by date

  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