topic Re: Restore QS Windows Enterprise & keep PostGres Version in Management & Governance

Restore QS Windows Enterprise & keep PostGres Version

pauljohansson — Wed, 01 Feb 2023 11:00:55 GMT

Hi,

Im running QlikSense Windows EnterPrise 2022 MaySR4. I've created a full backup of the system.

Now I want to restore my Backup on another machine(with the same hostname), following instructions - https://help.qlik.com/en-US/sense-admin/May2022/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Restoring-a-site.htm

When Im installing QlikSense 2022 May on the new Machine I automaticaly get PostGres 12.5. However, my backed up version is running PostGreSQL9.6.

-> How should I be able to restore my environment without changing the PostSQL Version during the restore?

Thanks in advance,
Paul

Re: Restore QS Windows Enterprise & keep PostGres Version

Ray_Strother — Wed, 01 Feb 2023 16:24:55 GMT

Hello ,
The bet method would be to upgrade the postgres on the original machine first and then restore to the new machine. The instructions are below.

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

Re: Restore QS Windows Enterprise & keep PostGres Version

Ray_Strother — Wed, 01 Feb 2023 17:48:22 GMT

Hello ,

If you chose to restore in the current state, you will get one warning doing so about schema public already exist that can be ignored. Meaning the backup from a 9.6 postgres to a 12.5 Postgres Qlik Sense install.

Re: Restore QS Windows Enterprise & keep PostGres Version

pauljohansson — Thu, 02 Feb 2023 09:29:58 GMT

Hej @Ray_Strother

Thanks for the quick reply. The idea with the exercise is to verify the PostGres upgrade in a test environment before proceeding in the Production environment. Hence, I need to be able to restore my current Prod to a working Test environment. I'm not able to find any documention on how to do this, which is quite suprising.

Paul

Re: Restore QS Windows Enterprise & keep PostGres Version

Ray_Strother — Thu, 02 Feb 2023 16:29:33 GMT

Hello ,

You can use the process in the help site link below., we use this process to restore customers databases to our lab machines. Hopefully this answers your question.

https://help.qlik.com/en-US/sense-admin/November2022/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Restoring-a-site.htm

Restoring a Qlik Sense site to a machine with a different hostname (section)

Re: Restore QS Windows Enterprise & keep PostGres Version

pauljohansson — Fri, 10 Feb 2023 08:42:26 GMT

Hi @Ray_Strother

These guide lines does not work since they assume that the PostGres version is the same. I want to restore QS May2022 with PostGres9.6.

When I install a fresh QS May2022 I automatically get PostGres12.6

Are there any instructions on how to restore restore QS May2022?

thanks in advance

Re: Restore QS Windows Enterprise & keep PostGres Version

Giovanni_Civardi — Fri, 10 Feb 2023 08:48:17 GMT

Hi @pauljohansson , I think you can perform a fresh install of a pre-may2021 version to have the postgres on 9.6. Then upgrade to May2022 and perfom a restore to a machine with different hostname.

After all the post-upgrade checks, I suggest to upgrade Postgres to 12.5 for full compatibility/support with version post-May2022 (Nov2022 requires postgres 12.5).

Best,