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
Oh.... I see. Nasty.
Re the repair that the 2022-Nov installer did.
Did it install PG 9.6 again, or 12.5?
If it installed 12.5 that would mean you technically have a fully upgraded (to 2022-Nov and PG 12.5) server, right?
Not that it's an upgrade process I'd recommend to anyone, but still.
The extra postgresql-x64-12 service should be possible to get rid of, but all this should not be needed in the first place, of course.
Feels like Qlik should take a look at this.
Ping @Mario_Petre @Sonja_Bauernfeind
Speaking of the support team: Seems it's not possible to edit your own entries in this forum. At least I can't.
Tried Chrome and Safari (both on Mac). Feel free to forward to the community/forum team.
@p_verkooijen I reviewed the discussion so far, and it seems the repair did remap the service to the new executable for 12.5, but the "new" PostgreSQL should point to the same binary. The Qlik Postgres Installer should've added a Program to your Programs and Features, which you can use to uninstall. Still, the worry is that it will remove the currently active Repository Database.
I want to set up a workshop to look at this together. Please open a Support case referencing this discussion, we will fill in the rest of the details, and I will do my best to help. In the meantime, you can leave the postgresql-x64-12 service Disabled to avoid interference.
@mountaindude, thanks for the ping 🙂
@mountaindude as @Mario_Petre noted the repair just recreated the Repository Database service and pointed it to the upgraded Postgres 12.5 using the Postgres upgrade tool.
See below the commands within the Services
Service: postgresql-x64-12 - PostgreSQL Server 12
"C:\Program Files\Qlik\Sense\Repository\PostgreSQL\12.5\bin\pg_ctl.exe" runservice -N "postgresql-x64-12" -D "C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\12.5" -w
Service: Qlik Sense Repository Database
"C:\Program Files\Qlik\Sense\Repository\PostgreSQL\12.5\bin\pg_ctl.exe" runservice -N "QlikSenseRepositoryDatabase" -D "C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\12.5" -o "-p 4432"
Disabled the service "postgresql-x64-12 - PostgreSQL Server 12" for now
Can remove the service using the right tooling / registry so not worried about that
@Mario_Petre I will get to you lateron
Hi,
I just used the tool to upgrade postgresql from 9.6 to 12.5 version, but after a while it was stucked with an error message like below:
Writing version into .ini file...
I must killed the process through task manager and the new postgresql windows service was not being created.
After I removed the sub folder named 12.5 under postgresql created by the tool, and reinstalled again QSEoW November version.
I got the same warning message about postgresql 9.6 that was detected and I have continued with the installation.
Finally the QSEoW has been upgraded successfully to the new version.
Best Regards
Hi @agigliotti
I also seemed to get stuck on : Writing version into .ini file
It took forever to finish, however I checked the process using Microsoft ProcesMonitor (http://live.sysinternals.com/procmon) and it was writing in the new database so I just sat it out.
You basically killed the migration, and yes you can continue the installation using the old 9.6 version.
Your QSEoW is upgrade, with the old Postgresql
HI @Sonja_Bauernfeind , our site went down after the upgrade although I got a
installation message, could you please help in this regard?
successful
Hi All
I ran into a small problem using the QLIK PostgreSQL Installer
If your password for the superuser "postgres" contains special symbols then you might get a failed atempt to upgrade the postgresql from 9.6 to 12.5
In my case, the password to my superuser contain a PIPE symbol which resultet in a error.
Changing the superuser's password to something simpel first, did the trick. And the upgrade using Qlik PostgreSQL Installer ran through without any problems.
All the best,
Lars
Hi All,
I have upgraded PostgreSQL from 9.6 to 12.5 however I noticed that the QLOGS database is still available.
I thought that QLOGS database is deprecated.
Can some one please advise?
When I try to upgrade the Qlik Sense August 2022 SR3 to November 2022 error was
is there any fix for this error?