Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The content you are looking for has been archived. View related content below.
Mar 7, 2024 5:53:56 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
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.
Video chapters:
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 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
@Sebastian_Linser Ace! 🙌
Hello,
same problem here, we need to modify both of the current installation-paths for 9.6 version, which is not possible using the current version of the tool.
We're stuck on may 2022 version since the postgres-problem came up.
Wo don't want to copy the old postgres-folders as long as this is not an official workaround confirmed by Qlik and described in this post.
New full installation on central node is also not an option for us.
Considering Qlik as a standard-software-product, this is a very annoying problem as the postgresql is automatically installed during installation-process.
After upgrading our Test server to Nov 2022 (or then directly to Feb 2023), I have some user contact me and asking whether the server is down. They try to directly open a stream via a bookmark they have said. They then only see "Opening the hub" with nothing further happening.
Turns out that the IDs of all the streams have changed. That never happened before during/after an upgrade. Can anyone confirm this, ideally even from @Sebastian_Linser or @Sonja_Bauernfeind from Qlik?
I'm currently on Qlik Sense Enterprise November 2022 and will be upgrading to Feb 2023.
PostgreSQL is still on version 9.x.
Should I upgrade to Feb 2023 and then use the PostgreSQL updater tool or tool first then Feb 2023?
My install uses the 😧 drive for complete install.
Thanks
@steeefan that is the first time I hear of that, so that said, please open a case with support so we can have a deeper look into that issue.
@dwighttrumbower we will get in touch with you.
Not sure what you mean? I don't have an issue. Just wondering if I should upgrade to Feb 2023 and then do the PostgreSQL update tool or update PostgreSQL and then upgrade to Feb 2023? The install is on the D drive.
Hi @Mario_Petre
First at all thank you for this document.
On the other hand, according the text below I'm understanding that if my QS environment is installed in a different path or drive than the indicated then I can't use QPI to upgrade Postgresql. Is it right?
Thanks
I thought this was fixed with latest postgresql update application?
My installation has been on the D drive from day 1, 6 years ago with Qlik Sense 3. We don't install software on the C drive.
Hi @dwighttrumbower ,
Answering myself (after reading all posts). There's a workaround if PostgreSQL binaries are in a different drive than C:\.
"
The workaround was just to copy the postgresql binary folder from e.g.
D:\program files\qlik\sense\repository\postsgresql\
to
C:\program files\qlik\sense\repository\postsgresql\
"
PS: It would be great if the article would include all these workarounds.
Regards
We had previously used QPI tool to upgrade to postgresql 12 on May 2021 Qlik sense. Now when we are upgrading to November 2022 installer is showing below warning. Let me know if its fine to proceed.
From the comments in this article I am not able to get any confirmation of action to be taken