> On Feb 21, 2017, at 6:03 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Rob Brucks <rob.brucks@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