topic Re: Qliksense and Postgres Upgrade in Management & Governance

Qliksense and Postgres Upgrade

sai_nemani — Thu, 13 Mar 2025 06:36:47 GMT

Hi All

Need your guidance here!!

As of now we are in Qliksense Feb2022 version and postgress is 9 version. Now i have to upgrade Qliksense as well as postgress. Below are my questions

1. Can we upgrade postgres from 9 to 14 version. If yes is there any technotes for this?

2. Currently postgres is installed with qliksense. Now we need to separate the postgres from Qliksense? Is there any technotes available?

Thanks

Saikrishna Nemani

Re: Qliksense and Postgres Upgrade

AshutoshBhumkar — Thu, 13 Mar 2025 07:01:07 GMT

Hi,

You can take notes from.

https://help.qlik.com/en-US/sense-admin/November2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/upgrade_qlikSense/upgrade_QSEoW_planning.htm

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

Are you planning for a standalone postgres installation ?

Re: Qliksense and Postgres Upgrade

diegozecchini — Thu, 13 Mar 2025 07:03:55 GMT

Hi!
Yes, you can upgrade PostgreSQL from version 9.6 to 14.8. Qlik provides the Qlik PostgreSQL Installer (QPI) to facilitate this process. The QPI not only upgrades PostgreSQL but also decouples it from the Qlik Sense installation, allowing for independent maintenance.
And yes, separating PostgreSQL from the Qlik Sense installation is advisable for better management and flexibility. This process involves configuring Qlik Sense to use a dedicated, standalone PostgreSQL instance, which can be hosted on a different server.

Before proceeding, back up your Qlik Sense site, including databases, applications, and certificates.

Here some technote I suggest:

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

https://community.qlik.com/t5/Official-Support-Articles/How-to-configure-Qlik-Sense-to-use-a-dedicated-PostgreSQL/ta-p/1791775

Re: Qliksense and Postgres Upgrade

Dana_Baldwin — Thu, 13 Mar 2025 15:53:17 GMT

Hi @sai_nemani

Please note the forum you have posted to is for the Data Integration product Enterprise Manager, used for managing multiple Replicate/Compose/Catalog servers. To reach your target audience, please consider posting your question here: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense

Thanks,

Dana