Re: [GENERAL] Needing verification on instructions for streaming replication

Поиск
Список
Период
Сортировка
От Dave Florek
Тема Re: [GENERAL] Needing verification on instructions for streaming replication
Дата
Msg-id CA+M9YCkYRUR48EUDreuAsvV8Uor9WEuhMfmGvg+QtUtXks8JQw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Needing verification on instructions for streaming replication  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
I see. 

Thanks Jeff,

On Mon, Sep 11, 2017 at 2:38 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
On Mon, Sep 11, 2017 at 7:02 AM, Dave Florek <dave.a.florek@gmail.com> wrote:
Hi,

I'm trying to setup streaming replication on a cluster of postgresql databases and I followed the instructions outlined here (https://wiki.postgresql.org/wiki/Streaming_Replication) but I'm stuck on the archive and restore commands. In reading the comments from the archive command, WAL archiving needs a shared directory between the primary and standby machines in order to replicate. Is this something actually required? If so, does postgresql have any recommendations on where this shared directory ought to be hosted?

You can use streaming replication without any WAL archive at all.  If the only reason you want a WAL archive is so that the standby can fall behind the primary without losing the ability to catch back up again, then you can use a replication slot to make the primary hold onto WAL files until the standby is done with them.  That is going to be simpler than using a WAL archive, provided the master has enough room to keep them around should the standby fail for a while.

If you want a WAL archive for other reasons, then the choice of how to host it would depend on those reasons.

Cheers,

Jeff

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

Предыдущее
От: ""
Дата:
Сообщение: Re: [GENERAL] pg_restore error -- missing pg table
Следующее
От: Scott Marlowe
Дата:
Сообщение: [GENERAL] contrecord is requested