-
Title
Resetting the NetVault Database (PostgreSQL) Password -
Description
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.
-
Resolution
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.
*Windows
On Windows Service(services.msc)
- NetVault Process Manager
- NetVault PostgreSQL database server
*Linux
On Terminal
# systemctl stop netvault.service
# systemctl stop netvault-pgsql.service
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:
*Windows
For IPv4
host all all 127.0.0.1/32 trust
For IPv6
host all all ::1/128 trust
*Linux
local all all trust
6. Start the NetVault PostgreSQL service.
*Windows
- NetVault PostgreSQL database server
*Linux
# systemctl start netvault-pgsql.service
7. Run the following command to login to PostgreSQL terminal with the postgres user:
> %NVHOEM%\pgsql\bin\psql -p 51486 -U postgres
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:
postgres-# \password
Enter new password:
Enter it again:
postgres-# \q
(Password cannot exceed 100 characters and must not contain \ or spaces)
9. Undo the changes made to the pg_hba.conf file.
*Windows
For IPv4
host all all 127.0.0.1/32 md5
For IPv6
host all all ::1/128 md5
*Linux
local all all md5
10. Restart the NetVault PostgreSQL service.
11. Start the NetVault Process Manager service.
*Windows
On Windows Service
- NetVault Process Manager
*Linux
On Terminal
# systemctl start netvault.service
12. Use nvpgdbpasswd utility to store the password hash in the NetVault pgdb.cfg file.
> %NVHOME%\util\nvpgdbpasswd store [user postgre password]