Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 468F6632A2A;
	Wed, 31 Mar 2010 22:53:01 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024)
	with ESMTP id 69523-03; Thu,  1 Apr 2010 01:52:50 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f222.google.com (mail-fx0-f222.google.com
	[209.85.220.222])
	by mail.postgresql.org (Postfix) with ESMTP id 6FF3A6327B9;
	Wed, 31 Mar 2010 22:52:50 -0300 (ADT)
Received: by fxm22 with SMTP id 22so581558fxm.34
	for <multiple recipients>; Wed, 31 Mar 2010 18:52:48 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:received:message-id:subject:from:to:cc:content-type;
	bh=aEApxgShT38ouDV1LhSteTFCyCP6eP76D9LOxUb9HGE=;
	b=U60IMrY2l1LWXnDI6Md63KXetlnBkXfhWbBe+2VIb886jjbwAsH+gv07fiY5vjGDfR
	ETE87hFwYWt5aANJBQ0MDHyQZWSBo1MfqcBfp+L//a8+RXsRo1XTuyqelxFzRjjXsGLB
	htdXkrbLJychxtKlj+F4C9H/G66Xo7RVc33CE=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=uc15tEiLDxRFSlqkHrP6UnmjZbFg8O5P/iyl/b4byoXpflRUSSqwkEO0XOB6Ar8LQF
	XqqYjuPhOdFhgRd8t/UE+mx1GDPgU4dfCtHwkbPOAR+qBmGyUQ3IEMuKDchHtV57Qa7w
	Cv9ZpCnX+fJA1fE2osHHDV0i4/Q0rNo9Ivltc=
MIME-Version: 1.0
Received: by 10.239.161.83 with HTTP; Wed, 31 Mar 2010 18:52:48 -0700 (PDT)
In-Reply-To: <u2w3f0b79eb1003311850m50193801tb49b04966f5544d0@mail.gmail.com>
References: <3f0b79eb1003300152g5327eb47w8f9aecae6002b215@mail.gmail.com>
	<4BB3B2ED.5080606@enterprisedb.com>
	<u2w3f0b79eb1003311850m50193801tb49b04966f5544d0@mail.gmail.com>
Date: Wed, 31 Mar 2010 21:52:48 -0400
Received: by 10.239.184.7 with SMTP id w7mr735206hbg.25.1270086768092;
 Wed, 31
	Mar 2010 18:52:48 -0700 (PDT)
Message-ID: <t2m603c8f071003311852x3dd15512uc92e0865ba729548@mail.gmail.com>
Subject: Re: [DOCS] Streaming replication document improvements
From: Robert Haas <robertmhaas@gmail.com>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>,
	pgsql-docs@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.838 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, FS_REPLICA=1.041, SARE_SPEC_REPLICA=0.72
X-Spam-Level: 
X-Archive-Number: 201003/1327
X-Sequence-Number: 160103

On Wed, Mar 31, 2010 at 9:50 PM, Fujii Masao <masao.fujii@gmail.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.

...Robert