Thanks Tom,
Can you answer my original question too:
If I am issuing NOTIFY commands every 30 seconds (and immediately committing) and there are no listeners, will that have a negative impact on the cluster?
I'm using the NOTIFY to force streaming replication to update the "pg_last_xact_replay_timestamp" on the slaves so we can more accurately monitor replication lag on quiet systems.
Thanks,
Rob
On 2/21/17, 5: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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
