Re: WAL "low watermark" during base backup

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: WAL "low watermark" during base backup
Дата
Msg-id CABUevEz8NAXEE92ws7jA581ftSCqkDEXw2j+ZXdiT-KDAPyqpQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: WAL "low watermark" during base backup  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Ответы Re: WAL "low watermark" during base backup
Re: WAL "low watermark" during base backup
Список 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 по дате отправления:

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: WAL "low watermark" during base backup
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: regress test failed