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 01:58:05
Message-ID: g2z3f0b79eb1003311858y7f781c7u99e09e32c96aa79b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
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?

Regards,

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

In response to

Responses

pgsql-docs by date

Next:From: Robert HaasDate: 2010-04-01 02:00:16
Subject: Re: [DOCS] Streaming replication document improvements
Previous:From: Robert HaasDate: 2010-04-01 01:52:48
Subject: Re: [DOCS] Streaming replication document improvements

pgsql-hackers by date

Next:From: Robert HaasDate: 2010-04-01 02:00:16
Subject: Re: [DOCS] Streaming replication document improvements
Previous:From: Robert HaasDate: 2010-04-01 01:52:48
Subject: Re: [DOCS] Streaming replication document improvements

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