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 @MvHeezik Thank you for catching this! I corrected it immediately in my edit pass.
@Sonja_Bauernfeind please add a step between
c. The folder containing the msi will be revealed.
d. Right-click on the msi file and select uninstall from the menu.
You will have to open an File Explorer window first to be able to Right-click the file.
Or change the search explanation to just using File Explorer and the Search bar using postgresql*
See GIF below
@Sonja_Bauernfeind @Mario_Petre
Can you please provide a definite ETA on when this would be included into Qlik and what version/patch. And also how we can automate this via silent install so we could piece it all together into a single script.
This is an important ask considering we have over 400 deployments of Qlik and doing this process manually in each of these is a no go. This has become critical for us considering we are in the process of upgrading all our older environments to Feb 2023 Qlik Sense and our silent upgrades are failing.
Hello @sri_c003
I will be taking a portion of your request (silent install) to my experts. However, I do not know what you mean by "included into Qlik".
Can you please clarify?
What do you anticipate to be included in (I assume) Qlik Sense Enterprise on Windows?
All the best,
Sonja
I mean as in included into Qlik installer without needing a separate process to upgrade the PG db.
Hello @sri_c003
The purpose of the Qlik PostgreSQL Installer is to provide you with the tool to unbundle (and simultaneously upgrade) the PostgreSQL instance used by Qlik Sense. The intention behind this is to give you control over what version of PostgreSQL you wish to run without waiting for the bundled version to be updated by Qlik or having to do an in-place upgrade (which is a lot more work-intensive than upgrading a standalone PostgreSQL database).
The tool and process will not be included in the installer, as the installer still installs a bundled PostgreSQL instance.
If you want to provide us with feedback on the same and request a different feature/method for managing PostgreSQL, I want to recommend heading over to our ideas section and logging an idea.
(Still getting you an answer to the silent install question! I believe we are working on this right now.)
@p_verkooijen Thank you for the suggestion! Changes made.
All the best,
Sonja
We have always been using the bundled Postgres for all our Qlik deployments.
The problem is that the Qlik installer is not upgrading the bundled PG leaving it still at 9.6 when upgrading to 2023 from an older version like Feb 2021 or Feb 2022.
Any ETA on Qlik installer updating PG to needed version without us doing anything manually would be greatly appreciated.
Our findings during Qlik upgrade are as below
Hi @sri_c003,
The purpose of QPI (Qlik Postgres Installer) is to unbundle Postgres.
So people using it are now having a standalone Postgres Database, meaning you can upgrade Postgres yourself.
We have an article which explain how to upgrade a Standalone DB:
https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Enterprise-on-Windows-How-To-Upgr...
If you prefer to have a bundled Postgres DB, then you can use the below method and you'll have again a bundled Database:
https://community.qlik.com/t5/Official-Support-Articles/How-to-manually-upgrade-the-bundled-Qlik-Sen...
Regards,
Benoit
@Benoit_C
Thank you for coming back so quickly. I looked into the document at https://community.qlik.com/t5/Official-Support-Articles/How-to-manually-upgrade-the-bundled-Qlik-Sen...
But the issue is the number of manual steps needed. We have a few hundred deployments of Qlik and doing this manually on all these is simply not a viable option.
We are looking a simpler process where the steps to upgrade Postgres can be automated via a script.
I shall post this conversation on that thread to keep this thread to standalone PG only.