> On Feb 21, 2017, at 6:03 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > Rob Brucks <rob.bru...@rackspace.com> writes: >> If a notify is sent and then PG is immediately shut down, wouldn't PG want >> to save that message for processing after startup? >> Or is the message just discarded? > > NOTIFY data is not saved across a shutdown or crash. > > (The reason it goes into the WAL stream is so that you can have listeners > on replication slaves, not for recovery purposes.) > > regards, tom lane >
Are we sure that replication slaves can have listeners? When I tried it on 9.4.10, I got the following message: "ERROR: cannot execute LISTEN during recovery" -=Frank -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general