Smarts NCM: How do I log into Postgres DB?

Products

• VMware

Environment

VMware Smart Assurance - NCM

Resolution

For NCM versions 9.x, the following instructions will cause an additional password challenge prompt to display which must be satisfied with the current database password before continuing.

On Linux:

1. Log into a Linux shell on the NCM host where the controldb is located (Application Server, Combination Server, or distributed Database Server) as 'root'.
2. Run the following command:

su - pgdba -c 'psql voyencedb voyence'
 

On Windows:

1. Log onto the NCM host where the where the controldb is located (Application Server, Combination Server) under an account that has full local administrator privileges.
2. Open an elevated command prompt (Start >> All Programs >> Accessories >> Command Prompt (right-click) >> Run as Administrator).
3. Run the following command on a single line (where %VOYENCE_HOME% is the path where NCM is installed):

 

%VOYENCE_HOME%\db\controldb\bin\psql -p 5435 -h 127.0.0.1 --username=voyence -d voyencedb

 

If the controldb default port of 5435 has been altered, you must use the currently configured port as the value for the -p option in the above command instead of the default.