Postgres Logical Replication | Teradata Data Mover - Postgres Logical Replication - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-26
dita:mapPath
tsn1650877444606.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
Data Mover synchronization services uses Postgres replication under the covers to synchronize data from the active repository to the standby repository. Postgres replication works in the following order:
  • A publication is created on the active repository
  • A subscription is created on the standby repository
  • Data Mover tables are added to the publication
  • The publication detects all changes in the Data Mover tables and sends the changes to the standby repository
  • The subscription on the standby receives the changes and applies them to the standby repository
The publication and subscription are automatically created when the synchronization service is set up.