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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)
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.