Upgrade from 10.1.1 to 10.1.6 or any higher version causes full data loss in controldb if the installation generates the following error and it allowed to continue.
The NCM installer when trying to upgrade the Database Server generates the following error message:
Redirecting to /bin/systemctl status controldb.service
DBPW is Encrypted
psql: FATAL: password authentication failed for user "pgdba"
password retrieved from file "/root/.pgpass"
psql: FATAL: password authentication failed for user "pgdba"
password retrieved from file "/root/.pgpass"
* Taking backup...
pg_dumpall: could not connect to database "template1: FATAL: password authentication failed for user "pgdba"
ERROR: pg_dumpall failed to execute during backup ...
NCM - 10.1.x
NCM versions 10.1.x require a 15-character password also must meet minimum requirements.
In this case NCM 10.1.1 was an upgrade from 9.6 and still had an 8-character password and this generated the error in the installer. The pgdba user requirement was not met for the template1 database that allows the pbdump to process and dump the database contents required for the database to be upgraded.
Before upgrading the Database Server from the 10.1.1 version of NCM to a newer version:
NOTE: The database contents will be cleared if the installer is allowed to continue hence recommended to QUIT the installer to prevent data loss.
Follow all of the steps to update the passwords on all servers and create the bundle.p12 as documented in the following document link:
Change NCM Passwords
NOTE: NCM 10.1.x has the following password requirements:
The new password must contain at least:
The special characters that can be used for the database password are: