Open Windows Explorer. The password for QLogs is the same as postgres superuser password and make sure the password entered is correct. Navigate to the location where the PostgreSQL repository database is installed. Starting at Qlik Sense Enterprise on Windows August 2023, the bundled PostgreSQL has been upgraded to C:\ProgramData\Qlik\Sense\Log \\Server\QlikShare\ArchivedLogs. The Windows Events Application logs show the following error: FATAL: lock file "postmaster. There is only one instance of the Qlik Sense Repository Service (QRS) running, and it has direct access to the central repository database. After installing, upgrading to Qlik Sense Enterprise April 2019 or later, or changing the Central node hostname (or hostname for the postgreSQL server) the Qlik Sense node(s) remains offline. com | Qlik Help | ResourcesNavigate to C:Program FilesQlikSenseRepositoryUtilQlikSenseUtil and double-click the QlikSenseUtil. Skip to main content. For. pg_dump. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. As Qlik Sense Enterprise on Windows relies on PostgreSQL for its repository, we want to provide you with steps on how to mitigate the vulnerabilities. As a precaution I recommend creating a DB backup before performing the above steps. conf file is located in "C:Program. 6 to 14 with Qlik Postgress Installer. Hello @TomBond77. Qlik Sense Repository Service will not start up - connection to database "QSR" failed: FATAL: the database system is starting up. We have multiple Qlik Sense cluster and recently upgraded Qlik Sense Enterprise on Windows software from June 2020 Patch 3 to November 2021 Patch 3 on these clusters on different dates. exe -bootstrap is executed. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. 6 to 12. 6in'. The Qlik Management Console allows you to delete data connections, set access rights, and perform other system administration tasks. I have also created "pg_hba. This is to avoid automatic spin up and interaction with the database during the. Information note After installation the services are started automatically, which can take a few minutes. Launch the Windows Command Line As Administrator. 78. . Considerations. 5 here, to find out which one is being used is to - start by renaming the. Create a connection to the server machine hosting the Qlik Sense Repository database. For Host Name type the new Central node FQDN. Highlight the database and click Upgrade. com | Qlik Help | ResourcesThis script loads all QRS data from the repository into an app. The QSR is the primary database in your Qlik Sense deployment. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. Server details: QlikSense May 2021 Patch 16. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. Qlik. By default, this will be installed under C:Program FilesQlikSenseRepositoryUtilQlikSenseUtilQlikSenseUtil. An existing Database will be detected. When installing the newest Update of QlikSense we got stuck at the point "Upgrading Repository Database". Domain. The Share is otherwise accessible by a specified account. Qlik Sense repository servicethe postgres binary folder could be in E:Program FilesQlikSenseRepositoryPostgreSQL9. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. 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. Environment: Qlik Sense Enterprise on 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. msi will be revealed. 4444. Qlik Sense Enterprise server has a set of five databases. Open QlikSenseUtil. When any other Qlik Sense service starts, it contacts its local QRS to get configuration parameters. 16. Do not rename this service. 6 to 12. exe -h localhost -p 4432 -U postgres -b -F t -f. 2. Uninstall Qlik Sense and select Remove Qlik Sense certificates and data folders at the end of the installation. Expand. If the service has not been configured to run, it periodically checks back with the local QRS. . The Qlik Sense Repository Database; The Qlik Sense Repository Service; The Qlik Sense Dispatcher; The Qlik Sense Proxy; To verify if those services are actually functioning correctly, you will need to check their logs. Qlik Sense Repository Database (QRD) 4432 (default listen port for database connections)-No additional ports. Open the Connection String Editor and Read the current configuration, decrypting the current data. It's not possible to run repository in a non-elevated. As a site matures, the. To reset the password, see How-to reset forgotten PostgreSQL password in Qlik Sense on Qlik Community. Do the following: Stop all Qlik Sense services except the Qlik Sense Repository Database ( QRD ), on every node in your deployment. The Techspert Talks session from June looked at Upgrading Qlik Sense Repository Database. This does not include the. Connections are stored in the repository database by the Qlik Sense Repository Service. Stopping the old one didn't affect the server and It keep all working beeing able to access to QMC and Hub, so today I decided to delete the old service. The Qlik Sense services database (SenseServices):The Qlik Sense Repository Database is a PostgreSQL database that contains system data and meta data about apps. Run the Qlik PostgreSQL Installer. 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. The documentation indicates to use a service account for all the services but I wanted to clarify if this also applies to the 'Qlik Sense Repository Database' service. Skip to main content. 2. exe) is placed in the install folder for Qlik Sense Enterprise in the Repository’s Util directory. Now it looks like there is no Qlik Sense Repository Database service but there is postgresql-x64-14. Start Qlik Sense Repository Database service. The password of the SuperUser assigned to the Repository Database has been lost. Open up PG Admin. PostgreSQL has identified two security issues. Get information on the Qlik Sense repository, including version, database provider, and whether the node is the central node of the site or not. Solved: Hi, i'm having issues upgrading Sense June 2019 to September 2019 in a multi node environment. Create a connection to the server machine hosting the Qlik Sense Repository database. ServerQlikShareArchivedLogs. Restart the Qlik Sense Repository Database service. 20. Optionally, provide a password for the file. Before you start installing or upgrading, consider the following: Using the QPI on a patched Qlik Sense version might lead to unexpected issues. Try to run some commands to know if they can be reached. Run the Qlik PostgreSQL Installer. 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 file location opens us D:QlikSenseRepositoryPostgreSQL<database version>in then it means Qlik Sense was likely installed under D:QlikSense and repository service under D:QlikSensePostgreSQL See Serivces for a list of other components and their. This session covers:Hi. If you want to install the QSR database on a dedicated PostgreSQL server, you must install and configure PostgreSQL before you install Qlik Sense, as you will need to enter the PostgreSQL server/host details in the Qlik Sense. msi. The Windows Events Application logs show the following error: FATAL: lock file "postmaster. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. Best, Bjorn. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControl. 5 installed locally when you upgrade Qlik Sense, the database will still be used after an upgrade. Verify that you have sufficient privileges to install system services ' the user has admin privileges . For more information, see Considerations about your Qlik Sense Repository Database. For. 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. Produce a dumpfile for the repository database (that is, a single file for the entire database): cd "C:Program FilesQlikSenseRepositoryPostgreSQL<database version>in". In Qlik. Perform the following steps to delete the Qlik Sense Repository Database. thanks for your helpThe Qlik Sense Repository Database (QRD) and Qlik Sense Repository Service (QRS) are started first. Qlik Sense works normally, but a huge quantity Repository logs is generated. In the command line, navigate to the PostgreSQL bin folder cd "C:\Program files\Qlik\Sense\Repository\PostgreSQL\12. msi will be revealed. The database password is normally password is checked. If that is the case you simply copy the folder E:Program FilesQlikSenseRepositoryPostgreSQL9. g. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. // Qlik SenseRepository Explorer Script // Version date: 27/06/2019 // This script loads each table from the repository to give you the ability to find field values and identify issues without downloading PgAdmin // Even in. Postgres user and password. Qlik Sense Enterprise on Windows . The Qlik Sense Repository Service (QRS) cannot start if there is no repository database, and if the QRS is not running, none of the other Qlik Sense services can start. 1. 11. The steps should be: Do the following: Stop all Qlik Sense services except Qlik Sense Repository Database. The likely root cause is a wrong fixed IPv6 and IPv4 address in the pg_hba. The QPI allows to install a standalone PostgreSQL 14. Program FilesQlikSenseRepositoryPostgreSQL12. This password encrypted and stored in C:Program FilesQlikSenseRepositoryRepository. We have an Development single node qliksense windows server, version is August 2022 14. In the Diagnostics Tool, click the Connection String Editor tab. You need stop all services, expept database service. The backups consist of: The entire VM (VMDK file) Individual Windows folders. On your Central Node, stop all services except the Qlik Sense Repository Database. You will find that the Qlik Sense Repository Database service has been set to manual. 1. This module will focus on the simple task of automating a Qlik Sense Repository database backup. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. The parent folder is where Qlik Sense and/or repository was installed. For information about upgrading PostgreSQL, see: Qlik Sense May 2021 - Upgrade bundled PostgreSQL to 12. We would like to show you a description here but the site won’t allow us. An existing Database will be detected. 1 version we are not able to start Qlik Sense Repository Database (QRD) Upgrading Qlik Sense Repository Database from PostgreSQL 9. Define your Database backup path and click Next. When any other Qlik Sense service starts, it contacts its local QRS to get configuration parameters. You will also find a new postgresql-x64-12 service. Use the MMC command to open the Microsoft Management Console and add the Local Computer and. If you are prompted for the PostgreSQL super user password, enter the password that was given during the. While updating central node, the setup program - 1634429API endpoints (subset) You access the QRS API endpoints to perform create, read, update, and delete operations on entities. 4) create a void DB log with void tables (I run the create script. 10 20180521T004748. Run the following commands to restore the repository database. Expand. Open a Command Prompt with administrator privileges in Microsoft Windows. Operations Monitor App fails to reload after turning off database logging. If the service has not been configured to run, it periodically checks back with the local QRS. Qlik PostgreSQL installer installs the data directory into drive C: and couples your repository. This means there may be a short delay before all services have started. 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. 2) restore the last backup QSR on new Postgress machine. In the Service cluster tab, click OK to retrieve the current Share paths. The Qlik Sense Repository Service ( QRS) contains all data and configuration information for a Qlik Sense site. This is the default path. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControl. Start all services on your rim nodes. thanks for your help The Qlik Sense Repository Database (QRD) and Qlik Sense Repository Service (QRS) are started first. The Qlik Sense repository database (QSR): The QSR is the primary database in your Qlik Sense deployment. 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. Open a Command Prompt with administrator privileges in. To confirm this: Open the QlikSenseUtil. 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. When any other Qlik Sense service starts, it contacts its local QRS to get configuration parameters. 4. On your Central Node, stop all services except the Qlik Sense Repository Database. Skip to main content. The Qlik Sense Management Console (QMC) and/or HUB do not open. g. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. Highlight the database and click Upgrade. The Qlik Sense Repository Database (QRD) and Qlik Sense Repository Service (QRS) are started first. For older logs you have to search in archived log folder. Step 1 - Setup Virtual Proxy. 6 to 12. Manager. 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. Make a backup of the repository database: Open the Command Prompt in Microsoft Windows. 6inpsql. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. 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. Postgres user and password. When deploying Qlik Sense Enterprise on Windows all nodes in the deployment interact with the Qlik Repository Service (installed locally) to determine their configuration and the topology of the deployment from the Qlik Repository Database (installed centrally). Open the Windows Services Console and locate the Qlik Sense Enterprise on Windows services. Database traffic encryption. Run the Qlik PostgreSQL Installer. 2. 5 refers to the PostgreSQL version. exe as Administrator (Default:. Information note After installation the services are started automatically, which can take a few minutes. If you're looking down the path of optimizing every step of the Sense deployment, then upgrading the disks attached to the AWS instance is in play (e. exe backup -f C:NPrintingBackupsNP_Backup. Qlik Sense stores three types of passwords: PostgreSQL database password used by Qlik Sense Repository Service when accessing the repository database. The data is normally added and updated using the Qlik. I think you need the Qlik Sense Repository Database. Uninstall Qlik Sense and select Remove Qlik Sense certificates and data folders at the end of the installation. Select the type of data source you want to create from the drop-down list. Make a backup of the repository database by creating a database dump file: Open a Command Prompt in Microsoft Windows. I get the following error: 21. This decrypts the current data. Upload an extension to the repository database. I'm not sure if a repair install can. On your Central Node, stop all services except the Qlik Sense Repository Database. The drive (C:) is optional, of course, depends on your setup. Hi @veronklop . 196. zip -p "C:Program FilesNPrintingServerpgsqlin". On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. With shared persistence, this port is used to listen for connections from the Qlik Sense Repository Service (QRS). Resolution. An existing Database will be detected. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. This means there may be a short delay before all services have started. On your Central Node, stop all services except the Qlik Sense Repository Database. The Qlik Sense services database (SenseServices): If the Qlik Sense Repository Database was installed during setup it will be located on the central node. 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. We will go ahead and stop this immediately after the upgrade has finished. The output halts on Waiting for certificates to be installed (see screenshot). Regards. It doesn't make sense to me where it went wrong. The QRS notifies the QPS when it is time for a new poll. Stop the services by clicking Stop. Tip note Many JSON structs in the Qlik Sense Repository Service (QRS) API include the modifiedDate property, which is used to avoid conflicts in the repository database. 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. Do not change the startup method. 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. 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. Delete all certificates. msi file so that you can run it. Click here for Video Transcript. The upgrade is completed. Ditto - same here! 14,224 ViewsThank you, this was indeed the case on the . 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 Qlik Sense Repository Service (QRS) manages persistence and synchronization of Qlik Sense apps, licensing, security, and service configuration data. 5 is not recommended. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. Open a command prompt and run the command: cd "C:ProgramDataPackage Cache". Open the Connection String Editor and Read the current configuration. sc config "Old service name". pid" already exists HINT: Is another postmaster (PID XXXX) running in data directory "C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9. Due to which you cannot start the service. You will also find a new postgresql-x64-12 service. 'Qlik Sense Repository Database' (Qlik Sense Repository Database) could not be installed. If the service has not been configured to run, it periodically checks back with the local QRS. PostgreSQL was only deployed during fresh installations of these versions. As a precaution I recommend creating a DB backup before performing the above steps. If the command fails because a database already exists, run the following command and then repeat the. License: Create (using signed license key) | Qlik Sense for developers Help. If you have PostgreSQL 12. In a multi-node deployment, a cluster is formed around. This can be exceeded by users by accident or by unexpected behavior. We run nightly Veeam backups of our Qlik Sense environment. Start all services except the Qlik Sense Repository Database service. 5in'. Qlik Sense is %ProgramFiles%\Qlik\Sense\ 2. This should be done from the PostgreSQL 9. 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 any multi-node or “remote” Qlik Sense Repository Database situation, you need to update the REST data connections to point to the FQDN of the Qlik Sense Repository Service, regardless of where the actual Qlik Sense Repository Database resides. conf files. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. - Qlik Community - 1934238. 3. To open the Connection String Editor, navigate to C:Program FilesQlikSenseRepositoryUtilQlikSenseUtil and open the QlikSenseUtil. exe -bootstrap -iscentral)Note: Any changes to these files will require a restart of the Qlik Sense Repository Database or PostgreSQL. Ditto - same here!I don't know if it's the right solution but the service "Qlik Sense Repository Service" don't running after. Right click the folder, and then click Properties. And each service will be represented by a specific log file. 6 to 14 with Qlik Postgress Installer. In the Service cluster tab, click OK to retrieve the current Share paths. 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 information in this article is provided as-is and to be used at own discretion. An existing Database will be detected. On the Qlik Sense central node, all services but the Qlik Sense Repository Service are shut down. Start all services except the Qlik Sense Repository Database service. nodes to the repository database. Stop all the Qlik Sense services, except for the Qlik Sense Repository Database. Success. The folder containing PostgreSQL. Open the Connection String Editor and Read the current configuration, decrypting the current data. Both the message and the missing file points in the same direction: the file is lost so there is no way the service starts. The Qlik Sense Repository Database can reside on the central node or on another computer. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. We have an Development single node qliksense windows server, version is August 2022 14. The Qlik Sense Repository Service (QRS) cannot start if there is no repository database, and if the QRS is not running, none of the other Qlik Sense services can start. Hello, I am currently connected to my QS Repository Database, using a PostgreSQL connection. g. Broker service. tar" QSR h: Hostname p: Port number U: User ID v: verbosity (adds logging) Note. Hi Experts, I just have one question. 3. This enables the automation of a range of tasks, for. Highlight the database and click Upgrade. If the Qlik Sense Repository Database was installed manually, it may be located on another computer. Replace the current file paths with the new file paths, then click Save . com | Qlik Help | ResourcesOn your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. 0. Net config file, however in the Framework64 sub directory. Use Postman or another tool to test the qrs endpoint response before going to the load script. Open the command prompt as Administrator, and run the following command on the Qlik Sense Central node. It's common. 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. 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. Ditto - same here! 1,106 Views 1 LikeCreate a connection to the QLogs database using the PostgreSQL data source. 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. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support. Most requirements can be met through the. Expand. Stop/Start the Qlik Services Manually. The 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 following REST endpoints in the QRS API are relevant for the QPS: GET /qrs/proxyservice/ {id} PUT /qrs/proxyservice/ {id}Navigate to the Program FilesQlikSenseRepository folder and run Repository. Q: Is the "repository database" the same thing as Postgres database? A: Apparently YES. 5. In response to Shahzad_Ahsan. I ran into an issue where the Qlik repo service would not start up. conf file and hosts file. The idea is to access the repository tables in order to find all objects and corresponding definitions (e. Before you start installing or upgrading, consider the following: Using the QPI on a patched Qlik Sense version might lead to unexpected issues. g. Here you can see all of the tables where Qlik Sense stores data in the current database that will be dropped. Skip to main content. a Master Item measure or a variable, defined inside the app, and its corresponding. 2016-01-15 04:50 AM. When installing the newest Update of QlikSense we got stuck at the point "Upgrading Repository Database". Broker service. In SystemRules table, there is a column called Actions. Make a backup of the repository database. Ask a Question. This enabled an attacker having database-level CREATE privilege to execute arbitrary code as the bootstrap superuser. config. The upgrade is completed. exe. QSMQ. Hit Save Value in config. Navigate to the location where the PostgreSQL repository database is installed. The Qlik Sense Engine Service ( QES) is the application service, which handles all application calculations and logic. The password for the user who is running the service is not correct. txt;The Qlik NPrinting repository service stores all the data necessary for Qlik NPrinting to work properly. I've followed the QPI instructions. This functionality is disabled by default and can be enabled by modifying the files Repository. Note, the Repository. Do not rename this service. Qlik Sense uses PostgreSQL as the repository database. conf and postgresql. Qlik Sense Repository Database service does not show up in the windows service console I want to make backup of the PostgreSQL database in Qlik Sense. Qlik Sense Enterprise can be managed and accessed using a browser. When you’ve located your “Qlik Sense Repository Database” service, let me tell you a secret – it’s a trap – what you see is in fact is a PostgreSQL Database Service. As part of it we need to pass the Qlik Sense Service account password to higher management. msi. 2. When the Qlik Sense Repository Service is started, it looks for all relevant database files to communicate with the database. The decrypted database connection string is displayed. You will also find a new postgresql-x64-12 service. The parent folder is where Qlik Sense and/or repository was installed. 3. 8 database on a new server for a new environment, or to migrate an existing database to a separate host. SenseServices database (if you have a linked cloud environment) QSMQ database (if you have a linked cloud environment) Licenses (optional, license assignments restored from LBS after applying license key - SGK)In any multi-node or “remote” Qlik Sense Repository Database situation, you need to update the REST data connections to point to the FQDN of the Qlik Sense Repository Service, regardless of where the actual Qlik Sense Repository Database resides. Ditto - same here!On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. This article from support has detailed step by step to reset the database password. 16. When the Qlik Sense Repository Service is started, it looks for all relevant database files to communicate with the database. Related Content: How to backup or restore the PostgreSQL database in Qlik Sense . After an in-place upgrade from Windows 2012 R2 server to Windows 2019 you might encounter a non working Qlik Sense Repository Service. The workaround is to change the user Qlik Sense is using to query the database from "qliksenserepository" to "postgres " To do that: Stop the Qlik Sense Repository Service; Run the ConnectionStringEditor. This means that the database password validation did not complete and a partial rollback has occurred. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. pid" already exists HINT: Is another postmaster (PID XXXX) running in data directory "C:ProgramDataQlikSenseRepositoryPostgreSQL9. Is that correct? My server works fine so far. 6 to 12. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. But i am unable to find the loaded. Save the file, close it and start the Qlik Sense Repository Database or PosgresSQL service depending if you are using the native PostgreSQL or a dedicated instance . 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.