Logical replication and xids

Поиск
Список
Период
Сортировка
От Natalie Wenz
Тема Logical replication and xids
Дата
Msg-id E850EE71-E4FA-44A0-8A93-52CBDC948714@gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Backup solution over unreliable network
Следующее
От: AYahorau@ibagroup.eu
Дата:
Сообщение: pg_basebackup fails: could not receive data from WAL stream: server closedthe connection unexpectedly