topic Re: Qliksense Aug2022 Upgrade in Management & Governance

Qliksense Aug2022 Upgrade

jpjust — Mon, 17 Oct 2022 12:34:50 GMT

Hello All,

We have upgraded Qliksense enterprise from Nov 2021 to Aug 2022 version.

We have central node and couple of RIM node. Postgres database is on a different dedicated server running 9.6.10.

During the qliksense upgrade, the upgrade wizard did not ask to upgrade Postgres to newer version but the Qliksense upgrade completed successfully and there are no issues accessing hub, running reload tasks etc.,

Is this fine or Postgres must be upgraded?

Thanks

Re: Qliksense Aug2022 Upgrade

Alan_Slaughter — Mon, 17 Oct 2022 12:53:38 GMT

Hi Jpjust, Databases are not automatically upgraded.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-May-2021-Upgrade-bundled-PostgreSQL-to-12-5-version/ta-p/1820358

https://community.qlik.com/t5/Official-Support-Articles/Upgrading-Qlik-Sense-Repository-Database-from-PostgreSQL-9-6-to/ta-p/1934238

Re: Qliksense Aug2022 Upgrade

jpjust — Mon, 17 Oct 2022 14:05:34 GMT

Thank you Alen, the links are helpful

We have Postgres on Linux server. Do you have instruction link to upgrade Postgres on Linux?

Thanks

Re: Qliksense Aug2022 Upgrade

Alan_Slaughter — Mon, 17 Oct 2022 14:16:43 GMT

Sorry, no support for Linux.

https://help.qlik.com/en-US/sense-admin/August2022/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Installing-configuring-postgresql.htm

Re: Qliksense Aug2022 Upgrade

jpjust — Mon, 17 Oct 2022 16:10:31 GMT

Thanks Alan for confirming. Like you mentioned there is no clear direction to upgrade Postgres from 9.6 to 12.5 on Linux.

So in that case we download the Postgres 12.5. Stop all Qlik services except the Qlik repository database service, upgrade the Postgres database and restart all the services.

Does this step generally sounds OK?

Thanks

Re: Qliksense Aug2022 Upgrade

Alan_Slaughter — Mon, 17 Oct 2022 16:40:05 GMT

Yes, that sounds like the best way to go. I would also recommend going to the Postgres community and seeing how they recommend upgrading Postgres on Linux. We only support Windows.

Re: Qliksense Aug2022 Upgrade

jpjust — Mon, 17 Oct 2022 16:59:08 GMT

Thanks Alan.

Do you think it is better to upgrade to 12.5 instead of continue using 9.6.

Do you have few compelling reasons for upgrade as I have to convince my Database team here.

I guess #1 would be 9.6 version is out of support from Qlik

Thanks

Re: Qliksense Aug2022 Upgrade

Alan_Slaughter — Mon, 17 Oct 2022 18:05:21 GMT

Yes 9.6 has been archived by Postgres

https://www.postgresql.org/support/versioning/