From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Cc: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Cc: greg@2ndQuadrant.com, Josh Berkus <josh@postgresql.org>
Cc: Hannu Krosing <hannu@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Sync Rep Design
Date: Sat, 01 Jan 2011 21:29:45 +0200
Message-ID: <4D1F80A9.1020203@enterprisedb.com> (raw)
In-Reply-To: <1293901428.1892.60565.camel@ebony>
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>
<m2ei8wy4ed.fsf@2ndQuadrant.fr>
<4D1F5838.8020509@kaltenbrunner.cc>
<1293901428.1892.60565.camel@ebony>
On 01.01.2011 19:03, Simon Riggs wrote:
> On Sat, 2011-01-01 at 17:37 +0100, Stefan Kaltenbrunner wrote:
>> On 01/01/2011 05:28 PM, Dimitri Fontaine wrote:
>>> 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.
>>
>> well as jeff janes already said - anything that requires the master to
>> still exist is not useful for a desaster.
>
> Nobody has suggested that the master needs to still exist after a
> disaster.
Dimitri just did, see above. I agree it's not very useful.
I don't think there's any other solution to knowing which standby is
ahead than connect to both standbys and ask how far each is. I don't see
a problem with that, whatever middleware handles the failover and
STONITH etc. should be able to do that too.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: heikki.linnakangas@enterprisedb.com, simon@2ndQuadrant.com, stefan@kaltenbrunner.cc, dimitri@2ndQuadrant.fr, josh@postgresql.org, hannu@2ndquadrant.com, robertmhaas@gmail.com
Subject: Re: Sync Rep Design
In-Reply-To: <4D1F80A9.1020203@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox