From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Switch pg_basebackup to use -X stream instead of -X fetch by default? |
Date: | 2014-08-26 16:53:21 |
Message-ID: | CABUevExF5yMVrjhT2jahcBRN6LbJM8YQaqgZb-KykbWo3W_pAA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Aug 26, 2014 at 6:51 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> On 2014-08-26 18:40:27 +0200, Magnus Hagander wrote:
>> On Mon, Aug 25, 2014 at 1:35 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
>> > Hi,
>> >
>> > currently pg_basebackup uses fetch mode when only -x is specified -
>> > which imo isn't a very good thing to use due to the increased risk of
>> > not fetching everything.
>> > How about switching to stream mode for 9.5+?
>>
>> I think the original reasons were to not change the default behaviour
>> with a new feature, and secondly because defaulting to -X requires two
>> replication connections rather than one.
>
> Right.
>
>> I think the first reason is gone now, and the risk/damage of the two
>> connections is probably smaller than running out of WAL.
>
> Especially as that will fail pretty nearly immediately instead at the
> end of the basebackup...
Yeah, I don't think the problem was actually pg_basebackup failing as
much as pg_basebackup getting in the way of regular replication
standbys. Which I think is also a smaller problem now, given that it's
a more "common thing" to do backups through replication protocol.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2014-08-26 17:58:55 | Re: Proposal for CSN based snapshots |
Previous Message | Andres Freund | 2014-08-26 16:51:55 | Re: Switch pg_basebackup to use -X stream instead of -X fetch by default? |