Qlik Community

Ask a Question

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Talk to Experts Tuesday: Live chat Aug. 24th 10 AM ET: Bring your Qlik Gold Client questions REGISTER TODAY

Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinting

Daniel_Seo
Support
Support

Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinting

WARNING: Qlik cannot support direct queries and access to the underlying product's database hosted by PostgreSQL. If any issues arise for which direct queries are deemed responsible, Qlik Support will reserve the right to request that a previous working backup is restored to the system in order to bring back full operation or resolve any isolated issue(s). The steps described here in this article are only used by Qlik Support for troubleshooting purposes.

Previous versions of Sense and NPrinting came with the pgAdmin 3 tool pre-installed, but from Qlik Sense June 2017 and up, the new version needs to be acquired manually. For NPrinting pgadmin4.exe may be found under C:\Program Files\NPrintingServer\pgsql\pgAdmin 4\bin on latest builds.

For access to the PostgreSQL database used by the Repository, the admin tool (pgAdmin) may need to be downloaded and installed manually. 
 

Cause:


pgAdmin 4 or higher need to be used to access Qlik Sense database as PostgreSQL has been used from Qlik Sense June 2017

 

Resolution:


1. Download pgAdmin 4 or higher
    The software can be found on pgadmin.org.

2. Run the installation executable, and then launch the installed program as Administrator

3. Create Server
    Right click on "Servers" (pgAdmin4 >> Browser >> Servers)
    Click Create >> Server
   
         User-added image
 

4. Configure "General" and "Connection"  tap

"General" tab
Name: QRS  (your preference database name)
 
"Connection" tab
Host name/Address: localhost (if database has been installed on local machine)
Port: 4432 (or 4992 for NPrinting)
Maintenance database*: postgres
Username: postgres
Password: The password that you set up on Qlik Sense or NPrinting installation.


*Note that the maintenance database name may differ if this was not a standard installation and changes were made during setup. Consult your configuration file if necessary. 
           User-added image



5. To access the Sense Repository information, navigate to: (NPrinting's Database follows similar structure)

Servers >> "database server name" (e.g QRS) >>Database >> QSR >> Schemas >> public >> Table >



          User-added image

Labels (2)
Version history
Revision #:
5 of 5
Last update:
‎2021-02-04 04:20 AM
Updated by:
 
Contributors