Steps for setting up a password for PgSQL DB
The steps are verified and tested until 12.4.072.
We request you to take a VM snapshot or a folder backup of the OpManager server itself (stop the OpManager service) as a first measure.
Below mentioned steps are applicable for Postgres version till 9.2.4*
1. To get the current postgres version, execute the following command in command prompt.
Example :
cmd: <OpManagerHome>\pgsql\bin>psql.exe --version
Output: psql (PostgreSQL) 9.2.4
2. To change the postgres password follow the steps mentioned below.
- Stop the the OpManager service.
- Connect to the DB by executing the below mentioned commands one by one in command prompt.
<OpManagerHome>\bin\startPgsql.bat
cd <OpManagerHome>\pgsql\bin -> psql -U postgres -h127.0.0.1 -p13306 OpManagerDB
ALTER USER postgres WITH PASSWORD 'new_password';
<OpManagerHome>\bin\stopPgsql.bat
cd <OpManagerHome>\pgsql\bin -> psql -U postgres -h127.0.0.1 -p13306 OpManagerDB
ALTER USER postgres WITH PASSWORD 'new_password';
<OpManagerHome>\bin\stopPgsql.bat
3. Changes to be made in pg_hba.conf
- Under <OpManagerHome>\pgsql\data\pg_hba.conf, change the line as follows. (Highlighted one)
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
↓
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
4. To generate encrypted password
- Execute <OpManagerHome>\bin\encryt.bat new_password (encryt.sh new_password - in case of linux)
- Copy the ENCRYPTED_PASSWORD from the batch output for future use.
5. To change the password in database_params.conf
- Open <OpManagerHome>\conf\database_params.conf.
- Alter the line # password postgres → password ENCRYPTED_PASSWORD
6. Restart the OpManager service and connect to the DB Query page or perform any operation related to DB. Check if it is working fine.
New to ADSelfService Plus?
Related Articles
OpManager DB migration from PGSQL to MSSQL in Version 125230
For OpManager version 125230: PGSQL to MSSQL Migration Steps : In the PGSQL setup, go to OpManager home → bin, start Command Prompt with administrator privilege from this path and run DBConfiguration.bat. In the popup shown, please chose MSSQL, check ...Admin Password reset in OpM 12
For users that are authenticated with Active Directory Domain authentication, you can reset the password of an AD user by changing the AD password. The same is applicable for Radius Authenticated users. Local Authenticated users can follow one of the ...OpManager DB migration from PGSQL to MSSQL on the same server in Version 12.3
Please follow the below mentioned steps to migrate DB from PGSQL to MSSQL on the same server. These steps are applicable only on builds 12.3.045 and above. If you are in older versions below 12.3.045, please upgrade to 12.3.045 and follow these ...Database Migration - MySQL to PgSQL
The DB migration from MySQL to PgSQL involves taking a PgSQL compatible backup, re-installing the product with PgSQL database and restoring the backup. The procedure for the above is a little tedious and time consuming in version 9 & 10. So, please ...SSL Configuration steps for Version 12.3
For Build 12.3.181 and above: Steps to enable HTTPS Go to Settings Click on Basic Settings Choose "Security Settings" Enable "Secure Mode" Here you have 3 options to choose from: Generate a CSR Self-signed Certificate Import Certificate Generate ...