From:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To:
Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc:
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>,
Robert Haas <robertmhaas(at)gmail(dot)com>,
David Fetter <david(at)fetter(dot)org>, Bruce Momjian <bruce(at)momjian(dot)us>,
fazool mein <fazoolmein(at)gmail(dot)com>,
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Synchronous replication - patch status inquiry
Date:
2010-09-02 12:15:17
Message-ID:
4C7F9555.2000008@enterprisedb.com (view raw or flat )
Thread:
2010-08-31 21:34:05 from fazool mein <fazoolmein(at)gmail(dot)com>
2010-08-31 21:44:15 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-08-31 22:24:14 from David Fetter <david(at)fetter(dot)org>
2010-09-01 00:34:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-01 00:45:47 from David Fetter <david(at)fetter(dot)org>
2010-09-01 01:02:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-01 05:33:07 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-01 07:53:38 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-01 10:23:56 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-01 16:03:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-01 20:43:01 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-02 10:24:05 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-02 12:03:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-02 12:15:17 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-02 12:44:27 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-02 12:59:28 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-02 13:51:18 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-09-02 14:06:29 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-02 14:17:29 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-02 14:32:33 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-03 03:50:50 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-03 06:36:27 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-03 06:55:37 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-03 07:45:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-03 09:33:43 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-03 10:20:09 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-03 10:31:07 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-06 13:03:44 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-09-06 13:14:57 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-06 14:14:08 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-06 23:48:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-07 06:27:52 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-07 09:47:54 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-07 10:11:38 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-07 10:24:37 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-07 14:47:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-07 15:23:43 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-07 15:41:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-07 15:54:16 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-07 15:59:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-07 16:07:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-07 18:15:43 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-07 18:27:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-07 23:00:48 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-09-03 07:08:12 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-03 06:42:51 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-10 02:52:20 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-10 02:57:30 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-14 21:38:17 from David Fetter <david(at)fetter(dot)org>
2010-09-15 09:58:54 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-15 12:39:33 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-15 23:12:46 from "Erik Rijkers" <er(at)xs4all(dot)nl>
2010-09-15 23:58:21 from "Erik Rijkers" <er(at)xs4all(dot)nl>
2010-09-02 17:17:39 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2010-09-01 11:43:25 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-09-01 01:06:18 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-09-01 02:14:33 from fazool mein <fazoolmein(at)gmail(dot)com>
2010-09-01 00:35:47 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-hackers
On 02/09/10 15:03, Simon Riggs wrote:
> On Thu, 2010-09-02 at 19:24 +0900, Fujii Masao wrote:
>> On Wed, Sep 1, 2010 at 7:23 PM, Heikki Linnakangas
>> <heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
>>> That requirement falls out from the handling of disconnected standbys. If a
>>> standby is not connected, what does the master do with commits? If the
>>> answer is anything else than acknowledge them to the client immediately, as
>>> if the standby never existed, the master needs to know what standby servers
>>> exist. Otherwise it can't know if all the standbys are connected or not.
>>
>> Thanks. I understood why the registration is required.
>
> I don't. There is a simpler design that does not require registration.
>
> Please explain why we need registration, with an explanation that does
> not presume it as a requirement.
Please explain how you would implement "don't acknowledge commits until
they're replicated to all standbys" without standby registration.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
In response to
Responses
pgsql-hackers by date
Next :From: Simon RiggsDate: 2010-09-02 12:44:27Subject : Re: Synchronous replication - patch status inquiryPrevious :From : Michael HaggertyDate : 2010-09-02 12:13:28Subject : Re: git: uh-oh
