Qlik Sense - Version Upgrade

[Nicolae_Alecu]

Hello,

Currently I'm using Qlik Sense May 2022, but i want to upgrade to Nov 2023. 

Can i upgrade directly to this version, or it could create problems?

Thank you,

[p_verkooijen · Accepted solution]

Best to uninstall any patch before upgrades.

Probably you have to upgrade PostgreSQL using QPI
The Nov 2023 installer will inform you if you have to upgrade.

As of March 2023, PostgreSQL 9.6 is no longer supported.

• https://help.qlik.com/en-US/sense-admin/November2023/Subsystems/DeployAdministerQSE/Content/Sense_De...
  
  

Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer

• https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repo...

[Chetan_MN]

Hi @Nicolae_Alecu Yes, you can upgrade but you need to have the Postgres upgraded to 14.8 (suggested) using QPI.

https://help.qlik.com/en-US/sense-admin/November2023/Subsystems/DeployAdministerQSE/Content/Sense_De...

Note: below steps are required. Failing to remove the old service will lead to upgrade or patching issues.

1. Open a command prompt and run:

   c:\cd ProgramData\Package Cache

2. From there, do one of the following:

   • If you upgraded from 9.6, run:

     c:\ProgramData\Package Cache\dir /s PostgreSQL.msi

     The folder containing PostgreSQL.msi is displayed.

   • If you upgraded from 12.5, run:

     c:\ProgramData\Package Cache\dir /s PostgreSQL125.msi

     The folder containing PostgreSQL125.msi is displayed.

3. Right-click the PostgreSQL.msi or PostgreSQL125.msi file and select Uninstall from the menu.

[Nicolae_Alecu]

Hello @p_verkooijen, @Chetan_MN,
Thanks for your responses, but i have one more question.

We run a multi-node enviroment, and our repository it's on Azure Postgres Service.
Now, if i check the postgres version in QSR (PostgreSQL Shell) i have this one : "PostgreSQL 11.18, compiled by Visual C++ build 1800, 64-bit" .

But if i'm looking into "C:\Program Files\Qlik\Sense\Repository\PostgreSQL" there is a folder "12.5"

Now i'm a little bit confused, why do i have a version in Qlik folder and another one on postgresql server? 

Since i'm not using 9.6, it is a must to upgrade PG version?

[Chetan_MN · Accepted solution]

Hi @Nicolae_Alecu Currently Postgres 9.6 is not supported. If you are upgrading Qlik Sense to Nov 2023, it supports below Postgres versions.

PostgreSQL:

• 14.x 

• 13.x

• 12.x

• 11.x

I would suggest you to have a proper backup of the environment and then proceed with Qlik Upgrade.

Perhaps if you have test environment, it would be good to try it there before moving it to Prod.

[Nicolae_Alecu]

Hi @Chetan_MN , 

As far as i understand, QlikSense - Nov 2023 version should work with PostgreSQL 11.18 as well, right?

[Chetan_MN]

Hi @Nicolae_Alecu Yes, 11.x versions are supported, meaning all the sub version under 11 are supported.
example: 11.18