Discussion board where members can get started with Qlik Sense.
I have to upgrade the qmc in sense and first of all i have to re write the superuser password again, but i do not have it
is there any way to get or obtain this?
thank you a lot
Go to Solution.
The installation of Qlik Sense allows for the the postgres USER in the postgreSQL database to be assigned a password. This document outlines the steps to reset the password.
Stop the Qlik Sense Repository Service (note: this will stop all Qlik Sense Services)
Open Notepad as an administrator (right click on Notepad and select Run as Administrator
From Notepad click File > Open
Browse to C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.3
Click on All Files (*.*)
Take a backup of the files pg_hba.conf and postgresql.conf
Open the file pg_hba.conf
We need to change the METHOD from MD5 to TRUST in the first entry
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 127.0.0.1/32 TRUST
Save the file
Open the file postgresql.conf
Search for the #listen_addresses key words
Remove the # from listen_addresses = 'localhost'
#listen_addresses = 'localhost'
listen_addresses = 'localhost'
Start the Qlik Sense Repository Database Service
Launch Command Prompt and set the working directory as
Enter the following command
psql -h 127.0.0.1 -p 4432 -U postgres
The following should be displayed
From the postgres=# prompt enter the following SQL
alter user postgres with encrypted password 'ENTERYOURNEWPASSWORD';
Stop the Qlik Sense Repository Database Service
Replace the files pga_hba.conf and postgresql.conf files with the backups created in step 5
Don't Worry, be Qlik.