There will be instances when you would want to change the password for the PostgreSQL database set during the NV Server installation. One such scenario is when the password has been forgotten, and login to the database is required.
IMPORTANT
NetVault stores the system data in a PostgreSQL database, which resides on the NetVault Server. You should not attempt to modify the NetVault Database directly using any PostgreSQL tools unless directed by Quest Technical Support personnel. Improper changes to the database can cause unrecoverable data. Before making any modifications, make sure that you create a backup of the NetVault database. For more information about backing up the NetVault Database, see the Quest NetVault Built-in Plug-ins User’s Guide.
NetVault stores the system configuration settings in “.cfg” files, which reside in the config directory under the NetVault installation directory. The settings in these files should only be modified under the guidance of Quest Technical Support personnel. Improper changes to these files can cause errors and other unexpected behavior. Before modifying a configuration file, make sure that you create a backup copy of the file.
1. Make a backup of the NVDB (Snapshot the machine if it's a VM).
2. Make sure no more backup jobs are running.
3. Stop the NetVault Process Manager and NetVault PostgreSQL services.
4. Make a backup of the %NVHOME%\db\pgsql\pg_hba.conf file.
5. On pg_hba.conf, edit or add the line that will allow accessing the database locally:
6. Start the NetVault PostgreSQL service.
7. Run the following command to login to PostgreSQL terminal with the postgres user:
51486 is the default port number set by NetVault. Use the corresponding port number if it was changed.
8. the PostgreSQL terminal enter the following commands to update the password and exit:
9. Undo the changes made to the pg_hba.conf file.
10. Use nvpgdbpasswd utility to store the password hash in the NetVault pgdb.cfg file.
11. Restart the NetVault PostgreSQL service.
12. Start the NetVault Process Manager service.
