[Logical replication] Does the initial table data copy break the transactional replication?

From: Jinhua Luo <luajit(dot)io(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: [Logical replication] Does the initial table data copy break the transactional replication?
Date: 2018-11-22 08:31:14
Message-ID: CAAc9rOzkJkALFHX7BWB_77JMuXbbUALp3nQUnAmVqUfHSrCdpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All,

When the publication adds new table, the main apply worker would skip
changes upon that table and launches new sync worker to copy the
existing data of that table, and if possible, the sync worker would
apply changes since the copy start lsn.

Then here comes the question, above logic splits the changes of the
new seen table into other transactions applied by sync worker, so it
breaks the original transaction stream?

Regards,
Jinhua Luo

Browse pgsql-hackers by date

  From Date Subject
Next Message Rushabh Lathia 2018-11-22 09:32:43 Hitting CheckRelationLockedByMe() ASSERT with force_generic_plan
Previous Message Adrien NAYRAT 2018-11-22 08:20:19 Re: performance statistics monitoring without spamming logs