Re: Replication question

2018-10-23 Thread Jeff Janes
On Mon, Oct 22, 2018 at 1:20 PM Scot Kreienkamp < scot.kreienk...@la-z-boy.com> wrote: > I remember thinking it was pulling from archive with the restore command > if necessary to augment what it had on disk. If that was the case I wanted > to configure it. I don’t care for the replication slots

Re: Replication question

2018-10-22 Thread Andres Freund
Hi, On 2018-10-22 13:53:40 +, Scot Kreienkamp wrote: > 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 >

RE: Replication question

2018-10-22 Thread Scot Kreienkamp
General Subject: Re: Replication question On Mon, Oct 22, 2018, 9:54 AM Scot Kreienkamp mailto:scot.kreienk...@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 a

Re: Replication question

2018-10-22 Thread Jeff Janes
On Mon, Oct 22, 2018, 9:54 AM Scot Kreienkamp 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 fel

RE: Replication question

2018-10-22 Thread Scot Kreienkamp
Seiler [mailto:d...@seiler.us] Sent: Monday, October 22, 2018 9:58 AM To: Scot Kreienkamp Cc: Postgres General Subject: Re: Replication question 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

Re: Replication question

2018-10-22 Thread Andreas Kretschmer
Am 22.10.2018 um 15:53 schrieb Scot Kreienkamp: 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 cl

Re: Replication question

2018-10-22 Thread Don Seiler
> > 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. > Streaming replication will only rea