Re: NOTIFY/LISTEN on read-only slave? - Mailing list pgsql-hackers

From Greg Smith
Subject Re: NOTIFY/LISTEN on read-only slave?
Date
Msg-id 4B7CAE64.1020706@2ndquadrant.com
Whole thread Raw
In response to Re: NOTIFY/LISTEN on read-only slave?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: NOTIFY/LISTEN on read-only slave?
Re: NOTIFY/LISTEN on read-only slave?
Re: NOTIFY/LISTEN on read-only slave?
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
>   
>> Our documentation says listen/notify will return an error if executed on
>> the hot standby server:
>>     
>>     o LISTEN, UNLISTEN, NOTIFY since they currently write to system tables 
>>     
>> With the listen/notify system now implemented in memory, is this still
>> true?
>>     
>
> The explanation is wrong, but it's still disallowed.
>   

What's the actual reason for the restriction then?  I did a whole 
proofreading round on the HS documentation the other day and am working 
on a patch to clean up everything I found, can add better notes about 
this to it.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: CommitFest Status Summary - 2010-02-14
Next
From: Greg Smith
Date:
Subject: Re: NOTIFY/LISTEN on read-only slave?