Logical replication and xids - Mailing list pgsql-admin

From Natalie Wenz
Subject Logical replication and xids
Date
Msg-id E850EE71-E4FA-44A0-8A93-52CBDC948714@gmail.com
Whole thread Raw
List pgsql-admin
How is the initial snapshot executed in Postgres 10 logical replication? Mainly, I’m wondering if it would hold open a
transactionid on the publishing database the entire time.  

(I’m dealing with several databases that are quite large with tables I want to replicate that are up to 4 or 5 TB, and
I’mworried about running out of xids while the initial snapshot is sent.) 

Thank you,
Natalie

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Backup solution over unreliable network
Next
From: AYahorau@ibagroup.eu
Date:
Subject: pg_basebackup fails: could not receive data from WAL stream: server closedthe connection unexpectedly