Rob Brucks <rob(dot)brucks(at)rackspace(dot)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