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
@sri_c003 As mentioned by Benoit and I, this is not the purpose of the QPI.
Please log an idea in our ideation platform explaining your need for the Qlik installer packages to upgrade PostgreSQL so that the appropriate team (product management) can review the request and provide you with the most accurate response.
All the best,
Sonja
We are facing lot of trouble due to @ sign in passwords. Most of the existing customers have @ character in password and while upgrade - Postgre installer does not upgrade the Postgre version having @ character in password. This not only limit the secure password setting as well as risk of changing first repository passwords then upgrade.
Any solution in future where installer will work on passwords having @ sign.
@jaishree_Qlik : May I ask which version of the Installer do you use? When using the latest installer v1.3.0 you should be able to upgrade the repository without any restriction of a character in the password.
https://github.com/qlik-download/qlik-postgresql-installer/releases/
For me it worked several times.
@Serkan : Thanks for sharing . I used the same installer available in Download link . Will test the installer mentioned in your git hub link for Postgre SQL upgrade now.
Hello @jaishree_Qlik and @Serkan
Certain characters (& $ " @ ^ §) are blocked for use with QPI 1.3.0 currently and it is recommended to change the password prior to unbundling and upgrading. The password can be changed again afterwards.
We anticipate having this fixed in 1.4.0, which is currently in testing. See the Release Notes for QPI.
All the best,
Sonja
We have been on May 2023 Patch 8, I have upgraded QS to Aug 2023 IR, then upgraded DB from 12.5 to 14.8.
I can connect to DB and see the data is available, but my QS does not run.
All QS services are running as expected.
It seems somehow QS is not bundled with DB. Do you have any recommendations?
I have also checked all Configure-Service.ps1 and path was as "[string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5"," but during upgrade and installation postgres 14.8, the default path was C:\Program Files\PostgreSQL\1
Hello @Narges
If you have used the QPI, the database is unbundled from Qlik Sense. This is intended. Please review the instructions above to see what steps you may have missed.
It may be necessary to revert to a previous backup, verify that everything works on August 2023 IR without a database upgrade, and perform the upgrade following the steps in this article. I do not wish to recommend you try and manually change the connection strings at this stage, as we do not know what went wrong during the upgrade and unbundling.
To properly investigate this, we would need more information from you, such as what issues you are seeing in Qlik Sense, what error messages you are experiencing, and so on. Though a case may be needed to assist you directly.
All the best,
Sonja
Hello again @Narges
As you have already logged a ticket, I suggest handling the issue directly with the support engineer who will be assigned to assist you.
All the best,
Sonja
Hello Super-Sonja,
if I wanted to go back to having Qlik Sense manage the Database service, thus starting from a version that was upgraded with the Tool, do I have to follow the usual Backup procedure, manually uninstall PostgreSQL from the server and then do Restore of the Sense Site?
Dear Luigi,
Usually we will do server snapshot rollback (if available )instead Qlik installer re-running for Postgre SQL. I didn't worked for me.