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. Environment:
- Qlik Sense June 2017 and later
- Qlik NPrinting June 2017 and later
pgAdmin 4 or higher need to be used to access Qlik Sense database as PostgreSQL has been used from Qlik Sense June 2017
1. Download pgAdmin 4
The software can be found on pgadmin.org
2. Run the installation executable, and then launch the installed program as Administrator
3. Create Server
Rright click on "Servers" (pgAdmin4 >> Browser >> Servers
Click Create >> Server
4. Configure "General
" and "Connection
Name: QRS (your preference database name)
Host name/Address: localhost (if database has been installed on local machine)
Port: 4432 (or 4992 for NPrinting)
Maintenance database: postgres
Password: The password that you set up on Qlik Sense or NPrinting installation.
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 >