Qlik Community

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
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

How to Connect to the PostgreSQL Database used for Qlik NPrinting Repository

Yoichi_Hirotake
Support
Support

How to Connect to the PostgreSQL Database used for Qlik NPrinting Repository

Description:


ATTENTION: Customers and Partners modifying the Repository will void the Support Agreement!

Qlik Nprinting use PostgreSQL as the repository database.

This article explain the steps about how to use the PostgreSQL client (pgAdmin) to connect to the Qlik Nprinting Repository

Note: Manual modification of Nprinting Repository Database is not supported and can cause product failure. Changes to the database should be performed by the NPrinting services or supported API calls.
 

  1. Go to Windows Services.msc and stop, Qlik Nprinting Engine, Qlik Nprinting Scheduler, Qlik Nprinting Web Engine, RabbitMQ.
Note: Please keep QlikNprintnigRepoService running
  1. Go to Folder C:\Program Files\NPrintingServer\pgsql\bin and double click  pgAdmin3.exe 
  2. Click Add a connection to a server button
User-added image
 
  1. Enter below information into New Server Registration window and press OK button
Name: Nprinting
Server: localhost
Port: 4992
Maintenance DB: Postgres (select from pull down)
Username: Postgres
Password:  The password that you entered on installation

User-added image
 
  1. Now connected to Qlik Nprinting Repository
User-added image

Note:
 
It may be necessary to perform the following in order to connect to the database from other servers or from same NPrinting server without using 'localhost' or loopback 127.0.0.1 IP:
 
1. Stop all NPrinting services including the repoService.
2. Obtain a backup copy of and then open the file C:\ProgramData\NPrinting\data\postgresql.conf
Note: Older version may store this under c:\Program Files\NPrintingServer\data instead.
3. Change the parameter listen_addresses to equal '*', and remove the # sign from the beginning of the parameter string
e.g:
listen_addresses = '*'
4. Save and close the file.
5. Obtain a backup copy of and then open the file C:\ProgramData\NPrinting\data\pg_hba.conf
6. Change the line below the string "# IPv4 local connections:" to look like the following:
host all all 0.0.0.0/0 md5
7. Save and close the file.
8. Start the QlikNPrintingRepoService.
9. Attempt connecting to the database.
 
Note:
 
It is recommended to have all remaining services stopped when connecting to the database
 
Version history
Revision #:
2 of 2
Last update:
‎2021-05-11 09:53 AM
Updated by:
 
Contributors