Re: WAL "low watermark" during base backup - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: WAL "low watermark" during base backup
Date
Msg-id CABUevEz8NAXEE92ws7jA581ftSCqkDEXw2j+ZXdiT-KDAPyqpQ@mail.gmail.com
Whole thread Raw
In response to Re: WAL "low watermark" during base backup  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: WAL "low watermark" during base backup
Re: WAL "low watermark" during base backup
List pgsql-hackers
On Fri, Sep 9, 2011 at 13:40, Dimitri Fontaine <dimitri@2ndquadrant.fr> wrote:
> Magnus Hagander <magnus@hagander.net> writes:
>>> If you must have this then make pg_basebackup copy xlog files
>>> regularly during the backup. That way your backup can take forever and
>>> your primary disk won't fill up. In many cases it actually will take
>>> forever, but at least we don't take down the primary.
>>
>> There is a patch to do something like that as well sitting on the CF
>> page. I don't believe one necessarily excludes the other.
>
> I'm not getting why we need the later one when we have this older one?

One of them is for the simple case. It requires a single connection to
the server, and it supports things like writing to tarfiles and
compression.

The other one is more compelx. It uses multiple connections (one for
the base, one for the xlog), and as such doesn't support writing to
files, only directories.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: WAL "low watermark" during base backup
Next
From: Peter Eisentraut
Date:
Subject: Re: regress test failed