topic Re: Upgrading Qlik Sense: What Happens if PostgreSQL Service is Down? in Management & Governance

Upgrading Qlik Sense: What Happens if PostgreSQL Service is Down?

Farshad_Razor — Wed, 09 Oct 2024 07:10:13 GMT

Hello Qlikkies,

What happens if you attempt to upgrade Qlik Sense Client-Managed while using an unbundled PostgreSQL 14, but the PostgreSQL service isn't running?

Does the upgrade fail? Does Qlik Sense get deleted and not reinstalled? Will it finish successfully?

Best regards,
Farshad

Re: Upgrading Qlik Sense: What Happens if PostgreSQL Service is Down?

surajmaraje_HSBC — Wed, 09 Oct 2024 09:43:53 GMT

Hi @Farshad_Razor

Are you using dedicated PostgreSQL for your Qlik Sense setup?

Re: Upgrading Qlik Sense: What Happens if PostgreSQL Service is Down?

Farshad_Razor — Wed, 09 Oct 2024 11:44:57 GMT

Hi,

The PostgreSQL is one that has been upgraded with the QPI to 14.8. So the PostgreSQL is only used for Qlik.

Re: Upgrading Qlik Sense: What Happens if PostgreSQL Service is Down?

surajmaraje_HSBC — Wed, 09 Oct 2024 12:01:16 GMT

Hi @Farshad_Razor

There are two type of configurations for PostgreSQL with Qlik Sense. One comes bundled with Qlik Sense and another you can install as standalone PostgreSQL database ad same can be used as repository database in Qlik Sense.

If you are using bundled and planning to upgrade to 14.8 using Qlik Postgres Installer, then yes you need to keep Qlik Sense Repository Database service running.

You can refer to below article which explains how you can use QPI to upgrade Postgres.

https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238

If your PostgreSQL is standalone and you are planning to upgrade to 14.8, then this is different process. You can not use QPI to upgrade standalone Postgres.

I hope this helps you.

Re: Upgrading Qlik Sense: What Happens if PostgreSQL Service is Down?

mpc — Wed, 09 Oct 2024 12:07:01 GMT

hi,

AFAIK, it will fail and rollback, like a bundle Repository Database.

Regards