| From: | François Beaulieu <frank(at)TZoNE(dot)ORG> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Rob Brucks <rob(dot)brucks(at)rackspace(dot)com>, "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-22 00:02:28 |
| Message-ID: | 52ADE82A-A208-40F2-B061-3A70ADF0FE1E@TZoNE.ORG |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Feb 21, 2017, at 6:03 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> 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
>
Are we sure that replication slaves can have listeners? When I tried it on 9.4.10, I got the following message:
"ERROR: cannot execute LISTEN during recovery"
-=Frank
| From | Date | Subject | |
|---|---|---|---|
| Next Message | François Beaulieu | 2017-02-22 00:05:06 | Re: NOTIFY command impact |
| Previous Message | Patrick B | 2017-02-21 23:41:34 | Re: bloat indexes - opinion |