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

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem
Data Mover synchronization services uses Postgres replication under the covers to synchronize data from the primary repository to the secondary repository. Postgres replication works in the following order:
  • A publication is created on the primary repository
  • A subscription is created on the secondary 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.