How to connect to the Qlik Sense Enterprise on Windows or Qlik NPrinting PostgreSQL database
This article covers the installation and configuration of pgAdmin 4 (or later) to connect to either the Qlik Sense Enterprise on Windows or Qlik NPrinting repository.
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.
For deployments still utilizing PostgreSQL 9.6: pgAdmin 4 versions 6.13 and higher no longer support PostgreSQL 9. See the release notes for 6.13. 6.12 or an older version of pgAdmin can be downloaded from this archive.
Run the installation executable, and then launch the installed program as Administrator.
Create the Server
In the following prompt, name the connection (your preferred name, it does not have to match the database name)
Switch to the Connection tab
Provide the required connection details:
Hostname/address: localhost (if local)
Port: 4432 (Qlik Sense on-prem) 4992 (Qlik NPrinting)
Maintenance database: postgres* *This value may differ if you run a standalone database and have configured it differently.
Password: your password, set during installation
If you are running an SSL-secured database with Qlik Sense (not supported with Qlik NPrinting), proceed by configuring the SSL tab.
Reading the Repository information
This is an example on how you can afterwards access the Qlik Sense Repository information (Qlik NPrinting follows a similar structure).
Select your database (in our example it is named postgres, you may have named it QSR or any other familiar name)