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

Teradata® Data Mover Installation, Configuration, and Upgrade Guide for Customers

prodname
Teradata Data Mover
vrm_release
17.05
created_date
October 2020
category
Administration
Configuration
Installation
featnum
B035-4102-090K
The script change_pg_password.sh allows the root user to change the POSTGRES, DATAMOVER, and BAR 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 the user 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/17.05.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 changepassword.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' -d New password for user 'datamover' & 'bar', 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' is the existing password for the DATAMOVER & BAR user
      • New password for user 'datamover' & 'bar' is the new password for the DATAMOVER & BAR user
  2. If you ran the change_pg_password.sh script after Data Mover was installed or upgraded, restart the daemon:
    1. # /etc/init.d/dmdaemon stop
    2. # /etc/init.d/dmdaemon 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/17.05.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' of the Postgres internal repository?(yes/no/y/n)?
y
----------------------------------------------------------------------
            Change DATAMOVER & BAR 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 Password changed successfully
**********************************************************************************************
Please restart the Daemon using the following commands
/etc/init.d/dmdaemon stop
/etc/init.d/dmdaemon start
**********************************************************************************************
Please wait .. updating DSA properties files
**********************************************************************************************
DSA properties files updated successfully
**********************************************************************************************
The DSC and DSARest web service have been restarted
**********************************************************************************************