topic Re: Upgrading QSR postgres Db to Version 11 from 9.6 for Nov 2019 version in Management & Governance

Upgrading QSR postgres Db to Version 11 from 9.6 for Nov 2019 version

Karthik3 — Tue, 08 Jun 2021 17:39:17 GMT

We have Qlik sense enterprise with version Nov 2019. Postgres 9.6 is installed as part of qlik install and we have postgres and Qlik on same machine. Now 9.6 postgres is outdated and we need to upgrade to version 11 which is supported.

Do anyone have detailed steps on how to upgrade local install of postgres from ver 9.6 to Ver 11?

Re: Upgrading QSR postgres Db to Version 11 from 9.6 for Nov 2019 version

PadmaPriya — Fri, 11 Jun 2021 23:52:07 GMT

Hello @Karthik3

Thanks for posting your query.

Please refer to below article:

How To Upgrade Standalone PostgreSQL

System requirements for Qlik Sense Enterprise

Thanks,

Padma Priya

Re: Upgrading QSR postgres Db to Version 11 from 9.6 for Nov 2019 version

Karthik3 — Sat, 12 Jun 2021 00:09:02 GMT

Thanks. But this is not what I require.

We want to upgrade Postgres, one which gets installed by qlik during install. We don’t have a separate instance of Postgres.

since Postgres 9.6 is EOVS qlik has to give a bundle of Nov 2020 version which has 11 version of Postgres. Currently it is still 9.6

Re: Upgrading QSR postgres Db to Version 11 from 9.6 for Nov 2019 version

PadmaPriya — Sat, 12 Jun 2021 00:13:19 GMT

Hello Karthik,

You may download from postgresql website as well:

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

All you need to do is please take full backup of Qlik Sense and Database.

Thanks,

Padma Priya

Qlik Support

Re: Upgrading QSR postgres Db to Version 11 from 9.6 for Nov 2019 version

Karthik3 — Sat, 12 Jun 2021 00:19:13 GMT

But this will just install a new instance of Postgres on the server I believe. Currently I don’t see any Postgres under control panel>programs

Re: Upgrading QSR postgres Db to Version 11 from 9.6 for Nov 2019 version

PadmaPriya — Sat, 12 Jun 2021 00:36:00 GMT

Hello @Karthik3

Please look at the prework in below mentioned article:

https://community.qlik.com/t5/Knowledge-Base/Qlik-Sense-Enterprise-on-Windows-How-To-Upgrade-Standalone/ta-p/1712361

Thanks,

Padma Priya