Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 25A351337B56
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Sat,  1 Jan 2011 12:29:04 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024)
	with ESMTP id 55194-06; Sat,  1 Jan 2011 16:28:56 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from acidenitrix.villemain.org (acidenitrix.villemain.org
	[91.121.90.165])
	by mail.postgresql.org (Postfix) with ESMTP id BE4581337B50;
	Sat,  1 Jan 2011 12:28:56 -0400 (AST)
Received: from 89-158-241-48.rev.dartybox.com ([89.158.241.48]
	helo=DimIMac.local) by acidenitrix.villemain.org with esmtpsa
	(TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69)
	(envelope-from <dimitri@2ndQuadrant.fr>)
	id 1PZ4K0-0005FP-JO; Sat, 01 Jan 2011 17:28:48 +0100
Received: by DimIMac.local (Postfix, from userid 501)
	id 1508A1600B65; Sat,  1 Jan 2011 17:28:42 +0100 (CET)
From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Cc: Simon Riggs <simon@2ndQuadrant.com>,
	Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>,
	greg@2ndQuadrant.com, Josh Berkus <josh@postgresql.org>,
	Hannu Krosing <hannu@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>,
	pgsql-hackers@postgresql.org
Subject: Re: Sync Rep Design
Organization: 2ndQuadrant
References: <1293729972.1892.23804.camel@ebony>
	<4D1CC47E.7050207@kaltenbrunner.cc>
	<1293735853.1892.24886.camel@ebony>
	<AANLkTi=SvN2KQ1Tzh-tRKcXD0i2FyWFBbbR=kXXdepqN@mail.gmail.com>
	<4D1D8B2F.5070001@2ndquadrant.com> <4D1DAB14.5000800@enterprisedb.com>
	<1293796137.1892.37313.camel@ebony>
	<4D1DCF5A.7070808@enterprisedb.com>
	<1293822959.1892.43164.camel@ebony> <4D1F332A.90306@kaltenbrunner.cc>
User-Mail-Address: dimitri@2ndQuadrant.fr
Date: Sat, 01 Jan 2011 17:28:42 +0100
In-Reply-To: <4D1F332A.90306@kaltenbrunner.cc> (Stefan Kaltenbrunner's message
	of "Sat, 01 Jan 2011 14:59:06 +0100")
Message-ID: <m2ei8wy4ed.fsf@2ndQuadrant.fr>
User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/24.0.50 (darwin)
MIME-Version: 1.0
Content-Type: text/plain
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201101/16
X-Sequence-Number: 177853

Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> well you keep saying that but to be honest I cannot really even see a
> usecase for me - what is "only a random one of a set of servers is sync at
> any time and I don't really know which one".

It looks easy enough to get to know which one it is.  Surely the primary
knows and could update something visible through a system view for
users?  This as been asked for before and I was thinking there was a
consensus on this.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support