Upgrade remote Repository PostgreSQL previous QS Upgrade

Gestion-PSD — Mon, 11 Apr 2022 09:36:04 GMT

Hi all,

We're working on update QS from september 2020 to the newest version, but we've doubts about how to deal with Repository PostgreSQL update (from 9.6 to 12.x).

Our Repository Postgres is installed on a remote server, so the QS Installation automatic postgres upgrade won't work for us.

We need to know the best way to upgrade Postgres before start our QS upgrade protocols.

Our first approach would be:

Install Postgres 12.x in Repository server without external access
Replicate databases structure from 9.6 to 12.x
Stop QS services in all QS nodes
"copy" databases from 9.6 to 12.x
deactivate access to 9.6 and activate access to 12.x
Start QS upgrade on primary node
At finish, start QS upgrade on secondary nodes

Is that approach accurate? or it's better to upgrade QS without Postgres 9.6 upgrade and upgrade it before QS upgrade (step 4&5 after step 7)?

Best regards,

Alonso Torres

Re: Upgrade remote Repository PostgreSQL previous QS Upgrade

Chip_Matejowsky — Mon, 11 Apr 2022 12:02:02 GMT

Hi @Gestion-PSD,

Have a look at Qlik Support article Qlik Sense Enterprise on Windows: How To Upgrade Standalone PostgreSQL as I believe it covers the scenario you are inquiring about.

Best Regards

Re: Upgrade remote Repository PostgreSQL previous QS Upgrade

Gestion-PSD — Mon, 11 Apr 2022 13:17:29 GMT

Thank Chip.

It's exaclty what we're looking for.

topic Re: Upgrade remote Repository PostgreSQL previous QS Upgrade in Management & Governance

Upgrade remote Repository PostgreSQL previous QS Upgrade

Re: Upgrade remote Repository PostgreSQL previous QS Upgrade

Re: Upgrade remote Repository PostgreSQL previous QS Upgrade