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
The content you are looking for has been archived. View related content below.
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
HI Mario,
That's a great tool for helping with postgreSQL upgrade and making it smoother unlike Uninstall/re-install steps.
Do you know when this tool will be available for download? We have upgrade planned and just wanted to make sure that if its available sooner or should we wait for couple of weeks.
Also do you think that after verifying that new PostgreSQL service/DB works fine, should Service be renamed to Qlik Sense Repository Database for future upgrades? would you recommend that?
How future upgrades will change with Two services for Repository Database - Postgre and Qlik Sense Repository DB?
Thanks
Ravi
Hello @RaviGinqo Let me get some clarity for you on this!
Hi,
where can i download the installer? It is not available on the download portal.
Hello @khartmann2
If you mean the tool mentioned in this article: This is not yet available. We will update the article when it is.
@RaviGinqo Hello Ravi,
The tool is still with our developers, but we will update this article when it is released. I would recommend subscribing to it.
As for your second question: Please do not rename the service.
All the best,
Sonja
Thank you @Sonja_Bauernfeind
By any chance do you know if it will available this month? If so, I can plan our upgrades accordingly.
Ravi
Hello,
Yes, we are also looking for this tool. Please let us know when its ready, so we can start testing in our environment.
Kind Regards,
Siven
Hello @RaviGinqo and @SivenM2020
I will reply in this thread once we have it and alert everyone who has actively asked for it. Hopefully, the tool will be available next week.
All the best,
Sonja
hi, where can i download this tool?
@SDW @SivenM2020 @RaviGinqo @khartmann2
Hello all,
For the time being: if you’re interested in upgrading the PostgreSQl Repository database to 12.5 using this installer, please make a request for the installer via the Case Portal so that Qlik can assist you with this upgrade.
All the best,
Sonja