Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team
March 14th 2023: You may have upgraded Qlik Sense and located a warning banner in your Management Console stating that this version of PostgreSQL is not supported. If you are running a standalone PostgreSQL database later than 9.6, this message can be disregarded. We are working on resolving the underlying cause.
In this article, we walk you through the requirements and process of how to upgrade an existing Qlik Sense Repository Database from PostgreSQL 9.6 to PostgreSQL 12.5 (see supported scenarios) or install a brand new Repository based on PostgreSQL 12.5.
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
PostgreSQL 9.6 has reached End of Life Reference: PostgreSQL Versioning Policy.
Download the installer here.
Qlik PostgreSQL installer version 1.2.1 Release Notes
Before using the Qlik PostgreSQL Installer, upgrade to a supported version of Qlik Sense Enterprise on Windows. Then use the Qlik PostgreSQL Installer to upgrade PostgreSQL.
We tested and validated Qlik Sense Enterprise on Windows from February 2022 to February 2023. Note that November 2022 and later do not support 9.6, and a warning will be displayed during the Sense upgrade.
Qlik Sense Enterprise on Windows installations other than in C:\Program Files\Qlik\Sense are currently not supported.
If the upgrade was unsuccessful and you are missing data in the Qlik Management Console or elsewhere, contact Qlik Support.
No further steps are needed unless you plan to upgrade Qlik Sense Enterprise on Windows to the next major release. If you plan to upgrade to, for example, November 2022, 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:
This version of the upgrade tool is fully compatible with the official PostgreSQL installers from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.
If you need to upgrade to a higher release than Qlik provides, you can install the same minor PostgreSQL release 12.x.
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.2.1 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
I have a customer with PostgreSQL 9.6 and QSEoW Nov' 22 version.
I'd like to upgrade to Feb '23 version.
Do i need to upgrade PostgreSQL to version 12.5 or not?
Please let me know.
@agigliotti You will need to upgrade PostgreSQL to 12.5 if it is still on 9.6. Feb´23 does not support 9.6 in any other context than for the initial upgrade.
When you upgrade Sense, the installer will alert you that upgrading the PostgreSQL db is necessary.
Since your customer already has November 2022, you can follow the instructions in this article to upgrade to 12.5 before you move to February 2023.
Alternatively, you can go ahead and upgrade to February first and then follow the instructions in this article. The choice is yours.
All the best,
@Sonja_Bauernfeind So if I well understood the QSEoW Feb '23 version is the first version where PostgreSQL v12.5 is required to upgrade successfully.
Is this right?
Because i got the installer alert also when I upgraded to Nov '22 version , however the upgrade completed successfully with PostgreSQL 9.6
November 2022 already does not support 9.6 for production (only for upgrade purposes). It will have warned you during the upgrade process. See System Requirements: 9.6x (for upgrade scenarios from previous versions only—no longer supported after February 2023)
What'll happen when you upgrade:
As you mentioned yourself, if you upgrade a Sense system running PostGRE 9.6 to November 2022, it will alert you with this message:
You can continue though! The same will happen for February 2023. There is no hard stop yet for the upgrade itself.
Here are the February 2023 System Requirements: 9.6x (no longer supported after February 2023)
Does this help?
All the best,
@Sonja_Bauernfeind Ok thanks for your support.
Is there any warning about using PostgreSQL 9.6 with Feb '23 version? Maybe something related to the overall performance?
Version Nov' 22 with PostgreSQL 9.6 is working fine.
Anyway do you suggest to upgrade PostgreSQL to 12.5 version?
Anytime! Let's see if I can answer your remaining questions too. I will go into as much detail as possible so that we can also help other people with similar questions.
If by warning you mean the alert that is displayed when you upgrade with PostgreSQL 9.6 installed, then, yes. February 2023 will alert you just like November 2022 did. As for why we no longer support 9.6 with Qlik Sense: It has reached end-of-life and is not being supported by Postgre any more.
Yes, please upgrade PostgreSQL to 12.5.
And on November 2022 working fine with 9.6: While we expect no issues running it while a customer prepares for an upgrade to 12.5, we cannot guarantee it in a production environment. Please see the release notes for supported PostgreSQL versions with any of our Sense releases.
Hi and thank you very much for this article !
If i understand correctly, after using QPI for upgrading postgreSQL from 9.6 to 12.5, at the end Qlik Sense Repository Database service is removed (replaced by postgresql-x64-12 service)
But if you run a brand new installation of Qlik Sense November 2022 for example, the service is still there, is it correct ?
Even after using QPI, there won't be any problem for future upgrade regarding the lack of Qlik Sense Repository Database service ?
Have a nice day.
Yes that is correct, you would get the embedded Postgres in version 12.5 when you reinstall fresh.
But the second option is using QPI, before reinstalling fresh and user the option to install a fresh database, then you can install Qlik Sense in the same external instance. The advantage here is the possibility to quickly upgrade postrges from 12.5 to e.g. 12.11 if you would need that.
upgrades will work in both scenarios.
if Qlik is not installed under C:, then the upgrade of the postgres installation works if you copy the directory "...\Qlik\Sense\Repository\PostgreSQL\9.6" to C:
But the article says: "Qlik Sense Enterprise on Windows installations other than in C:\Program Files\Qlik\Sense are currently not supported."
When will this be supported? Because there are several customers whose Qlik installation is not under C:.