conf and change the METHOD back from "trust" to "md5" 15. Delete all certificates. 6 and 12. 8 database on a new server for a new environment, or to migrate an existing database to a separate host. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. If the command fails because a database already exists, run the following command and then repeat the. 5 - New tool available. The QSR is the primary database in your Qlik Sense deployment. The Qlik Sense Management Console (QMC) and/or HUB do not open. Default paths are: C:ProgramDataQlikSenseLog. In the right pane, locate the ServicesPipeTimeout entry. 6share" as per below - # Allow any user on the local system to connect to any database with # any database user name using Unix-domain sockets (the default for localThe Qlik Sense Repository Service ( QRS) manages persistence and synchronization of Qlik Sense apps, licensing, security, and service configuration data. The installer doesn't recreated the Database on repair, only files. conf with the backups created in . The Qlik Sense Repository Service has also been changed to Manual. There is only one instance of the Qlik Sense Repository Service (QRS) running, and it has direct access to the central repository database. The Qlik Sense repository database (QSR). Hit Save Value in config file encrypted. Restart the Qlik Sense Repository Database service. Database traffic encryption. Highlight the database and click Upgrade. Open QlikSenseUtil. 0. Run the Qlik PostgreSQL Installer. Define your Database backup path and click Next. All forum topics; Previous Topic; Next Topic; 1 Solution Accepted Solutions. For example, create a folder called QlikShare on the C: drive. Optionally, add privileges to the returned entities. APIs for Qlik Sense Enterprise on Windows. Highlight the database and click Upgrade. The database used for Qlik Sense repository is named QSR. A: It would not be suggested to do this because the only way to install the Qlik Sense Repository Database Service is to do a clean installation of Qlik Sense. 1/32, only allows local host to access the database. It may. This decrypts the current data. Reinstall using a database username and password with characters from the same character set. Produce a dumpfile for the repository database (that is, a single file for the entire database):The repository database stores system and app meta data, while the file share stores binary application data such as data models and app content. In addition, the stores the Qlik Sense app structures and the paths to the binary files (that is, the app data stored in the local file system). conf and postgresql. The password of the SuperUser assigned to the Repository Database has been lost. An existing Database will be detected. 6 to 12. If you used the same password for the database superuser as for the qliksenserepository user, see Cannot find the password for the qliksenserepository. exe and open. If you used the same password for the database superuser as for the qliksenserepository user, see Cannot find the password for the. Stop the Qlik Sense Repository Database service, and the "Repository Service" as well if it's also running (so they appear as below) 14. The Qlik Sense repository database (QSR): The QSR is the primary database in your Qlik Sense deployment. Stop/Start the Qlik Services Manually. This Qliksense is. config; Set DisableAutomaticBootstrap to true. Stop all Qlik Sense services except the Qlik Sense Repository Database (QRD), on every node in your deployment. Restoring a Qlik Sense site to a machine with the same hostname. QRSMain 7 3c7c0c23-d9b1-455a-b11f-d4d5a7a4f508 NT AUTHORITYSYSTEM Waiting up to 300 seconds for database to respond 3c7c0c23-d9b1-455a-b11f-d4d5a7a4f508Description. Qlik Sense works normally, but a huge quantity Repository logs is generated. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. The steps should be: Do the following: Stop all Qlik Sense services except Qlik Sense Repository Database. Qlik Sense is %ProgramFiles%\Qlik\Sense\ 2. Run the Qlik PostgreSQL Installer. This can be exceeded by users by accident or by unexpected behavior. Start all services except the Qlik Sense Repository Database service. I agree with Daniel on opening a Support case, but you can try this -. The Qlik Sense Repository Service (QRS) manages persistence and synchronization of Qlik Sense apps, licensing, security, and service configuration data. Qlik Sense is %ProgramFiles%QlikSense 2. Open the Connection String Editor and Read the current configuration, decrypting the current data. Try to run some commands to know if they can be reached. The QSR is the primary database in your Qlik Sense deployment. The immediate issues would be recorded in this folder log files. The idea is to access the repository tables in order to find all objects and corresponding definitions (e. The data is normally added and updated using the Qlik Management Console (QMC) or a Qlik Sense client, but it is also possible to communicate directly with the QRS using its API. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. except the 'QlikSenseRepositoryDatabase' & 'QlikSenseRepositoryService'. Hi all, We are setting up a new Qlik Sense Production server. Success. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. Open a Command Prompt with administrator privileges in Microsoft Windows. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. Between Qlik Sense Enterprise on Windows May 2021 and Qlik Sense Enterprise on Windows May 2023, the Qlik Sense Repository Database used PostgreSQL version 12. We run nightly Veeam backups of our Qlik Sense environment. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. 2. Data connections enable you to select and load data from a data source and provide a way to save shortcuts to the data sources you commonly use such as databases, local files, or remote files. I think if you see both folders of 9. Use the default postgres Database user and the password created during the Qlik Sense installation. On your Central Node, stop all services except the Qlik Sense Repository Database. Proposed action. Postgres database is installed on this same qliksense development server. Though, if you have a valid Sense Server. After that and restarting the server to check If there. Qlik Sense Repository (QSR) database backup size halved after upgrade to November 2021. I've followed the QPI instructions. The QPI allows to install a standalone PostgreSQL 14. We want the script to be able to query the QRS api, so we have to give it a new "door" to authenicate. Note, the Repository. Highlight the database and click Upgrade. This module will focus on exploring the Qlik Sense Repository Database. Qlik. POST. Do not change the startup method. An existing Database will be detected. Navigate to the location where the PostgreSQL repository database is installed. Qlik Sense Repository Database administrator. The upgrade is completed. Open a command prompt and run the command: cd "C:ProgramDataPackage Cache". Getting started. For information about upgrading PostgreSQL, see: Qlik Sense May 2021 - Upgrade bundled PostgreSQL to 12. Here you can see all of the tables where Qlik Sense stores data in the current database that will be dropped. g. Upgrading Qlik Sense Repository Database from Post. Expand. 11. Make a backup of the repository database by creating a database dump file: Open a Command Prompt in Microsoft Windows. Open the Windows Services Console and locate the Qlik Sense Enterprise on Windows services. Postgres user and password. exe -bootstrap. Now the following windows qlik services runs on this server: Now I have another multi node qliksense windows server, version is August 2022 Patch2 -14. Let's use this as a reference point: With this architecture, it is entirely possible to host the Repository database and/or file system on the Active Central. To fix this we need to connect to the database using a DB Admin tool like PGAdmin: Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik. 6 Qlik Sense Enterprise on Windows security. Make a backup of the repository database. 2. Place the backed-up repository database on the machine targeted for the restore. 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. That file should exist, also a Repository. Backup and restore Qlik Sense ‒ Qlik Sense. E. And each service will be represented by a specific log file. Qlik Sense supports database traffic encryption using SSL, but you need to perform some manual configuration to setup SSL and password protection, for example, MD5 or SCRAM-SHA-256, in a shared persistence deployment. Due to which you cannot start the service. 3inpgAdmin3. The likely root cause is a wrong fixed IPv6 and IPv4 address in the pg_hba. Learning Objectives: Configure pgAdmin to connect to the Qlik Sense Repository Database. This is to avoid automatic spin up and interaction with the database during the. Highlight the database and click Upgrade. A Qlik Sense Data Connection is being set up to a share hosted outside the Windows Domain. You will find that the Qlik Sense Repository Database service has been set to manual. If, during the initial setup, Qlik Sense was not set up to allow connections to the repository database at all IPv6 addresses, the change to IPv6 or change of the address will lead to access being refused. Database traffic encryption. Also check will this machine contains proper security or windows licence and they are updated also. The Qlik Sense Repository Service ( QRS) API is a REST API that you use to manage your Sense site programmatically. Highlight the database and click Upgrade. The Share is otherwise accessible by a specified account. Environment: Qlik Sense Enterprise on Windows . I assume this data is attainable as (INTERNALsa_repository) connections are set-up to feed the standard monitoring. The related log file for this issue is: C:ProgramdataQlikSenseLogRepositoryAuditAuditSecurity_Repository. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. The background threads are stopped. Even if I restart services, Qlik Sense Repository Service is not being started and at the end it says below : I have even increased time out to service start to 5 mins. 1. Getting info from Qlik Sense Repository Database. (Detailed Steps) Option 3: Restore the missing/deleted file from the Antivirus bin folder if not permanently deleted. conf file is located in "C:Program. Postgres user and password. An existing Database will be detected. 1. In a Qlik Sense server deployment, you manage data connections with the Qlik Management Console. The Qlik Sense Repository Service (QRS) contains all data and configuration information for a Qlik Sense site. We have now changed the connection strings to the QSMQ database and the QSR database. The Qlik Sense message queue database. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. In a multi-node deployment, a cluster is formed around. com | Qlik Help | ResourcesCause: There are two known causes: 1. The data is normally added and updated using the Qlik Management Console ( QMC ) or a Qlik Sense client, but it is also possible to communicate directly with the QRS using its API. Start all services except the Qlik Sense Repository Database service. Verify that your Qlik Sense services are running with a service account, not a local account. Enter the data source settings and click Create to create the data connection. Qlik Sense supports database traffic encryption using SSL, but you need to perform some manual configuration to setup SSL and password protection, for example, MD5 or SCRAM-SHA-256, in a shared persistence deployment. The password for QLogs is the same as postgres superuser password and make sure the password entered is correct. Run the Qlik PostgreSQL Installer. An existing Database will be detected. 4. Common. In the right pane, locate the ServicesPipeTimeout entry. We would like to show you a description here but the site won’t allow us. The instructions as well as supported versions and recommended upgrade paths will be updated to reflect the latest version as soon as it is available. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. 5 installed locally when you upgrade Qlik Sense, the database will still be used after an upgrade. 6 for the Qlik Sense Repository Database. For large database it is possible that the default 90 seconds timeout is not enough. 6 to 14 with Qlik Postgress Installer. Connections are stored in the repository database by the Qlik Sense Repository Service. Run the following commands to restore the repository database. Optionally, provide a password for the file. If the Qlik Sense Repository Database was installed manually, it may be located on another computer. Expand. That table holds all of the security rules that exist in Qlik Sense server. This article from support has detailed step by step to reset the database password. Learning Objectives: Configure pgAdmin to connect to the Qlik Sense Repository Database Explore the Qlik Sense Repository Database directory tree structure and view database activity View, update, and explore a Qlik Sense Repository Database table Do the following: Stop all Qlik Sense services except the Qlik Sense Repository Database ( QRD ), on every node in your deployment. Information note After installation the services are started automatically, which can take a few minutes. 0. 1 Certificates. Qlik. The PostgreSQL repository grows immensely and Qlik assumes you're running a small business setup. PostgreSQL has identified two security issues. Create a connection to the server machine hosting the Qlik Sense Repository database. Open the command prompt as Administrator, and run the following command on the Qlik Sense Central node. 3 and open pg_hba. 7 Security 55 Security and availability in a shared persistence deployment 55 Maintaining database password integrity 56 Database traffic encryption 56 Forcing the database connection to use TLS 1. . Stop all Qlik Sense services except for the Qlik Sense Repository Database and Qlik Sense Service Dispatcher services. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. Adjust accordingly depending on what version is installed. The Qlik Sense services have the following dependencies: Repository database: The QRS connects to the repository database to store and retrieve data necessary for the Qlik Sense services on the node on which the. 2) restore the last backup QSR on new Postgress machine. The Qlik NPrinting repository realizes the persistence of data by using a database server in the background. Note: Any lines prefixed with a # are commented out and not active. 202. 5 - New tool available. Using the article "Changing the repository database user password" in Qlik. Again, it's only designed to upgrade a Postgres Database or a Qlik Sense Repository Database that was shipped with Qlik Sense. 5. Ditto - same here!On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. And there is no easy fix, only to go back to a snapshot of the server from before this issue occured. Hi, on upgrade of postgres sql using the upgrade tool provided by Qlik Repository Database service is renamed to postgresql-x64-14. Open the Connection String Editor and Read the current configuration. config, wich the configuration file of the service. IfA Qlik Sense site will store data to both a repository database for system & app metadata and file share for the binary application data (such as data models and app content). Run the Qlik PostgreSQL Installer. The Qlik Sense Repository Service is not starting, and the logs state: Fatal exception during startup Key not valid for use in specified state . My first guess is that the connection string used by the Repository Service to connect to the underlying PostgreSQL databast is still using the old account. This module will focus on exploring the Qlik Sense Repository Database. Backing up and restoring the Qlik Sense Repository Database (QSR) can be intimidating. In this post, I’ll cover the most common scenario: a complete migration of a single or multi-node Qlik Sense system, with the bundled PostgreSQL database (Qlik Sense Repository Database service) in a new. Some services stop automatically if they are not in use by other services or programs" The Repo logs just say Postgres connection reset is inactive. In case of success, log entries are written in the following files throughout the procedure: <MachineName>_Service_Repository. All services with a dependency on the Repository Database will also be stopped. Program FilesQlikSenseRepositoryPostgreSQLversion number. Confirm with Yes. Finally, restart the Qlik Sense. To change the service account user, see Changing the user account to run Qlik Sense services . 4) create a void DB log with void tables (I run the create script. Step 2: Backup your Qlik Sense site . 2. Qlik Sense Printing service (QPR) 4899 (QPR listen port)-443 (Sense web server - proxy) 4242 (QRS REST API) 8088 (CEF debugging) Qlik License Service-443 (HTTPS) 9200. 6 to 12. Qlik Sense Enterprise on Windows The information in this article is provided as-is and to be used at own discretion. Start Qlik Sense services. An existing Database will be detected. 197. Restore the backup ( Qlik Sense Repository Database still remains inactive since version is the same)Note that bundled PostgreSQL 12. If you are changing the user account on your primary or central node, run Repository. The Qlik Sense message queue database (QSMQ): On your Central Node, stop all services except the Qlik Sense Repository Database. The upgrade is completed. The port is blocked by the Antivirus. Andy. . In the Diagnostics Tool, click the Connection String Editor tab. Next, open a command prompt with administrator privileges on the machine hosting the database. When any other Qlik Sense service starts, it contacts its local QRS to get configuration parameters. The output of this will point you to the location of the PostgreSQL. 573 Views 0 Likes Reply. (As I understood from Governance Apps script). Net config file, however in the Framework64 sub directory. Do the following: Stop all Qlik Sense services except the Qlik Sense Repository Database ( QRD ), on every node in your deployment. Restart the Qlik Sense services. Look into the Online help for instructions on how to backup the DB. Install PGAdmin as per Installing and Configuring PGAdmin 4 to access the. x (not included in the installer)The summary of Database settings during the upgrade shows not the actual values of the pg_hba. Qlik Sense Backup. For more information about the QPI, see: Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer. It is not a Windows, or Qlik Sense user, it is a PostgreSQL user configured in the repository database. The qliksenserepository user (or the user specified in the repository connection string) does not have sufficient access to the tables in the repository database. sc config "Old service name" displayname= "New service name" On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. After consulting with our Qlik providers we discovered dat the repository database is corrupted. An existing Database will be detected. To create a new repository database on the current computer, click Create a new database. In the Service cluster tab, click OK to retrieve the current Share paths. When any other Qlik Sense service starts, it contacts its local QRS to get configuration parameters. The Qlik Sense Repository Service (QRS) contains all data and configuration information for a Qlik Sense site. S3 for files: No. Skip to main content. (repository. On your Central Node, stop all services except the Qlik Sense Repository Database. To open the Connection String Editor, navigate to C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil and open the QlikSenseUtil. In Qlik. Ditto - same here! 1,165 Views 0 Likes Reply. When the Qlik Sense Repository Service is started, it looks for all relevant database files to communicate with the database. Qlik Sense supports database traffic encryption using SSL, but you need to perform some manual configuration to setup SSL and password protection, for example, MD5 or SCRAM-SHA-256, in a shared persistence deployment. 3. 862+0300 INFO KAMCQLIKSENSE System. In a single node deployment, both the repository database and the files share are usually located on the same machine as the Qlik Sense services. config. Learning Objectives: Understand the importance of a database backup plan; Review the steps to automate the process of backing up the Qlik Sense Repository Database; You don’t have access to this course. Qlik. com | Qlik Help | ResourcesNavigate to C:Program FilesQlikSenseRepositoryUtilQlikSenseUtil and double-click the QlikSenseUtil. If you have a patch installed, follow these steps:The Qlik Sense repository database (QSR). As a precaution I recommend creating a DB backup before performing the above steps. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. 5 installed locally when you upgrade Qlik Sense, the database will still be used after an upgrade. Review the SERVERNAME_System_Repository log files located in C:ProgramDataQlikSenseLogRepositoryTrace Verify if one of the below. Restart Qlik Sense Services. If you have installed PostgreSQL separately, verify the version using for example the installed programs in Windows. Okay, if your environment is using the Qlik Sense Repository Database Service, then you can find the version of PostgreSQL by going into the database data location of C: ProgramData > Qlik > Sense > Repository > PostgreSQL. Before you can upgrade, you must know your upgrade path, that is, you need to know which version you. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. Exploring the Qlik Sense Repository Database (QS Jun 2020) This module will focus on exploring the Qlik Sense Repository Database. We have an Development single node qliksense windows server, version is August 2022 14. As part of it we need to pass the Qlik Sense Service account password to higher management. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. Manual start Qliksense Repository Database service MISSING. You will find that the Qlik Sense Repository Database service has been set to manual. When any other Qlik Sense service starts, it contacts its local QRS to get configuration parameters. 20160704T095922. Get your Qlik Sense Repository Database superuser password, as this is needed during the upgrade. You can check the one in (or in similar path - as per your environment): C:ProgramDataQlikSenseLogRepository. Use Postman or another tool to test the qrs endpoint response before going to the load script. Proposed action. Do not change the startup method. Use the default postgres Database user and the password created during the Qlik Sense installation. The user might not have authentication. Repository. Open the Windows Services Console and locate the Qlik Sense Enterprise on Windows services. If you used the QPI tool the new database version would be 14. 5 not working Qlik Sense Repository Service will not start up - connection to database "QSR" failed: FATAL: the database system is. Here are some resources that could help, but not give the answer: Migrating from synchronized to shared persistence - Qlik Sense - YouTube. If you have a patch installed, follow these steps: The Qlik Sense repository database (QSR). 16. Repository. Luckily, the installation and upgrade logs are stored in the same place which is the user temporary folder running. This enables the automation of a range of tasks, for. View, update, and explore. EXCEPT the Qlik Sense Repository Database on every node in your deployment. This utility (QlikSenseUtil. Create a connection to the server machine hosting the Qlik Sense Repository database. Restore. PG_DUMP is a built. An existing Database will be detected. Repository database is %ProgramFiles%\Qlik\Sense\Repository\ And, other components is so on. To change the account: Open the Windows Services Console. I couldn't able start any of the qlik sense services and also I couldn't find qlik sense repository database service in the server service. The communication is always unencrypted, but the transferred certificate package is password-protected. exe -h localhost -p 4432 -U postgres -d QSR -e; Determine the scope of what you're going to be doing SELECT * FROM "Users" WHERE "UserDirectory"=' RDSERVDOMAIN '; These users will be deleted and anything. For information about upgrading PostgreSQL, see: Qlik Sense May 2021 - Upgrade bundled PostgreSQL to 12. conf files. To do this, navigate to ProgramDataQlikSenseRepositoryPostgreSQL<database version> and open the. It will not detect a manually installed Postgres version, if you just grab that from Postgres download site, as we have recommended before. Replace 127. Open CMD as Administrator us the below code & replace the service name New service name& Old service name. conf) to allow the password to be changed. 6. Qlik Sense Repository Database (QSR) has a table named SystemRules. Run the Qlik PostgreSQL Installer. Proposed action Uninstall Qlik Sense and select Remove. The Qlik Sense Repository Service (QRS) manages persistence and synchronization of Qlik Sense apps, licensing, security, and service configuration data. qlik. Enter the name of your Windows user, and click Add. 5in'. 196. If you have a patch installed, follow these steps: Do the following: Stop all Qlik Sense services except the Qlik Sense Repository Database ( QRD ), on every node in your deployment. We will go ahead and stop this immediately after the upgrade has finished. Hi, Follow this steps : Start the Qlik Sense Repository Database ( QRD ). Provide your existing Database superuser password and click Next. Ask a Question. Administer Qlik Sense Enterprise on Windows; Videos; Migration Center; Evaluation Guides; Qlik Resources; English (Change) Deutsch; English;. Open the Connection String Editor and Read the current configuration. 2. To increase this value to 2 mins (120 seconds), follow these steps: 1. Run the following commands to restore the repository database (adjust the paths as needed): cd "C:Program FilesQlikSenseRepositoryPostgreSQL<database version>in". Repository database is %ProgramFiles%QlikSenseRepository And, other components is so on. To confirm this: Open the QlikSenseUtil. Another fix for this that worked for me was: 1. For. Theoretically, all logs could be removed and the system will start re-creatig them as soon as you will enable. This article explains one of the ways to quickly find it. The QRS attaches to a Qlik Sense Repository Database and is needed by all other Qlik Sense services to run and to serve Qlik Sense apps. The Qlik Sense Repository Database can reside on the central node or on another computer. I did change this, restarted the server but still the repository does not want start successfully. You will also find a new postgresql-x64-12 service. But wait, what is it exactly? Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today. Click the Sharing tab, and then click Share. As a result, the dependency for Qlik Services will stop with the Qlik Sense Repository Service, same as on a rim node without the database service installed. exe)Our use case for this is to have the ability to monitor the custom properties associated with various Qlik resources such as Users, Apps, streams etc to then have the ability to monitor and audit those resources. Do the following: Click Create new connection. But if space needs to be reclaimed faster, a workaround can be deployed: If the table that is wasting space on C: drive is " _deletedentitylog " it is safe to empty the table manually: Schedule a minimum of 30 min of down time and stop all Qlik Sense Services except for the Qlik Sense Repository Database service. Qlik cannot support direct queries and access to the underlying product's database hosted by PostgreSQL. The database contains configuration data for the site as well as metadata for apps. Perform the following steps to delete the Qlik Sense Repository Database. The properties within the entities correspond to the properties that are configurable in the QMC. Load Script: Use REST Connector with CONNECTION parameter. The Qlik Sense repository database (QSR). In a multi-node deployment, a cluster is formed around. Cause . The DB service is unable to connect to the PostGreSQL. Do not rename this service. What is the reason for Qlik Sense Repository Database running under the Local System Account? Hi, I often see Qlik Sense Repository Database running under the Local System Account, can it be explained why this is so? The other service accounts are run by a specific service account so wanting to understand the exception with the repository database. Restore. zip -p "C:Program FilesNPrintingServerpgsqlin". 3in.