Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi expert
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
Fernando K.
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.
1 | Stop the Qlik Sense Repository Service (note: this will stop all Qlik Sense Services) |
2 | Open Notepad as an administrator (right click on Notepad and select Run as Administrator |
3 | From Notepad click File > Open Browse to C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.3 |
4 | Click on All Files (*.*) |
5 | Take a backup of the files pg_hba.conf and postgresql.conf |
6 | Open the file pg_hba.conf |
7 | We need to change the METHOD from MD5 to TRUST in the first entry # TYPE DATABASE USER ADDRESS METHOD Original # IPv4 local connections: host all all 127.0.0.1/32 md5 Amended # IPv4 local connections: host all all 127.0.0.1/32 TRUST |
8 | Save the file |
9 | Open the file postgresql.conf Search for the #listen_addresses key words Remove the # from listen_addresses = 'localhost' Original #listen_addresses = 'localhost' Amended listen_addresses = 'localhost' |
10 | Save the file |
11 | Start the Qlik Sense Repository Database Service |
12 | Launch Command Prompt and set the working directory as C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin> |
13 | Enter the following command psql -h 127.0.0.1 -p 4432 -U postgres The following should be displayed |
14 | From the postgres=# prompt enter the following SQL alter user postgres with encrypted password 'ENTERYOURNEWPASSWORD'; The following should be displayed |
15 | Stop the Qlik Sense Repository Database Service |
16 | Replace the files pga_hba.conf and postgresql.conf files with the backups created in step 5 |
17 | Start the Qlik Sense Repository Database Service |
Don't Worry, be Qlik.
Tonial.
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.
1 | Stop the Qlik Sense Repository Service (note: this will stop all Qlik Sense Services) |
2 | Open Notepad as an administrator (right click on Notepad and select Run as Administrator |
3 | From Notepad click File > Open Browse to C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.3 |
4 | Click on All Files (*.*) |
5 | Take a backup of the files pg_hba.conf and postgresql.conf |
6 | Open the file pg_hba.conf |
7 | We need to change the METHOD from MD5 to TRUST in the first entry # TYPE DATABASE USER ADDRESS METHOD Original # IPv4 local connections: host all all 127.0.0.1/32 md5 Amended # IPv4 local connections: host all all 127.0.0.1/32 TRUST |
8 | Save the file |
9 | Open the file postgresql.conf Search for the #listen_addresses key words Remove the # from listen_addresses = 'localhost' Original #listen_addresses = 'localhost' Amended listen_addresses = 'localhost' |
10 | Save the file |
11 | Start the Qlik Sense Repository Database Service |
12 | Launch Command Prompt and set the working directory as C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin> |
13 | Enter the following command psql -h 127.0.0.1 -p 4432 -U postgres The following should be displayed |
14 | From the postgres=# prompt enter the following SQL alter user postgres with encrypted password 'ENTERYOURNEWPASSWORD'; The following should be displayed |
15 | Stop the Qlik Sense Repository Database Service |
16 | Replace the files pga_hba.conf and postgresql.conf files with the backups created in step 5 |
17 | Start the Qlik Sense Repository Database Service |
Don't Worry, be Qlik.
Tonial.