Logical Replication in Postgres / Vigneshwaran C (Fujitsu)

This talk is recorded at PG Day’21 Russia - community recognised event that took place online on 8-9 July 2021.
PG Day’21 Russia is annual event that normally takes place in St Petersburg, Russia and focusses on PostgreSQL.

Subscribe to the mailing list on our website not to miss announcements about our next conference! https://pgday.ru/en/2021
-------
Logical Replication in Postgres
The PostgreSQL logical replication follows the publish/subscribe model. The publisher node creates a publication, which is also called a change set or a replication set. The publication is simply a set of changes from one or more tables. The subscriber node creates a subscription, with the capability to subscribe to either one or more publications.

The logical replication in PostgreSQL follows the steps given below:
Step 1: A snapshot of the publishing database is copied to the subscriber. This step is also called the table synchronization phase. To reduce the amount of time spent in this phase, you can spawn multiple table synchronization workers. However, you can only have one synchronization worker for each table.
Step 2: After the copy is completed, subsequent changes made in the publisher node will be sent to the subscriber node. The changes will be sent as they happen in real-time. The changes will be applied in a commit order to ensure there is transactional consistency.

Slides: https://pgday.ru/presentation/279/60f04e75f252a.pptx