Re: [GENERAL] NOTIFY command impact - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] NOTIFY command impact
Date
Msg-id 16721.1487718232@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] NOTIFY command impact  (Rob Brucks <rob.brucks@rackspace.com>)
Responses Re: [GENERAL] NOTIFY command impact  (Rob Brucks <rob.brucks@rackspace.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] NOTIFY command impact
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] NOTIFY command impact