NOTE – MAKE SURE ALL CONTROL-M SERVER AND EM SERVER PROCESSES ARE STOPPED BEFORE YOU ATTEMPT THE PASSWORD RESET. FOR A RECOVERY POINT, BACKUP THE CONTROL-M SERVER AND EM SERVER INSTALLATION DIRECTORIES AND REGISTRY (IF WINDOWS).

The following process will alter the PostgreSQL Database so it will allow the OS user to login directly into the database without password authentication. Once you are in the database you can use the steps provided to change the postgres user ID’s password. You must be logged in to the system as the owner of the database files in order for this to work.

This method applies to both Windows and UNIX systems:
If Windows, in the command prompt, first change directory to: <Control-M install directory >\pgsql\bin

1. Edit the pg_hba.conf file located in:
a. UNIX – “<Control-M home directory>/pgsql/data”
b. Windows – “<Control-M install directory >\pgsql\data”

2. Replace the value “password” in the METHOD column with “trust” and save the file.

3. Run the command: pg_ctl reload
NOTE: In some instances it may be necessary to also pass the -D parameter
For example: pg_ctl reload -D "C:\Program Files\BMC Software\Control-M Server\pgsql\Data"

4. Connect to the PostgreSQL database using the following command:
psql -U postgres

if on Linux/Unix Control-M/Enterprise Manager run:
em psql -U postgres
 

5. Change the password for the postgres account using the following command:
a. alter user postgres with password 'newpassword';
b. exit the psql session using the ”\q” command
c. NOTE - newpassword should be replaced with the password you want to change to.

6. Edit the pg_hba.conf file again and change the METHOD value back to “password”

7. Run the command: pg_ctl reload
NOTE: In some instances it may be necessary to also pass the -D parameter
For example: pg_ctl reload -D "C:\Program Files\BMC Software\Control-M Server\pgsql\Data"

8. Run the following command to make sure the database is running:
pg_ctl status
It should return “pg_ctl: server is running”

NOTE: It is VERY important that "trust" be changed back to "password" or the provided scripts and utilities will not function properly.

If you are using Control-M/Server High Availability with Postgres, please perform the next procedure to update the password for the High Availability replication:

1.       Shut the Control-M/Server Configuration Agent on the secondary Control-M/Server and after that on primary.

2.       Run the ctminterface utility on both Control-M/Servers as following:

ctminterface -SET_PASSWORD HAKEY <new postgres user password>

4.       Start the Control-M/Server Configuration Agent  first on the primary and after that on secondary.

The following video demonstrates this solution: