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