Changing the Database Superuser Password without Qlik Sense Installed

Andrew_Delaney — Mon, 18 Oct 2021 09:39:26 GMT

Qlik Sense requires the database superuser password to upgrade Qlik Sense or install Qlik Sense if an existing database is present.

If you lost the password, but have already uninstalled the existing version of Qlik Sense:

Back up C:\ProgramData\Qlik\Sense\Repository\PostgresSQL
Download and install PostgreSQL (note it needs to be the version you are currently using)
When installing PostgreSQL ensure that the database folder is set to C:\ProgramData\Qlik\Sense\Repository\PostgreSQL
Backup C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\pg_hba.conf
Open pg_hba.conf
Replace 'md5' with 'trust'
Start PostgreSQL
Connect to the database as 'postgres', you will not need a password to connect due to the changes we previously made
Change the password for 'postgres' and 'qliksenserepository'
Shut down PostgreSQL
Restore the backup of pg_hba.conf
Uninstall PostgreSQL
Install Qlik Sense using the new passwords

article Changing the Database Superuser Password without Qlik Sense Installed in Official Support Articles