Re: Estimating WAL usage during pg_basebackup

Поиск
Список
Период
Сортировка
От Sameer Kumar
Тема Re: Estimating WAL usage during pg_basebackup
Дата
Msg-id CADp-Sm4gXYO6POirBMMSpVZQ1ouA5v2TEMBfKzLJnkVCsP8bgA@mail.gmail.com
обсуждение исходный текст
Ответ на Estimating WAL usage during pg_basebackup  (Mike Blackwell <mike.blackwell@rrd.com>)
Список pgsql-general

On Fri, Oct 31, 2014 at 2:52 AM, Mike Blackwell <mike.blackwell@rrd.com> wrote:
I need to get an idea of how much WAL space will be required during a long (many hours) pg_basebackup over a relatively slow network connection.  This is for a server that's not yet running PITR / streaming.

Any thoughts?

​You may want to explore
--xlog-method=method

This will enable you to 'fetch' wals at end of backup (which means you should guess wal_keep_segment properly)​
 

Or you can 'stream' them which means WALs will be backed up in parallel. This may introduce contention on network and hence may slow it down but you will not have to guess wal_keep_segment​. See if this helps you.




В списке pgsql-general по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Avoiding deadlocks when performing bulk update and delete operations
Следующее
От: Sameer Kumar
Дата:
Сообщение: Re: is there a warm standby sync trigger?