Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id E98671EA2927
	for <pgsql-admin@postgresql.org>; Sat,  9 Jun 2012 09:51:31 -0300 (ADT)
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1SdL8b-0002V2-0g
	for pgsql-admin@postgresql.org; Sat, 09 Jun 2012 12:51:31 +0000
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q59CpAu2026789;
	Sat, 9 Jun 2012 08:51:10 -0400 (EDT)
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Fujii Masao <masao.fujii@gmail.com>
cc: Lonni J Friedman <netllama@gmail.com>,
	Craig Ringer <ringerc@ringerc.id.au>,
	Jerry Sievers <gsievers19@comcast.net>,
	Magnus Hagander <magnus@hagander.net>, pgsql-admin@postgresql.org
Subject: Re: pg_basebackup blocking all queries with horrible performance
In-reply-to: 
 <CAHGQGwERsw_mmXcEktbkSC01cUs3-SXfQbNq5y5JDbMe8B=9RA@mail.gmail.com>
References: 
 <CAP=oouEy9xxa6biSnqNSJKMf0fuKsufiYjbz5SJyvj0gc0Qkiw@mail.gmail.com>
	<CAP=oouEu0sRCTvk+99wr-k3HG1vN3pyL4PXvVPQ+UZcAz6x2_g@mail.gmail.com>
	<CABUevEw9ax5SLaQYjf56gFM82SOfROMHHtWXQiMkbxVPrvxAFw@mail.gmail.com>
	<CAP=oouGeFVeDvEFa6DXf1YBwv-23rAh0PZ-5xOcezAFspC+gGg@mail.gmail.com>
	<874nqmy8cj.fsf@comcast.net>
	<CAP=oouF_gTLJvxQ8tK8czZ_wRF3Xt63j40LJnBfbHE26qfOYgg@mail.gmail.com>
	<4FD195F9.8080108@ringerc.id.au>
	<CAP=oouGZ4=B8fg6694urDoL-E7SsksOuTZGXmP_6UQ3T67vj5w@mail.gmail.com>
	<CAHGQGwERsw_mmXcEktbkSC01cUs3-SXfQbNq5y5JDbMe8B=9RA@mail.gmail.com>
Comments: In-reply-to Fujii Masao <masao.fujii@gmail.com>
	message dated "Sat, 09 Jun 2012 11:29:36 +0900"
Date: Sat, 09 Jun 2012 08:51:10 -0400
Message-ID: <26788.1339246270@sss.pgh.pa.us>
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201206/45
X-Sequence-Number: 39636

Fujii Masao <masao.fujii@gmail.com> writes:
> This seems a bug. I think we should prevent pg_basebackup from
> becoming synchronous standby. Thought?

Absolutely.  If we have replication clients that are not actually
capable of being standbys, there *must* be a way for the master
to know that.

			regards, tom lane