> On Feb 21, 2017, at 6:03 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > Rob Brucks <rob.brucks@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
