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
@shaan007 we have tried that with another customer with the same issue as you and there it worked. So it is highly possible.
regards
Sebastian
HI @Sonja_Bauernfeind .
Have some good new about the possibility that this tool will support installation of Qlik on a different path/drive?
as you mentioned in reply "2022-09-29 10:57 AM" it is already in roadmap but what we have to do with our customer setup if we can't use this migrating tool?
thanks
Hello @acardella We do not have an estimate on when this will be supported in the tool.
If you cannot use the Qlik PostgreSQL Installation tool, you can carry out a manual upgrade: How to manually upgrade the bundled Qlik Sense PostgreSQL version to 12.5 version
All the best,
Sonja
Hi,
As part of upgrading Qlik from Feb 2022 to Feb 2023. I am getting a prompt to upgrade PostgreSQL.
Is there a possibility of executing this PostgreSQL Upgrade MSI as a silent install.
This is required for automated upgrade of Qlik Sense.
Thanks,
Aadil
Hello @aadil_madarveet
Rather than using the QPI, you would need to do a manual (silent) uninstall and a manual (silent) install as per How to manually upgrade the bundled Qlik Sense PostgreSQL version to 12.5 version.
All the best,
Sonja
When trying to upgrade a 9.6 with the updater (version 1.2.1) , it did not work, since it claimed there was a problem with the backup path.
(error message was in OS language).
error in the Log:
"Exception when dumping database: Der Verzeichnisname ist ungültig."
(~ Exception when dumping database. Invalid path / path name is invalid)
- reproducable
- changing the path does not avoid the error
- updater was run as administration
- the path is created (if not already exisisting)
- serviceuser and user executing the updater have full rights to the path (both the default or when changing it to another, shorter path)
(Feedback: looking through 15 pages of (only) 10 comments each under this post, when looking for this error, is pretty tedious. Is there an option to display all comments on one page?).
@john_oll open a case with Qlik Support, so we can have a look into the installation logs.
Unfortunately there is no option yet with all comments in one page, but we will raise it with the backend team.
best regards
Sebastian
I finally upgraded our Test system yesterday following the procedure detailed above. In the end, everything worked fine and I now have Feb 2023 Patch 2 running on one our servers.
@Sonja_Bauernfeind, I find it preposterous that the Qlik PostgreSQL installer does not recognize a Qlik Sense installation on a different drive than C:, even more so given that the QS installer specifically allows the software to be installed somewhere else. This issue was already brought up in August last year and to me seems to be a kind of an urgent matter. How is that not a functionality built in from the very beginning? The workaround copying the PostgreSQL folder to C: obviously did work as expected but with this being a kind of crucial step in the upgrade process, I find it very strange having to rely on this kind of "hack".
After performing the PostgreSQL installation, I ran the installer of Nov 2022, only to have it sit at "Upgrading Repository Database" for a long time. I then finally killed the process, rebooted the machine and was only then able to perform the upgrade. The same happened when then upgrading to Feb 2023.
Everything seems to be working fine now but I figure I'd share my thoughts on how things went last evening.
@steeefan Agreed, the Postgres upgrade tool should support non c: installation locations. Hopefully we'll sooner rather than later see a new version of that upgrade tool ( @Sonja_Bauernfeind , @Sebastian_Linser any news?).
Meanwhile, you mentioned "...The workaround copying the PostgreSQL folder to C: obviously did work as expected...". Is that workaround described somewhere?
Did you simply place a copy of the Postgres 9.6 directory in the default location on c: and then ran the update program (version 1.2.1 is currently the latest version, I believe)?
Or did you first have to make a separate, standalone 9.6 installation in c:\program files\qlik\.... ?
@mountaindude it is on the roadmap already.
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\
it will use once the pg_ctrl to start the old db, which is always in the data folder c:\programdata\qlik\sense\repository\postgresql
after the migrate process you can delete the folder created on the c drive again.
the latest version supported alternative installation path for postgres so you an install it on the d drive. But it does not support non standard folders for the Qlik Sense installation. But stay tuned for the new release which should come out soon.