Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Aug 1, 2024 7:31:00 AM
May 24, 2022 2:40:49 AM
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.
Index
Video Walkthrough
Video chapters:
The following versions have been tested and verified to work with QPI (1.4.0):
Qlik Sense February 2022 to Qlik Sense November 2023.
If you are on a Qlik Sense version prior to these, upgrade to at least February 2022 before you begin.
Qlik Sense November 2022 and later do not support 9.6, and a warning will be displayed during the upgrade. From Qlik Sense August 2023 a upgrade with a 9.6 database is blocked.
The Qlik PostgreSQL Installer supports installing a new standalone PostgreSQL database with the configurations required for connecting to a Qlik Sense server. This allows setting up a new environment or migrating an existing database to a separate host.
Using the Qlik PostgreSQL Installer on a patched Qlik Sense version can lead to unexpected results. If you have a patch installed, either:
Do not use the standard Qlik Sense folders, such as C:\Program Files\Qlik\Sense\Repository\PostgreSQL\ and C:\Programdata\Qlik\Sense\Repository\PostgreSQL\.
Do not use the standard Qlik Sense folders, such as C:\Program Files\Qlik\Sense\Repository\PostgreSQL\ and C:\Programdata\Qlik\Sense\Repository\PostgreSQL\.
Download the installer here.
Qlik PostgreSQL installer Release Notes
The following versions have been tested and verified to work with QPI (1.4.0):
February 2022 to November 2023.
If you are on any version prior to these, upgrade to at least February 2022 before you begin.
Qlik Sense November 2022 and later do not support 9.6, and a warning will be displayed during the upgrade. From Qlik Sense August 2023 a 9.6 update is blocked.
Uninstall the old Qlik Sense Repository Database service.
This step is required. Failing to remove the old service will lead the upgrade or patching issues.
Failing to reinstall the binaries will lead to errors when executing any number of service configuration scripts.If you do not immediately upgrade:
If the upgrade was unsuccessful and you are missing data in the Qlik Management Console or elsewhere, contact Qlik Support.
Now that your PostgreSQL instance is no longer connected to the Qlik Sense Enterprise on Windows services, all future updates of PostgreSQL are performed independently of Qlik Sense. This allows you to act in accordance with your corporate security policy when needed, as long as you remain within the supported PostgreSQL versions.
Your PostgreSQL database is fully compatible with the official PostgreSQL installers from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.
See How To Upgrade Standalone PostgreSQL, which documents the upgrade procedure for either a minor version upgrade (example: 14.5 to 14.8) or a major version upgrade (example: 12 to 14). Further information on PostgreSQL upgrades or updates can be obtained from Postgre directly.
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.
Qlik PostgreSQL installer version 1.3.0 Release Notes
Techspert Talks - Upgrading PostgreSQL Repository Troubleshooting
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
Hello @rammilan20
Qlik NPrinting does not support the manual upgrade of PostgreSQL but will upgrade its PostgreDB on installation/upgrade. Qlik NPrinting May 2022 uses 13.8, see Additional software installed.
As for the MongoDB version for Qlik Alerting, I will review this question for you. I do not think it can currently be upgraded.
All the best,
Sonja
Hello again @rammilan20
MongoDB can be upgraded by simply executing the installer. We recommend to use https://fastdl.mongodb.org/windows/mongodb-windows-x86_64-4.4.22-signed.msi.
The steps are simple:
All the best,
Sonja
Hi @Sonja_Bauernfeind ,
How can I delete the Qlik Sense Repository Database Service If Postgre is Installed in E drive (and I dont have a Package cahe)
I do have a Package Cache in C drive, but I cant see an msi file
Thanks
Hi @pasgalbarra
In order to find the msi file please follow the steps below:
- Once cmd is open, move to the folder mentioned in the article, so execute:
cd "c:\ProgramData\Package Cache"
- Then execute the command below depending the PostgreSQL release you have installed. In my case 9.6:
dir /s PostgreSQL.msi
It has to work.
PS: In your screenshot Windows is not recognizing the command you wrote.
Regards
Thanks! Yes it;s working now.
But I want to upgrade to QlikSense feb 2023 and its failing, in the logs I can see that postgresql 12.5 is mentioned, but after installing the QPI, my version is 14.
Any idea how can I solve it?
Thanks
Hi,
Please assist.
We ran the QPI v1.2 tool awhile back and upgraded our Postgres Db from 9.6 to12.5. We also performed the service cleanup and removed the old Qlik Sense Repository Database service.
We tried using the QPI v1.3 tool to upgrade to Postgres 14.8, but it does not pick up the existing 12.5 database, and instead tries to install a new, empty Db.
Please advise if the QPI1.3 tool does support upgrade from previous Qlik PostgresSQL installer versions
QlikSense version : February2023
Kind Regards,
Siven
@SivenM2020 QPI only migrate Qliks embedded postgres db to a standalone one or installs a standalone from scratch.
Once you migrate with any version of QPI, it can't be used again. That is working as designed.
Hi Sebastian,
We have large financial institution customers that we recommended the QPI tool. They all now face this problem.
Please advise.
Kind Regards,
Siven
Hello, @pasgalbarra Please log a support ticket to receive direct assistance with your request. You can start with Chat Now in the bottom right of the screen.
I am also currently working with our internal team to make it easier to understand that using QPI decouples Postgres and gives the customer control over it, rather than relying on Qlik.
All the best,
Sonja