If you are changing the user account on your primary or central node, run Repository. Do the following: Stop all Qlik Sense services except the Qlik Sense Repository Database ( QRD ), on every node in your deployment. Navigate to the location where the PostgreSQL repository database is installed. In a single-node deployment, both of these are usually on the name machine as the Sense services. 5 version and Upgrading Qlik Sense Repository Database from PostgreSQL 9. You will find that the Qlik Sense Repository Database service has been set to manual. Start all Qlik services. Qlik Sense has been uninstall for upgrade but we are not able to reinstall it due to the lack of the password. In the LogOnForm screen, enter the database user and password that you used during the Qlik Sense installation. The. 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. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. At times, it may be necessary to provide a backup of the QSR to Qlik Support for troubleshooting purposes. To open the Connection. Note, the Repository. 6. pg_dump. The Qlik Sense repository database (QSR): The QSR is the primary database in your Qlik Sense deployment. The Qlik Sense repository database (QSR). In PostgreSQL, change the authentication mode in the configuration settings to allow the password to be changed. Get information on the Qlik Sense repository, including version, database provider, and whether the node is the central node of the site or not. To increase this value to 2 mins (120 seconds), follow these steps: 1. Ask a Question. Resolution. I am having an issue with installing Qlik using an external repository database. 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. 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. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. Stop/Start the Qlik Services Manually. The database password is normally password is checked. For various and valid reasons, you might need to migrate your entire Qlik Sense environment, or part of it, somewhere else. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. 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. 7 Restoring a Qlik Sense site. Stop the services by clicking Stop. Open the Windows Services Console and locate the Qlik Sense Enterprise on Windows services. 2. As per the steps I need to stop all the services except the. Highlight the database and click Upgrade. 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. The QPI allows to install a standalone PostgreSQL 14. 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. So, the first one as you can see it's PostgreSQL, so Qlik Sense Repository Database, and then it will continue here. An existing Database will be detected. Make a backup of the repository database by creating a database dump file: Open a Command Prompt in Microsoft Windows. 2020-09-17 07:19 AM. The Windows Events Application logs show the following error: FATAL: lock file "postmaster. 2. 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. 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. As part of it we need to pass the Qlik Sense Service account password to higher management. Or it may be necessary to restore a backup of the QSR to resolve an issue. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. The idea is to access the repository tables in order to find all objects and corresponding definitions (e. EXCEPT the Qlik Sense Repository Database on every node in your deployment. The password for the user who is running the service is not correct. Port 4432. For more information, see Installing and configuring PostgreSQL. 6inpsql. When installing the newest Update of QlikSense we got stuck at the point "Upgrading Repository Database". On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. Another one 'Reload Monitor' checks for DB logs first, If not found then goes for Files logs. 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. This article from support has detailed step by step to reset the database password. 3. Highlight the database and click Upgrade. Stop all the Qlik Sense services Verify that the Qlik Sense Repository Database service (or postgresql-x64-xx if the database is not a bundled install and/or was installed using QPI) is stopped. Stop all Qlik Sense services except the Qlik Sense Repository Database (QRD), on every node in your deployment. The Qlik Sense Repository Database service starts and stops immediately. Repository. Actions column holds numbers like 2, and 15, and 2080, and several others. 6 to 14 with Qlik Postgress 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. The upgrade is completed. exe. Start Qlik Sense Repository Database service. The Qlik Sense Repository Service (QRS) contains all data and configuration information for a Qlik Sense site. A Qlik Sense Data Connection is being set up to a share hosted outside the Windows Domain. 4) create a void DB log with void tables (I run the create script. Open CMD as Administrator us the below code & replace the service name New service name& Old service name. Again we need to delete all self-sign certificates as performed on the Rim node. 2. PG_DUMP is a built. The Qlik Management Console allows you to delete data connections, set access rights, and perform other system administration tasks. The Qlik Sense repository Service stops working after 5 seconds. It doesn't make sense to me where it went wrong. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. 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. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. For older logs you have to search in archived log folder. conf and postgresql. exe file (default location C:Program FilesQlikSenseRepositoryUtilQlikSenseUtilQlikSenseUtil. QSMQ. Solved: Hi, i'm having issues upgrading Sense June 2019 to September 2019 in a multi node environment. In our instance, considering we. You can restore the Last Known good configuration of Qlik Sense Enterprise on Windows backup. You will also find a new postgresql-x64-12 service. g. First, connect to the database under the Connect to database tab. Port 4432. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. 2. Highlight the remaining services: Qlik Logging Service and Qlik Sense Service Dispatcher. To confirm this: Open the QlikSenseUtil. To create a file share and share the folder with specific users: Create a local folder on your server computer. Skip to main content. (As I understood from Governance Apps script). Using the article "Changing the repository database user password" in Qlik. But this undermines the purpose of failover. The drive (C:) is optional, of course, depends on your setup. Qlik Sense software; Repository database (QSR): The database contains all configuration data for the site. Ditto - same here! 14,224 ViewsThank you, this was indeed the case on the . An existing Database will be detected. 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. Change the Password in the following two connectionStrings : QSR. Navigate to the location where the PostgreSQL repository database is installed. Backing up and restoring the Qlik Sense Repository Database (QSR) can be intimidating. postgresql. . If you used the QPI tool the new database version would be 14. Description. Body-Return value. Qlik Sense Repository Database Contents. Replace 127. QRSMain 7 3c7c0c23-d9b1-455a-b11f-d4d5a7a4f508 NT AUTHORITYSYSTEM Waiting up to 300 seconds for database to respond 3c7c0c23-d9b1-455a-b11f-d4d5a7a4f508Description. To do this, navigate to ProgramDataQlikSenseRepositoryPostgreSQL<database version> and open the. 202. In a multi-node deployment, a cluster is formed around. Windows could not start the Qlik Sense Repository Service service on Local Computer. Thanks. Backing up the Qlik Sense Repository Database after uninstalling Qlik Sense. To know which, you open the properties Menu on the service you're trying to start, and go to the Dependencies TAB. 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. To open the Connection String Editor, navigate to C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil and open the QlikSenseUtil. Navigate to C:ProgramDataQlikSenseRepositoryPostgreSQL9. Highlight the database and click Upgrade. Nov 24, 2023 7:06:33 AM Updated By: Sonja_Bauernfeind Upgrading Qlik Sense Enterprise on Windows with a standalone PostgreSQL database to August 2023 or later. 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. 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. I have these messages in Windows Event Viewer : "The description for Event ID 300 in the Qlik Sense Service Dispatcher source could not. Is there a database diagram/schema of the Qlik Sense Repository Database tables? The tables are accessible through PGAdmin etc but it is an onerous task to figure out how the tables link when writing queries so wondering if there is a diagram that identifies relationships. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. I've followed the QPI instructions. An existing Database will be detected. 5. 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 installer. Luckily, the installation and upgrade logs are stored in the same place which is the user temporary folder running. Manually restart the Qlik Sense Repository Service to apply the changes. Run the Qlik PostgreSQL Installer. Make a backup of the repository database by creating a database dump file: Open a Command Prompt in Microsoft Windows. The Qlik Sense Repository Database administrator role has full access to the Qlik Sense Repository Database that contains all configuration data for the Qlik Sense site. For the April 2018 Release should the account for the 'Qlik Sense Repository Database' be the Local System Account or a Windows User with local Admin. Qlik Sense Repository Database (QRD) 4432 (default listen port for database connections)-No additional ports. Best, Bjorn. Environment: 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. Restart the Qlik Sense Repository Database service. Related Content: How to backup or restore the PostgreSQL database in Qlik Sense . An existing Database will be detected. If you choose to install. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. 6 and run the QPI installer. Right-click go to Properties. An existing Database will be detected. 78. msi file so that you can run it. 10 20180521T004748. So, this is the order it went through. Highlight Qlik Sense Repository Database and click Stop. Open CMD as Administrator us the below code & replace the service name New service name& Old service name. The QLogs database really only have three tables, kind of a copy of the log files . Before you start installing or upgrading, consider the following: Using the QPI on a patched Qlik Sense version might lead to unexpected issues. 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. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. Normally, the Qlik Management Console ( QMC) is used to manage the QPS settings, but the settings can also be changed using the QRS API. Qlik. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. 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. Start the Qlik Sense Repository Database (or postgresql-x64-xx). Does anyone have any idea?. 5. 6 to 12. Optionally, add privileges to the returned entities. Make a backup of the repository database. Verify that you have sufficient privileges to install system services ' the user has admin privileges . 5 not working Qlik Sense Repository Service will not start up - connection to database "QSR" failed: FATAL: the database system is. This enabled an attacker having database-level CREATE privilege to execute arbitrary code as the bootstrap superuser. The background threads are stopped. Backup and restore Qlik Sense ‒ Qlik Sense. Yes. com. In the Service cluster tab, click OK to retrieve the current Share paths. 6 to 12. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. exe and open. com | Qlik Help | ResourcesThe repository database stores system and app meta data, while the file share stores binary application data such as data models and app content. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. Wanted to understand should we change/pass the Qlik Sense repository. To change the service account user, see Changing the user account to run Qlik Sense services . (Detailed Steps) Option 3: Restore the missing/deleted file from the Antivirus bin folder if not permanently deleted. For information about upgrading PostgreSQL, see: Qlik Sense May 2021 - Upgrade bundled PostgreSQL to 12. Start all services except the Qlik Sense Repository Database service. Open the Windows Services Console and locate the Qlik Sense Enterprise on Windows services. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. exe. It's common. 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. Open the Connection String Editor and Read the current configuration, decrypting the current data. The data is normally added and updated using the Qlik. a Master Item measure or a variable, defined inside the app, and its corresponding. x For more information about the QPI, see: Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer. This decrypts the current data. You will also find a new postgresql-x64-12 service. STT - Moving to Shared Persistence - YouTubeSo, there are a lot of different logs, and the reason is because Qlik Sense has multiple services to upgrade. Command line method: C:"Program Files"QlikSenseRepositoryPostgreSQL9. An existing Database will be detected. Connections are stored in the repository database by the Qlik Sense Repository Service. Host Name: the hostname of your database; use localhost if local; Port: the Qlik Sense Repository port; use 4432. g. Also check will this machine contains proper security or windows licence and they are updated also. A Qlik Sense Enterprise on Windows environment can have a bundled PostgreSQL database or a standalone database. PostgreSQL has identified two security issues. Click the Continue button below to login. The repository database stores system and app meta data, while the file share stores binary application data such as data models and app content. Server details: QlikSense May 2021 Patch 16. Qlik Sense Repository Database (QSR) has a table named SystemRules. 1/32 with a sub net specification that covers all the IP addresses of the nodes in your site. Reinstall using a database username and password with characters from the same character set. It is not possible to retrieve the password for the repository database superuser. The likely root cause is a wrong fixed IPv6 and IPv4 address in the pg_hba. I installed the QPI setup and ran it according to the steps provided in the community post above on the test scheduler server and the setup showed "Not Applicable". Before doing any further changes, it is important to take a backup of your Qlik Sense Platform. PostgreSQL was only deployed during fresh installations of these versions. INFO. Create a connection to the server machine hosting the Qlik Sense Repository database. Click Close. 0. Operations Monitor App fails to reload after turning off database logging. I have a requirement to load data remotely from different postgres databases. For. In response to Shahzad_Ahsan. Run the following commands to restore the repository database. Hi Experts, I just have one question. From there, run: c:ProgramDataPackage Cachedir /s PostgreSQL. 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. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControl. Recently I've upgraded my Postgres 9. An existing Database will be detected. Ditto - same here! 1,165 Views 0 Likes Reply. conf and postgresql. The Qlik Sense Repository Database (QRD) and Qlik Sense Repository Service (QRS) are started first. With content cache-controls, you can modify the cache behavior of the browser. On your Central Node, stop all services except the Qlik Sense Repository Database. Information note After installation the services are started automatically, which can take a few minutes. If you have version 12. The Qlik Sense Repository Service (QRS) contains all data and configuration information for a Qlik Sense site. In a single-node site, the Qlik Sense services are all running on the same node. Database traffic encryption. 2023-03-29 11:43 AM. And there is no easy fix, only to go back to a snapshot of the server from before this issue occured. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. Highlight the database and click Upgrade. The Qlik Sense Repository Service ( QRS) contains all data and configuration information for a Qlik Sense site. The upgrade is completed. To create a new repository database on the current computer, click Create a new database. qlik. This line determines which servers can access the repository database server. This will install PostgreSQL 12. In this example, the connectionstring. Perform the following steps to delete the Qlik Sense Repository Database. One of Governance App, 'Operations Monitor' by default checks for File Logs. Not all QRS API endpoints are documented here. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support. This functionality is disabled by default and can be enabled by modifying the files Repository. To create a file share and share the folder with specific users: Create a local folder on your server computer. 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. Qlik Sense uses PostgreSQL as the repository database. This means there may be a short delay before all services have started. In a multi-node deployment, a cluster is formed around. conf file and use the ::/0 (for all IPv6 addresses). If the service has not been configured to run, it periodically checks back with the local QRS. This enables the automation of a range of tasks, for. The Qlik Management Console allows you to delete data connections, set access rights, and perform other system administration tasks. 78. This cloud service provides the ability to create data pipelines to perform a variety of data integration tasks in support of your data. An existing Database will be detected. Highlight the database and click Upgrade ; Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (b) Next. exe. 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. they will be recreated during the next startup services. Qlik Sense Installation Guide 8 On the Shared persistence database connections settings screen, select the Install local database check box if you want to install a local repository or leave the check box unchecked if you want to connect to an existing repository database. This module will focus on exploring the Qlik Sense Repository Database. Expand. The qliksenserepository user (or the user specified in the repository connection string) does not have sufficient access to the tables in the repository database. Open up PG Admin. Most requirements can be met through the. Now it looks like there is no Qlik Sense Repository Database service but there is postgresql-x64-14. 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. Right click the folder, and then click Properties. FYI, we already upgraded the PostgreSQL to version 14 using QPI. 16. Open the Windows Services Console and locate the Qlik Sense Enterprise on Windows services. 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 . 1. The password of the SuperUser assigned to the Repository Database has been lost. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. Run the Qlik PostgreSQL Installer. Use Postman or another tool to test the qrs endpoint response before going to the load script. Optionally, provide a password for the file. When any other Qlik Sense service starts, it contacts its local QRS to get configuration parameters. 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. If you have PostgreSQL 12. I'm trying to find a corresponding table that maps Action IDs to. Qlik Sense Enterprise server has a set of five databases. Qlik. In the Connection String Editor tab, click Read to open the Repository. I renamed it back to Qlik Repository Database . 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). License: Create (using signed license key) | Qlik Sense for developers Help. For older logs you have to search in archived log folder. Expand. com | Qlik Help | ResourcesYou will find that the Qlik Sense Repository Database service has been set to manual. Start Qlik Sense Repository Service and the other Qlik Sense services. Learning Objectives: Configure pgAdmin to connect to the Qlik Sense Repository Database. Reading through the documentation provided by Qlik, it is suggested to execute a "pg_dump" for the postgreSQL repository database. The immediate issues would be recorded in this folder log files. If the service has not been configured to run, it periodically checks back with the local QRS. Reinstall using a database username and password with characters from the same character set. Make a backup of the repository database by creating a database dump file: Open a Command Prompt in Microsoft Windows. I think if you see both folders of 9. Do the following: Click Create new connection. exe -bootstrap is executed. 5 version and Upgrading Qlik Sense Repository Database from PostgreSQL 9. An existing Database will be detected. . You will also find a new postgresql-x64-12 service. qlik. Also, the Repository Database is accessible when you do this right? I was reading the part where you wrote '. The DB service is unable to connect to the PostGreSQL. Run the Qlik PostgreSQL Installer. 3. Stop all Qlik Sense services except the Qlik Sense Repository Database (QRD), on every node in your deployment. We have an Development single node qliksense windows server, version is August 2022 14. Environment: Qlik Sense Enterprise on Windows . exe -bootstrap -iscentral)Note: Any changes to these files will require a restart of the Qlik Sense Repository Database or PostgreSQL. The output halts on Waiting for certificates to be installed (see screenshot). Though, if you have a valid Sense Server. I think you need the Qlik Sense Repository Database. On your Central Node, stop all services except the Qlik Sense Repository Database ; Run the Qlik PostgreSQL Installer. Now it looks like there is no Qlik Sense Repository Database service but there is postgresql-x64-14. You can find the repository database superuser password using the Connection String Editor which is included in the Qlik Sense diagnostic tools. This includes: users and their roles, report metadata, connections, and filters. 5 version and Upgrading Qlik Sense Repository Database from PostgreSQL 9. I assume this data is attainable as (INTERNALsa_repository) connections are set-up to feed the standard monitoring. ModelRepository`1[[Repository. Both the message and the missing file points in the same direction: the file is lost so there is no way the service starts. 25. 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. 13. For. Open QlikSenseUtil. 199. We have an Development single node qliksense windows server, version is August 2022 14. 3 and open pg_hba. This Qliksense is. To verify the password of postgres you are entering is correct you can use the Util tool at " C:Program FilesQlikSenseRepositoryUtilQlikSenseUtil " and click on connect to database and. 6 to 12. Labels (1) Labels Subscribe by Topic: Qlik Sense; Ditto - same here!'Qlik Sense Repository Database' (Qlik Sense Repository Database) could not be installed. The following deployment example shows a Qlik Sense Enterprise on Windows single-node site. The QRS notifies the QPS when it is time for a new poll. 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 Service (QRS) contains all data and configuration information for a Qlik Sense site. Select Service cluster , then click OK to retrieve the current file share path. Start all services except the Qlik Sense Repository Database service. Community. If you are prompted for the PostgreSQL super user password, enter the password that was given during the. Make a backup of the repository database: Open the Command Prompt in Microsoft Windows. In the right pane, locate the ServicesPipeTimeout entry. exe -bootstrap -iscentral. The folder connection attempt returns Invalid Path. Copy and paste the following backup syntax to the command prompt console. In SystemRules table, there is a column called Actions. Expand. Is it possible to setup a data connection in Qlik Sense to create a dashboard using the NPrinting repository data?. Highlight the database and click Upgrade. postgresql qlik-sense qrs repository Forewarning - loading data directly from the repository is not recommended. 1/32, only allows local host to access the database. exe file as an administrator. 2021-11-12 01:14 PM. As a precaution I recommend creating a DB backup before performing the above steps. conf and capabilities. 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). The database contains configuration data for the site as well as metadata for apps. 16. Run the Qlik PostgreSQL Installer. Here you can see all of the tables where Qlik Sense stores data in the current database that will be dropped.