topic Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working in Management & Governance

Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

Srikanth_Shankupuram — Wed, 24 Aug 2022 07:57:30 GMT

Hi,

I am following one of the post for upgrading Postgres 9.6 to 12.5 for scheduler server as given below.
Upgrading Qlik Sense Repository Database from Post... - Qlik Community - 1934238

I installed the QPI setup and ran it according to the steps provided in the community post above on the test scheduler server and the setup showed "Not Applicable".

Server details:

QlikSense May 2021 Patch 16

qliksenseserver: 14.20.25

Please help in providing QPI tool or guidance in order to upgrade Postgres 9.6 to 12.5

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

rzenere_avvale — Wed, 24 Aug 2022 08:00:19 GMT

Hey there @Srikanth_Shankupuram ,

Just a clarification: since you are talking about 'scheduler' node, are you in a multi-node environment? Or is your environment composed of a single node?

Riccardo

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

Srikanth_Shankupuram — Wed, 24 Aug 2022 08:03:22 GMT

Hi,

Its a multinode environment.

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

Benoit_C — Wed, 24 Aug 2022 08:12:07 GMT

Hello @Srikanth_Shankupuram,

Where is installed your postgres Database ?

Is it a standalone Postgres database or the bundled PostgreSQL database ?

Regards,

Benoit

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

Srikanth_Shankupuram — Wed, 24 Aug 2022 08:13:28 GMT

So basically I'm doing an activity wherein I'm installing QlikSense May 2021 on new server and taking backup of the old server.

Since the old server has Postgres 9.6, while taking backup of QSRbackup.tar and replacing it on new server.
There is a pg_restore error on the command prompt, since the new version has Postgres 12.5 on it.

Hence, I'll have to upgrade Postgres9.6 to 12.5 on the old server and then take backup of QSRbackup.tar and replace it on the new server.

I hope you got my problem area.

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

rzenere_avvale — Wed, 24 Aug 2022 08:15:17 GMT

The repository is installed only on one node (by default on the central node, but that could change based on your requirements), so on all nodes that are not the one where it is installed the repository, the tool will give you error

Also, note that officially the tool supports Qlik Sense from release February 2022 (so it could work with May 2021, but...)

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

Srikanth_Shankupuram — Wed, 24 Aug 2022 08:18:53 GMT

Hi Benoit_C,

Postgres 9.6 is installed as part of Qlik install and we have Postgres and Qlik on same machine.

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

Srikanth_Shankupuram — Wed, 24 Aug 2022 08:30:40 GMT

Hi Rzenere_techedge,

Is there any available solution to upgrade Postgres 9.6 to 12.5 for May 2021 release

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

rzenere_avvale — Wed, 24 Aug 2022 08:36:30 GMT

Personally I used to follow this kb article: Qlik Sense May 2021 - Upgrade bundled PostgreSQL to 12.5 version
Is re-installation of QS on the central node of the old environment a viable solution for you?

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

Benoit_C — Wed, 24 Aug 2022 08:40:03 GMT

Hello @Srikanth_Shankupuram,

With this tool you will need to be in a supported version (Feb 2022).

So you would need to upgrade to Feb 2022 and then you would be able to migrate postgres version.

If you do not want to proceed like that, the only solution we could propose is the below:

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

Regards,

Benoit

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

Srikanth_Shankupuram — Wed, 24 Aug 2022 10:00:31 GMT

Hi Benoit,

Will reinstallation as per the link, retain all the settings belong to the central and rim nodes?

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

Benoit_C — Wed, 24 Aug 2022 11:06:49 GMT

Hello @Srikanth_Shankupuram,

Yes it should keep all your setting from your DB backup.

But as stated in the article:

This process requires a full reinstallation of the product. Despite the fact that a backup is being taken as part of the process, it is highly recommended to have a second backup plan in place such as a Virtual Machine snapshot and/or a Server Backup.
It is highly recommended to test this process in a test environment to get familiar with it.

Regards,

Benoit

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

Srikanth_Shankupuram — Wed, 24 Aug 2022 11:27:45 GMT

Thanks Benoit_C for your help and suggestions.

Re: Upgrading Qlik Sense Repository Database from PostgreSQL 9.6 to 12.5 not working

Benoit_C — Wed, 24 Aug 2022 13:04:05 GMT

You are welcome, I'm glad it was helpful.