Re: WAL log archival on standby

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: WAL log archival on standby
Дата
Msg-id CAB7nPqTyEh0B83fwqFGw2sK1HrLTJTuNODXE_mTcqgVP5y6oBw@mail.gmail.com
обсуждение исходный текст
Ответ на WAL log archival on standby  (James Sewell <james.sewell@lisasoft.com>)
Ответы Re: WAL log archival on standby  (Sameer Kumar <sameer.kumar@ashnik.com>)
Список pgsql-general


On Fri, Jun 19, 2015 at 2:38 PM, James Sewell <james.sewell@lisasoft.com> wrote:
Hey All,

Is it possible to create WAL archive files on standby servers when using streaming replication?

Yes and no, standbys do not archive WAL in ~9.4, but you could use archive_mode = 'always' with the upcoming 9.5.

I know I can use archive_command or pg_receivexlog - but these will both result in me sending information to the standby servers which has already been sent via standard streaming replication. This would result in a doubling of my network traffic.
Ideally I'd prefer to conserve this bandwidth and write the files to a local archive on any active standby.

Both methods you mentioned are the way to go for now I am afraid, or you wait for 9.5.
Regards,
--
Michael

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

Предыдущее
От: James Sewell
Дата:
Сообщение: WAL log archival on standby
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: valgrind