Qlik® | Support Portal
Quick Links
Contact
Find Answers

Join Qlik Community

Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.

Join Us
Get Support

Have a Question?

Search Qlik's Support knowledge database or request assisted support for your highly complex issues.

Submit a Case
Talk with a Representative

Critical Issues

Experiencing a serious product issue? Please Contact us by phone. Click here to view phone numbers and hours by region.

Contact Us
My Account
Welcome Guest
×
Knowledge

Changing the Database Superuser Password without Qlik Sense Installed

Article Number: 000057530 | Last Modified: 2018/10/09

Description

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

Environment:
Qlik Sense June 2017+

If you lost the password, but have already uninstalled the existing version of Qlik Sense:
  1. Back up C:\ProgramData\Qlik\Sense\Repository\PostgresSQL
  2. Download and install PostgreSQL 9.6
  3. When installing PostgreSQL ensure that the database folder is set to C:\ProgramData\Qlik\Sense\Repository\PostgreSQL
  4. Backup C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\pg_hba.conf
  5. Open pg_hba.conf
  6. Replace 'md5' with 'trust'
  7. Start PostgreSQL
  8. Connect to the database as 'postgres', you will not need a password to connect due to the changes we previously made
  9. Change the password for 'postgres' and 'qliksenserepository'
  10. Shut down PostgreSQL
  11. Restore the backup of pg_hba.conf
  12. Uninstall PostgreSQL
  13. Install Qlik Sense using the new passwords

Was this content helpful?

   

Get Answers

Find Answers

Qlik Community

Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.

Join Us
Get Support

Have a Question?

Search Qlik's Support Knowledge database or request assisted support for highly complex issues.

Submit a case
Talk with a Representative

Critical Issues

Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.