Change Server Passwords | - Changing POSTGRES, DATAMOVER and DSA Passwords on the Data Mover Server - Teradata Data Mover

Teradata® Data Mover Installation, Configuration, and Upgrade Guide for Customers - 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
jvt1700556161677.ditamap
dita:ditavalPath
stp1591127384938.ditaval
dita:id
pqq1467243714524
Product Category
Analytical Ecosystem
The script change_pg_password.sh allows the root user to change the POSTGRES, DATAMOVER, BAR, and CS2 passwords on the Data Mover server.
The passwords for the bundled DSA in Data Mover are updated using the change_pg_password.sh script, do not use the script that is provided with DSA.

The new password specified for DATAMOVER using the script is applied to CS2 and BAR. When started, the script logs into the internal POSTGRES repository and changes the repository passwords. The script is part of the tdm-linux bundle and its location is determined by where the bundle is located on your server. For example:

/var/opt/teradata/packages/DataMover/20.00.00.00/change_pg_password.sh

If you previously used dm.job.production.password in the daemon.properties file to change the DATAMOVER password, remove the property from daemon.properties before running the change_pg_password.sh script.
Teradata recommends running the script before installing or upgrading Data Mover. Running the scripts after Data Mover has been installed or upgraded, requires restarting the daemon to make sure Data Mover runs properly.
The following special characters are not allowed in passwords:
  • Single quote ( ' )
  • Double quotes ( " )
  • Blank spaces
  1. Do one of the following:
    Script Option Description
    Interactive
    1. Run the script without arguments:

      change_pg_password.sh

    2. When prompted, enter the old and new passwords.
    Non-Interactive
    1. Run the script with the arguments -o, -p, -m, and -d. For example:

      # change_pg_password.sh -o Current password for user 'postgres' -p New password for user 'postgres' -m Current password for user 'datamover', 'bar', & 'cs2' -d New password for user 'datamover', 'bar', & 'cs2', where:

      • Current password for user 'postgres' is the existing password for the POSTGRES user
      • New password for user 'postgres' is the new password for the POSTGRES user
      • Current password for user 'datamover', 'bar', & 'cs2' is the existing password for the DATAMOVER, BAR, and CS2 user
      • New password for user 'datamover', 'bar', & 'cs2' is the new password for the DATAMOVER, BAR, and CS2 user
  2. If you ran the change_pg_password.sh script after Data Mover was installed or upgraded, restart the daemon and CS2 services:
    1. # /etc/init.d/dmdaemon stop
    2. # /etc/init.d/dmdaemon start
    3. # /etc/init.d/dmcs2 stop
    4. # /etc/init.d/dmcs2 start
  3. Use the following commands to verify the Data Mover components are ready to use:
    • datamove list_jobs
    • datamove list_agents

Script Example

location:/var/opt/teradata/packages/DataMover/20.00.00.00 # sh change_pg_password.sh
Do you want to change password for user 'postgres' of the Postgres internal repository?(yes/no/y/n)?
y
----------------------------------------------------------------
            Change Postgres Password
Use double quotes when entering passwords containing special characters
----------------------------------------------------------------
Old Password:
Retype Old Password:
New Password:
Retype New Password:
Do you want to change password for user 'DATAMOVER', 'BAR', and "CS2" of the Postgres internal repository?(yes/no/y/n)?
y
----------------------------------------------------------------------
            Change DATAMOVER, BAR, and CS2 Password
Use double quotes when entering passwords containing special characters
----------------------------------------------------------------------
Old Password:
Retype Old Password:
New Password:
Retype New Password:
**********************************************************************************************
Postgres Password changed successfully
**********************************************************************************************
**********************************************************************************************
DATAMOVER, BAR, and CS2 Password changed successfully
**********************************************************************************************
DATAMOVER and BAR: Please restart the Daemon using the following commands
/etc/init.d/dmdaemon stop
/etc/init.d/dmdaemon start
**********************************************************************************************
CS2: Please restart the Daemon using the following commands
/etc/init.d/dmcs2 stop
/etc/init.d/dmcs2 start
**********************************************************************************************
Please wait .. updating DSA properties files
**********************************************************************************************
DSA properties files updated successfully
**********************************************************************************************
The DSC and DSARest web service have been restarted
**********************************************************************************************