Re: Proposal for 9.1: WAL streaming from WAL buffers - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Proposal for 9.1: WAL streaming from WAL buffers
Date
Msg-id AANLkTimQ1tbfFrN-iwGywFvV5l7kpGHMdE3C26Z5KQEa@mail.gmail.com
Whole thread Raw
In response to Re: Proposal for 9.1: WAL streaming from WAL buffers  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Proposal for 9.1: WAL streaming from WAL buffers  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
On Mon, Jun 14, 2010 at 8:41 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> On Mon, Jun 14, 2010 at 8:10 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>> Maybe.  That sounds like a pretty enormous foot-gun to me, considering
>> that we have no way of recovering from the situation where the standby
>> gets ahead of the master.
>
> No, we can do that by reconstructing the standby from the backup.
>
> And, that situation is not a problem for users including me who prefer to
> perform a failover when the master goes down.

You don't get to pick - if a backend crashes on the master, it will
restart right away and come up, but the slave will now be hosed...

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [v9.1] add makeRangeTblEntry() into makefuncs.c
Next
From: Tom Lane
Date:
Subject: Re: pg_dump(all) --quote-all-identifiers