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

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

On the active repository server, go to cd /var/opt/teradata/postgres/data to change the Postgres configuration.
In postgres.conf, change wal_level to wal_level = logical.
Restart the active repository:
/etc/init.d/postgresql stop
/etc/init.d/postgresql start
On the active server , edit the sync.properties file and set the sync.isMaster property to true.
On the standby server, edit the sync.properties file and set the sync.isMaster property to false.
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.
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.

When prompted, select the following option:

Set up a new replication service between this active repository and one or more standby repositories

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.