Re: Online base backup from the hot-standby - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Online base backup from the hot-standby
Date
Msg-id CAHGQGwGPBN91LuJA7ViReTbL1mohZkEQCpYHrcEFG5rfABkQ-A@mail.gmail.com
Whole thread Raw
In response to Re: Online base backup from the hot-standby  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Online base backup from the hot-standby
List pgsql-hackers
On Tue, Oct 25, 2011 at 7:19 PM, Magnus Hagander <magnus@hagander.net> wrote:
> I don't think we should necessarily give up completely. But doing a
> pg_basebackup way *first* seems reasonable - because it's going to be
> the easiest one to "get right", given that we have more control there.
> Doesn't mean we shouldn't extend it in the future...

Agreed. The question is -- how far should we change pg_basebackup to
"get right"? I think it's not difficult to change it so that it backs up
the control file at the end. But eliminating the need for full_page_writes=on
seems not easy. No? So I'm not inclined to do that in at least first commit.
Otherwise, I'm afraid the patch would become huge.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Idea: Always consistent in-database cache using SSI mechanisms
Next
From: Magnus Hagander
Date:
Subject: Re: Online base backup from the hot-standby