topic Re: Upgrading Qlik Sense Repository from 9.6 to 11.5 in Management & Governance

Upgrading Qlik Sense Repository from 9.6 to 11.5

reycarloluber — Sat, 16 Nov 2024 04:27:42 GMT

Hi,

I would like to ask if it is possible to upgrade the postgresql repository of Qlik Sense (version Feb 2019) from 9.6 to 11.5.

It says here that there are vulnerabilities in the current version that can be resolved by upgrading the version of postgresql: https://www.cvedetails.com/vulnerability-list/vendor_id-336/product_id-575/Postgresql-Postgresql.html

If it's possible to upgrade the postgresql repository, are there any drawbacks of upgrading? Are there any pre-requisite? Are there things that I should know about? We currently have a multi-node setup (1 central, 2 rim nodes), are there any configurations that I need to do on all nodes?

Sincerely,
Rey

Re: Upgrading Qlik Sense Repository from 9.6 to 11.5

NadiaB — Mon, 07 Oct 2019 20:16:36 GMT

Hi @reycarloluber

The requirement for that version is PostgreSQL 9.6

https://help.qlik.com/en-US/sense/February2019/Subsystems/PlanningQlikSenseDeployments/Content/Sense_Deployment/Introduction/system-requirements.htm

Kind regards.

Re: Upgrading Qlik Sense Repository from 9.6 to 11.5

reycarloluber — Tue, 08 Oct 2019 03:22:56 GMT

Hi Nadia,

Thanks for the reply!

9.6 already came upon installation. What I would like to know is if upgrading is possible or if it'd have any impact in the on-going environment. Any pre requisite or things to note are also highly appreciated.

Sincerely,
Rey

Re: Upgrading Qlik Sense Repository from 9.6 to 11.5

premvihari — Tue, 08 Oct 2019 03:56:09 GMT

Hi,

We can upgrade to newer version and below will help how to do

https://help.qlik.com/en-US/sense/June2019/Subsystems/PlanningQlikSenseDeployments/Content/Sense_Deployment/Backing-up-a-site.htm

https://help.qlik.com/en-US/sense/June2019/Subsystems/PlanningQlikSenseDeployments/Content/Sense_Deployment/Installing-configuring-postgresql.htm

https://help.qlik.com/en-US/sense/June2019/Subsystems/PlanningQlikSenseDeployments/Content/Sense_Deployment/Restoring-a-site.htm

Re: Upgrading Qlik Sense Repository from 9.6 to 11.5

NadiaB — Tue, 08 Oct 2019 14:39:21 GMT

Hi @premvihari

If you upgrade and after that there is a problem, as the version is not listed in the requirements it won't be a supported installation.

Kind regards.

Re: Upgrading Qlik Sense Repository from 9.6 to 11.5

reycarloluber — Wed, 09 Oct 2019 10:55:46 GMT

Hi @NadiaB

Can you please elaborate what you meant by it not being a supported installation? I followed the guides posted by @premvihari and was able to replace (not upgrade) the postgresql from 9.6 to 11.5 and everything is working as is.

Sincerely,

Rey

Re: Upgrading Qlik Sense Repository from 9.6 to 11.5

NadiaB — Wed, 09 Oct 2019 12:44:55 GMT

Hi @premvihari

Please refer to the Support Policy , 4. Error Resolution and Escalation, 4.2 section.

It is necessary to verify your system meets the Requirements listed in the documentation.

Kind Regards.

Re: Upgrading Qlik Sense Repository from 9.6 to 11.5

reycarloluber — Thu, 10 Oct 2019 09:40:39 GMT

Hi @NadiaB ,

Thank you for the reply. If we downgrade back to 9.6, will it be covered by the support again? And also, are all patches of 9.6 covered by the support? We are planning to downgrade back to 9.6.15.

I am not sure if only 9.6.6 is covered. We need at least 9.6.10 to address the vulnerability issues.

Sincerely,

Rey

Re: Upgrading Qlik Sense Repository from 9.6 to 11.5

NadiaB — Thu, 10 Oct 2019 12:43:02 GMT

Hi @reycarloluber

Have you had the chance to look at the documentation? It is mentioned that is required PostgreSQL 9.6.x versions

https://help.qlik.com/en-US/sense/February2019/Subsystems/PlanningQlikSenseDeployments/Content/Sense_Deployment/Introduction/system-requirements.htm?_ga=2.266283023.1268433984.1570462634-1282308485.1568833519

Kind Regards.

Re: Upgrading Qlik Sense Repository from 9.6 to 11.5

Levi_Turner — Mon, 14 Oct 2019 20:21:08 GMT

Qlik Sense Enterprise (as of October 2019) only supported PostgreSQL 9.6.x. There are active plans to support higher versions of PostgreSQL and the goal is to include this into Qlik Sense November 2019, although that is not a commit that it will make it into November 2019. Practically this is planned to be support of a remote PostgreSQL site with 11.x initially with later releases supporting upgrading the bundled PostgreSQL which comes with Qlik Sense Enterprise. Please check the system requirements page on help as releases are released to see when this change is made.

Re: Upgrading Qlik Sense Repository from 9.6 to 11.5

reycarloluber — Tue, 15 Oct 2019 04:05:43 GMT

Thank you all for the replies! We decided to downgrade the repository back to 9.6.15.