Re: NOTIFY command impact

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rob Brucks <rob(dot)brucks(at)rackspace(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: NOTIFY command impact
Date: 2017-02-21 23:03:52
Message-ID: 16721.1487718232@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-02-21 23:05:38 Re: NOTIFY command impact
Previous Message Adrian Klaver 2017-02-21 22:55:00 Re: NOTIFY command impact