Use Case for Fresh Sync Set Up | Teradata Data Mover - Use Case: Server Synchronization Setup – First Time - 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
  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 sync.properties file and set the sync.isMaster property to true.
  5. On the standby server, edit the sync.properties file and set the sync.isMaster property to false.
  6. On the active server, set the dm.pg.jobstore.production.host property in the sync.properties 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.