Re: Replication question - Mailing list pgsql-general

From Jeff Janes
Subject Re: Replication question
Date
Msg-id CAMkU=1xVFTbrXP-=uuRPLoWF3-J-=7uh8O6iER6g1nLqDRG2rA@mail.gmail.com
Whole thread Raw
In response to Replication question  (Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com>)
Responses RE: Replication question  (Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com>)
List 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 by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Replication question
Next
From: Scot Kreienkamp
Date:
Subject: RE: Replication question