1) Start OpManager service

2)Connect  to OpManager database :

  a)Go to OpManager\pgsql\bin folder
  b)Type psql -U postgres -h 127.0.0.1 -p13306  OpManagerDB
  c)Once connected to the Database, execute the below query to set password
   
     ALTER USER Postgres WITH PASSWORD 'mike';
     (Replace your password with mike)

3)Shut down OpManager service

4)Edit the file databaseparams.conf  using wordpad and make the following changes :

From

# login password for the database if any
# password postgres AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB

to

# login password for the database if any
password mike AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB

(Remove the comment before the password and change the password from postgres to mike)

5)Edit the file "pg_hba" under Opmanager\pgsql\data using wordpad and modify the following, save the file

From

# IPv4 local connections:
host    all             all             127.0.0.1/32            trust

# IPv6 local connections:
#host    all             all             ::1/128                trust

to

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5

# IPv6 local connections:
#host    all             all             ::1/128                 md5

( replace from trust to md5 )

6)Restart OpManager service , now you should be able to use password while connecting to OpManagerDB.

Applicable for OpManager version 11xxx installed on Windows box.