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:
- Log into a Linux shell on the NCM host where the controldb is located (Application Server, Combination Server, or distributed Database Server) as 'root'.
- Run the following command:
su - pgdba -c 'psql voyencedb voyence'
On Windows:
- 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.
- Open an elevated command prompt (Start >> All Programs >> Accessories >> Command Prompt (right-click) >> Run as Administrator).
- 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.