Skip to main content
Qlik Data Gateway upgrade REQUIRED by September 15 READ MORE

Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer

100% helpful (4/4)
Showing results for 
Search instead for 
Did you mean: 

Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer

In this article, we walk you through the requirements and process of how to upgrade and unbundle an existing Qlik Sense Repository Database (see supported scenarios) as well as how to install a brand new Repository based on PostgreSQL. We will use the Qlik PostgreSQL Installer (QPI).

For a manual method, see How to manually upgrade the bundled Qlik Sense PostgreSQL version to 12.5 version.

Using the Qlik Postgres Installer not only upgrades PostgreSQL; it also unbundles PostgreSQL from your Qlik Sense Enterprise on Windows install. This allows for direct control of your PostgreSQL instance and facilitates maintenance without a dependency on Qlik Sense. Further Database upgrades can then be performed independently and in accordance with your corporate security policy when needed, as long as you remain within the supported PostgreSQL versions. See How To Upgrade Standalone PostgreSQL.



Supported Scenarios


The following versions have been tested and verified to work with QPI 1.3.0 (May 2023): 

February 2022 to May 2023.

If you are on any version prior to these, upgrade to at least February 2022 before you begin.  

Note that November 2022 and later do not support 9.6, and a warning will be displayed during the Qlik Sense upgrade. 

New installs

The Qlik PostgreSQL Installer supports installing a new Qlik Sense Repository Database cluster on a new server, setting up a new environment or migrating an existing Database to a separate host.



  • Review the QPI Release Notes before you continue
  • Using the Qlik PostgreSQL Installer on a patched Qlik Sense version can lead to unexpected results. If you have a patch installed, either:
    • Uninstall all patches before using QPI or
    • Upgrade to an IR release of Qlik Sense which supports QPI
  • This installer will not detect a standalone PostgreSQL database installed by any other means, other than through an official Qlik installer package.
  • The user who runs the installer must be an administrator.
  • The backup destination must have sufficient free disk space to dump the existing database  
  • The backup destination must not be a network path or virtual storage folder. It is recommended the backup is stored on the main drive. 
  • The installer itself does not provide an automatic rollback feature.
  • There will be downtime during this operation, please plan accordingly 


Installing a new Qlik Sense Repository Database using PostgreSQL

  1. Run the Qlik PostgreSQL Installer as an administrator 

  2. Click on Install 

  3. Accept the Qlik Customer Agreement 

  4. Set your Local database settings and click Next. You will use these details to connect other nodes to the same cluster. 

  5. Set your Database superuser password and click Next

  6. Set the database installation folder, standard: C:\Program Files\PostgreSQL\14

  7. Set the database data folder, standard: C:\Program Files\PostgreSQL\14\data

  8. Review your settings and click Install, then click Finish

  9. Start installing Qlik Sense Enterprise Client Managed. Choose Join Cluster option.

    The Qlik PostgreSQL Installer has already seeded the databases for you and has created the users and permissions. No further configuration is needed.

  10. The tool will display information on the actions being performed. Once installation is finished, you can close the installer.  

    If you are migrating your existing databases to a new host, please remember to reconfigure your nodes to connect to the correct host. How to configure Qlik Sense to use a dedicated PostgreSQL database 


Qlik PostgreSQL Installer - Download Link


Download the installer here.

Qlik PostgreSQL installer version 1.3.0 Release Notes



Upgrading an existing Qlik Sense Repository Database

The following versions have been tested and verified to work with QPI 1.3.0 (May 2023): 

February 2022 to May 2023.

If you are on any version prior to these, upgrade to at least February 2022 before you begin.  

Note that November 2022 and later do not support 9.6, and a warning will be displayed during the Qlik Sense upgrade. 


The Upgrade:

  1. Stop all services on rim nodes 

  2. On your Central Node,stop all services except the Qlik Sense Repository Database 

    qlik sense repository database service running.png

  3. Run the Qlik PostgreSQL Installer. An existing Database will be detected. 

    Upgrade Postgre.png

  4. Highlight the database and click Upgrade 
  5. Read and confirm the (a) Installer Instructions as well as the Qlik Customer Agreement, then click (bNext.

    Qlik Customer Agreement.png

  6. Provide your existingDatabase superuser password and click Next.

  7. Define your Database backup path and click Next.

    Location of database backup folder.png

  8. Define your Install Location (default is prefilled) and click Next.

    Location of database installation folder.png

  9. Define your database data path (default is prefilled) and click Next.

    Location of database data folder.png
  10. Review all properties and click Upgrade.

    The review screen lists the settings which will be migrated. No manual changes are required post-upgrade.

    Ready to Upgrade the PostgreSQL installation.png

  11. The upgrade is completed. Click Close.
  12. Open the Windows Services Console and locate the Qlik Sense Enterprise on Windows services.

    You will find that the Qlik Sense Repository Database service has been set to manual. Do not change the startup method. 

    old service set to manual.png

    You will also find a new postgresql-x64-12 service. Do not rename this service. 

    new service postgresqlx6412.png

  13. Start all services except the Qlik Sense Repository Database service. 

  14. Start all services on your rim nodes.

  15. Validate that all services and nodes are operating as expected. The original database folder in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\X.X_deprecated

If the upgrade was unsuccessful and you are missing data in the Qlik Management Console or elsewhere, contact Qlik Support.  


Finalizing the Upgrade/Uninstalling the old Database Service:

Before upgrading Qlik Sense Enterprise on Windows to the next major release

  • for example: November 2022 or higher versions,

The old Qlik Sense Repository Database service must be removed from the server.


Perform the following steps to delete the Qlik Sense Repository Database Service:

  1. Open a command prompt and run the command:
    cd "C:\ProgramData\Package Cache"

  2. From there, run:

    If 9.6:
    From "c:\ProgramData\Package Cache\"
    Run following command: dir /s PostgreSQL.msi

    If 12.5:
    From "c:\ProgramData\Package Cache\"
    Run following command: dir /s PostgreSQL125.msi

  3. The folder containing the msi will be revealed.

  4. Right-click on the msi file and select uninstall from the menu.


Compatibility with PostgreSQL installers

This version of the upgrade tool is fully compatible with the official PostgreSQL installers from

If you have previously used the Qlik Postgres Installer (version 1.2.1 or earlier), you can simply install the latest PostgreSQL version (within your major release).

Example: You have used the old QPI to upgrade to 12.5. You can now easily upgrade to a later version in the same major release, such as 12.15.



  1. If the installation crashes, the server reboots unexpectedly during this process, or there is a power outage, the new database may not be in a serviceable state. Installation/upgrade logs are available in the location of your temporary files, for example:


    A backup of the original database contents is available in your chosen location, or by default in:


    The original database data folder has been renamed to:


  2. Upgrading Qlik Sense after upgrading PostgreSQL with the QPI tool fails with:

    This version of Qlik Sense requires a 'SenseServices' database for multi cloud capabilities. Ensure that you have created a 'SenseService' database in your cluster before upgrading. For more information see Installing and configuring PostgreSQL.

    See Qlik Sense Upgrade fails with: This version of Qlik Sense requires a _ database for _.

    To resolve this, start the postgresql-x64-XX service.


Video Walkthrough


The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support. The video in this article was recorded in a earlier version of QPI, some screens might differ a little bit.


Related Content

Qlik PostgreSQL installer version 1.3.0 Release Notes  
Techspert Talks - Upgrading Qlik Sense Repository Service
Backup and Restore Qlik Sense Enterprise documentation
Migrating Like a Boss
Optimizing Performance for Qlik Sense Enterprise
Qlik Sense Enterprise on Windows: How To Upgrade Standalone PostgreSQL
How-to reset forgotten PostgreSQL password in Qlik Sense
How to configure Qlik Sense to use a dedicated PostgreSQL database
Troubleshooting Qlik Sense Upgrades 

Labels (1)
Partner - Creator
Partner - Creator

Thank you  @Sebastian_Linser  that is what I need

Partner Ambassador
Partner Ambassador

Awesome @Sebastian_Linser, thanks for your efforts on this.
I'll hold off until you have a final release so I can test it out in full.
Figure it's good for you too to get confirmation that things work in the wild too.. 🙂

Thanks again!



I have updated to August 2022 with patch 5.

Thank you.


Why is this so complicated? Isn't this the job of the regular installer, too keep its subsystems up to date?

Partner - Contributor II
Partner - Contributor II

Hi Mario,

Do we have a similar tool to upgrade postgres 12.5 to 12.6 or higher?

Is the higher version supported by the latest Qlik Sense Enterprise?



I currently have February 2022 running with the old version of postgreSQL. The manual instructions say to install May 2021 update. Do I need to do a backup of the current environment (February 2022), uninstall February 2022 and re-install as May 2021?



if you have used the QPI tool to arrive at 12.5, you can just update the DB instance to any newer minor version of 12.x. All 12 versions are approved. For August 2022 and beyond even PostgreSQL 13.


no, Feb2022 is the first approved version to use QPI. the others are May 2022 and August 2022 so no need to downgrade to May 2021, which would also fail with the backup of February 2022.

Partner - Contributor III
Partner - Contributor III

Hi @Sebastian_Linser !

Any news on the new version of QPI? I still cannot find the current version on GitHub: Releases · qlik-download/qlik-postgresql-installer (

Best regards,


The new release of QPI is finished, the current latest version available for download is Qlik Postgresql Installer 1.2.1

Contributor III
Contributor III

Thank for the update @Sebastian_Linser 


Could you please verify that the new version of QPI supports Qlik Sense installations that are not located in C:\ drive?


Many thanks.

Version history
Last update:
a week ago
Updated by: