Use Case for Fresh Sync Set Up | Teradata Data Mover - 17.11 - Use Case: Server Synchronization Setup – First Time - Teradata Data Mover

Teradata® Data Mover User Guide

Teradata Data Mover
Release Number
Release Date
October 2021
Content Type
User Guide
Publication ID
English (United States)
  1. On the active repository server, go to cd /var/opt/teradata/postgres/data to change the Postgres configuration.
  2. In postgres.conf, change wal_level to wal_level = logical.
  3. Restart the active repository:
    /etc/init.d/postgresql stop
    /etc/init.d/postgresql start
  4. On the active server , edit the file and set the sync.isMaster property to true.
  5. On the standby server, edit the file and set the sync.isMaster property to false.
  6. On the active server, set the property in the file as the hostname for the active server.
    Use a name other than localhost as the host name.
  7. On the active server, configure the sync service:
    /opt/teradata/datamover/sync/nn.nn/dmsync config
    Where nn.nn in the path refers to the version numbers of Data Mover.
  8. When prompted, select the following option:
    Set up a new replication service between this active repository and one or more standby repositories
  9. Respond to the following prompts:
    Enter remote standby host name Enter the standby server name.
    Enter the database super user postgres password on standby repository Enter the Postgres user password on the standby server.
    Replication service set up requires that the active and standby repositories are in sync before configuring. Do you need to back up the active repository to the standby repository? [y or n]
    • Enter Y if standby repository has not yet been synchronized.
    • Enter N if standby repository has already been synchronized.
    Do you need to set up replication for another standby repository? [y or n]:
    • Enter Y if more than one standby server needs to connect to this active server.
    • Enter N if only one standby is needed.