Re: [HACKERS] Streaming replication and WAL archive interactions

Поиск
Список
Период
Сортировка
От Миша Тюрин
Тема Re: [HACKERS] Streaming replication and WAL archive interactions
Дата
Msg-id 1423700116.172180820@f103.i.mail.ru
обсуждение исходный текст
Ответ на Re: Streaming replication and WAL archive interactions  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Дерево обсуждения

> This should be a very common setup in the field, so how are people doing it in practice?

One of possible workaround with archive and streaming was to use pg_receivexlog from standby to copy/save WALs to archive. but with pg_receivexlog was also issue with fsync.


[ master ] -- streaming --> [ standby ] -- pg_receivexlog --> [ /archive ]


In that case archive is always in pre standby state and it could be better than had archive broken on promote.
--
Misha

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: libpq's multi-threaded SSL callback handling is busted
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Typo in logicaldecoding.sgml