Re: NOTIFY/LISTEN on read-only slave?

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: NOTIFY/LISTEN on read-only slave?
Дата
Msg-id 4B7CAE64.1020706@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: NOTIFY/LISTEN on read-only slave?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: NOTIFY/LISTEN on read-only slave?  (Greg Smith <greg@2ndquadrant.com>)
Re: NOTIFY/LISTEN on read-only slave?  (Bruce Momjian <bruce@momjian.us>)
Re: NOTIFY/LISTEN on read-only slave?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: CommitFest Status Summary - 2010-02-14
Следующее
От: Greg Smith
Дата:
Сообщение: Re: NOTIFY/LISTEN on read-only slave?