During the installation of Qlik Sense, it is recommended to provide a password for the PostgreSQL database.
Should you forget this password, there's no way to retrieve it; however, it is possible to reset the password by following the steps below.
If after the procedure was completed errors are logged of a wrong password, see Qliksenserepository password error in the event logs after changing the database service user passwo... for further information.
Resolution:
1. Stop the service called: "Qlik Sense Repository Database" (note: this will stop most Qlik Sense Services, as seen below)
Before:
After:
2. Open Notepad as an administrator (right-click on Notepad and select Run as Administrator)
3. From Notepad, click File > Open
4. Browse to C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6 (if "9.6" cannot be found then it's likely "12.5" which is what newer Qlik versions use)
5. Click on All Files (*.*) in the lower right corner dropdown of the dialog box
Note: Backup the files pg_hba.conf and postgresql.conf before making any changes!
5. Open the file pg_hba.conf
6. Change the METHOD from "md5" to "trust" in the both the IPv4 and IPv6 entries. There are four methods listed in total - only the first two need to be changed to trust:
Original:
# TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5
Updated:
# TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust
NOTE: "trust" must be lowercase!
If you use uppercase ("TRUST"), then the service will not start and attempts to make file backups will result in 0kb files when attempting to generate a database dump/backup.
7. Save the file and close it.
8. Start the service called: "Qlik Sense Repository Database" (example below). If this happens to start other dependent services as well, that is fine.
9. Launch a Command Prompt and go to C:\"Program files"\Qlik\Sense\Repository\PostgreSQL\9.6\bin
cd "C:\Program files\Qlik\Sense\Repository\PostgreSQL\9.6\bin"
10. Enter the following command
psql -h 127.0.0.1 -p 4432 -U postgres
The following message should be displayed
11. From the postgres=# prompt, enter the following commands:
alter user postgres with encrypted password 'EnterYourNewPasswordHere';
11b. If v3.0.x and above, you must also adjust the qliksenserepository user account (you must include the single quotes and the semicolon):
alter user qliksenserepository with encrypted password 'EnterYourNewPasswordHere';
The passwords must be the same for both, when making changes. Once complete, close the Command Prompt window.
When opening the Connection String Editor -- Right Click and RUN AS Administrator (or the changes will not save)
or
C:\Program Files\Qlik\Sense\Repository\Util\ConnectionStringEditor
NOTE 2: If using version 2.4 or older, these files may not exist, and as such no editing is required.
15. Start all Qlik services. It's common practice to start the "Repository Database", "Repository Service", and the "Service Dispatcher" services first before starting other services.
16. Download and open pgAdmin4 in order to connect to the Qlik database locally in order to verify that the password has been updated successfully.
- How To Connect To And Modify The PostgreSQL Database Used For Qlik Sense Repository
- Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinti...
NOTE: after the change is made, you may find you cannot get into the QMC. Please review this Article Qliksenserepository password error in the event logs after changing the database service user passwo... for the possible solution.
Related content:
- Qliksenserepository password error in the event logs after changing the database service user passwo...
- How To Connect To And Modify The PostgreSQL Database Used For Qlik Sense Repository
- Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinti...
