Postgres Pro
Downloads
Home   >   mailing lists

Initial load from standby in logical replication. - Mailing list pgsql-general

From Radoslav Nedyalkov
Subject Initial load from standby in logical replication.
Date
Msg-id CANhtRibUuueF_xdSrP7MNwY42Ek=AH3-ogVxwd6mg87WGL+aBQ@mail.gmail.com
Whole thread Raw
Responses Re: Initial load from standby in logical replication.  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-general
Tree view
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_wal_replay_lsn().
4.export/import the data into the logical replica.
5.on the logical replica: create subscription with pg_replication_origin_advance'd to the lsn from 3.
6.on the logical replica: enable subscription.

On a test setup with some bulk inserts results are encouraging. 
Still we're not that confident. Does the procedure looks okay?
What if standby is paused at COMMIT lsn?

Thanks!
Radoslav Nedyalkov






pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: problem
Next
From: Achilleas Mantzios
Date:
Subject: Re: Initial load from standby in logical replication.