How to check if Qlik Sense repository password is correct with PgAdmin

[Damien_Villaret]

Qlik Sense uses PostgreSQL as the repository database. The steps below show how to use the PostgreSQL client (pgAdmin) to connect to the Qlik Sense repository in order to confirm that the password is correct.

Environment:

Qlik Sense Enterprise on Windows 

1. Install PGAdmin as per Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinti... 
2. Launch PGAdmin
3. Right-Click Servers
4. Click Register
5. Click Server...
   
   
   
   
6. Click the power plug button on the top menu bar and enter the following information:
   
   
   1. Name: QSR (this is arbitrary)
      
      
      
      
   2. Server: localhost
   3. Port: 4432 (not default)
   4. Maintenance Database/User Name: postgres
   5. Password: the password you provided and wish to verify
      
      
      
      
   6. Click Save 
7. Verify the connection:
   
   
   1. Expand Servers
   2. Expand QRS (or whatever name you gave the connection)
   3. Expand QRS