Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Streaming replication document improvements

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-docs(at)postgresql(dot)org
Subject: Re: [HACKERS] Streaming replication document improvements
Date: 2010-04-01 02:14:50
Message-ID: o2u3f0b79eb1003311914i6c9d896bic3d1b13152c6b0d8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
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

In response to

Responses

pgsql-docs by date

Next:From: Peter EisentrautDate: 2010-04-01 05:25:24
Subject: Re: confusing archive_command example
Previous:From: Robert HaasDate: 2010-04-01 02:00:16
Subject: Re: [DOCS] Streaming replication document improvements

pgsql-hackers by date

Next:From: David E. WheelerDate: 2010-04-01 02:33:49
Subject: Re: Alias to rollback keyword
Previous:From: Robert HaasDate: 2010-04-01 02:00:16
Subject: Re: [DOCS] Streaming replication document improvements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group