Re: Sending notifications from the master to the standby - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Sending notifications from the master to the standby
Date
Msg-id 6064.1326250963@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sending notifications from the master to the standby  (Joachim Wieland <joe@mcknight.de>)
Responses Re: Sending notifications from the master to the standby  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Joachim Wieland <joe@mcknight.de> writes:
> On Tue, Jan 10, 2012 at 11:55 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Simon Riggs <simon@2ndQuadrant.com> writes:
>>> Suggest we add something to initial handshake from standby to say
>>> "please send me notify traffic",

>> +1 on that.

> From what you said I imagined this walsender listener as a regular
> listener that listens on the union of all sets of channels that
> anybody is listening on on the standby, with the LISTEN transaction on
> the standby return from commit once the listener is known to have been
> set up on the master.

This seems vastly overcomplicated too.  I'd just vote for a simple
yes/no flag, so that receivers that have no interest in notifies don't
have to deal with them.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stefan Keller
Date:
Subject: Re: Real-life range datasets
Next
From: Tom Lane
Date:
Subject: Re: Sending notifications from the master to the standby