Re: Replication question

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Replication question
Дата
Msg-id CAMkU=1xVFTbrXP-=uuRPLoWF3-J-=7uh8O6iER6g1nLqDRG2rA@mail.gmail.com
обсуждение исходный текст
Ответ на Replication question  (Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com>)
Ответы RE: Replication question
Список pgsql-general


On Mon, Oct 22, 2018, 9:54 AM Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com> wrote:

Hi everyone,

 

We just moved to PG9.6 from 9.1 (yeah, not my choice to wait this long).  In 9.1 I had to make the archive location (NFS in my case) available to all the mirrors running PG so that they could catch up whenever they fell behind.  I thought I read somewhere that in 9.6, as long as the WAL log is available on disk or in the archive the replication server will provide that to the replication client, and my archive NFS mount didn’t have to be available to all replication clients.  It doesn’t seem to be operating that way though.  Did I completely remember that wrong or did I misunderstand something?


The master won't read from the archives for you in order to send to an replica.  But using replication slots, you can keep the needed log files right in pg_xlog/pg_wal until all replicas get what they need (assuming the disk is large enough).  Then you don't need an archive at all for replication purposes, still might for pitr purposes.

Perhaps this is what you heard about.

Cheers,

Jeff


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

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Replication question
Следующее
От: Scot Kreienkamp
Дата:
Сообщение: RE: Replication question