Go to Folder C:\Program Files\NPrintingServer\pgsql\bin and double click pgAdmin3.exe
Click Add a connection to a server button
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
Now connected to Qlik Nprinting Repository
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.
It is recommended to have all remaining services stopped when connecting to the database