Re: [HACKERS] Streaming replication document improvements

On Thu, Apr 1, 2010 at 11:00 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Wed, Mar 31, 2010 at 9:58 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>> On Thu, Apr 1, 2010 at 10:52 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>>> On Wed, Mar 31, 2010 at 9:50 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>>>>> That's an interesting point, do streaming replication connections
>>>>> consume superuser_reserved_connections slots?
>>>>
>>>> Yes. Since SR connection is superuser connection, setting
>>>> superuser_reserved_connections appropriately would be useful
>>>> to prevent non-superuser connections from blocking the connection
>>>> from the standby.
>>>
>>> I think this is wacky, especially since we'd someday like to have
>>> replication be a separate privilege from superuser.  I think we should
>>> change this.
>>
>> You mean that we should change replication connection not to consume
>> superuser_reserved_connections slots in 9.0?
>
> Yes.

Preventing superuser connections from consuming superuser_reserved_connections
slots seems strange for me. So I'm leaning toward just removing superuser
privilege from replication connection again. Thought?

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center