Re: Sending notifications from the master to the standby
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joachim Wieland <joe@mcknight.de>
Cc: Simon Riggs <simon@2ndquadrant.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-01-11T03:02:43Z
Lists: 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