Re: Initial load from standby in logical replication.

2019-01-31 Thread Radoslav Nedyalkov
On Thu, Jan 31, 2019 at 4:09 PM Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > On 31/1/19 3:55 μ.μ., Radoslav Nedyalkov wrote: > > Hi All, > > We want to setup a logical replica with initial load from physical > standby. (all pg10.5) > > Basically what we tested is: > > 1.on the maste

Re: Initial load from standby in logical replication.

2019-01-31 Thread Achilleas Mantzios
On 31/1/19 3:55 μ.μ., Radoslav Nedyalkov wrote: Hi All, We want to setup a logical replica with initial load from physical standby. (all pg10.5) Basically what we tested is: 1.on the master: create publication and logical slot. 2.on the standby: pause the stanby. (lsn from 1. is already replayed

Initial load from standby in logical replication.

2019-01-31 Thread Radoslav Nedyalkov
Hi All, We want to setup a logical replica with initial load from physical standby. (all pg10.5) Basically what we tested is: 1.on the master: create publication and logical slot. 2.on the standby: pause the stanby. (lsn from 1. is already replayed). 3.on the standby: get last replayed lsn, pg_last