topic Re: PostgreSQL Upgrade on-prem QlikSense Enterprise in Management & Governance

PostgreSQL Upgrade on-prem QlikSense Enterprise

QLIK_CHEREAU — Wed, 24 Jan 2024 17:15:51 GMT

Hi everyone,

We upgraded our DEV and PROD QlikSense Enterprise Servers to November 2023 Patch 2 version. All worked fine.
We wanted to upgrade PostgreSQL to version 14 (actually 12.5 in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\12.5 folder). On the developpment server, we were able to upgrade and follow Qlik Howto.

When we launched the QlikSense PostgreSQL Installer on the production server, it didn't detect the current PostgreSQL installation. Any idea on our to solve this problem ?

Thanks for your answers

Re: PostgreSQL Upgrade on-prem QlikSense Enterprise

Ray_Strother — Wed, 24 Jan 2024 17:53:04 GMT

Hello,
Please review the below article and confirm the steps have been followed.
https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238

Re: PostgreSQL Upgrade on-prem QlikSense Enterprise

QLIK_CHEREAU — Thu, 25 Jan 2024 08:28:04 GMT

Yes I followed those steps. Again, on development server, no problem.
On production ones, the QlikSense PostgreSQL Installer is unable to detect current PostgreSQL installation, when launch with administrator rights or not.

Re: PostgreSQL Upgrade on-prem QlikSense Enterprise

Vikram_Jayakumar — Tue, 30 Jan 2024 05:34:15 GMT

Hi @QLIK_CHEREAU Can you try this with QPI 1.3 release.

Re: PostgreSQL Upgrade on-prem QlikSense Enterprise

QLIK_CHEREAU — Tue, 30 Jan 2024 08:51:30 GMT

Hi Vikram,

Thanks for the tip, I worked fine with this version.