topic Re: Unbundle Qliksense repository database in Management & Governance

Unbundle Qliksense repository database

Sangeeta — Mon, 08 Jul 2024 14:10:25 GMT

Hello,

I have used QPI (Qliksense postgreSQL Installer) to unbundle and upgrade to prosgreSQL 14.8 for existing qliksense database. I'm currently setting up a new server and installed Qliksense enterprise on it, QS repository database (with postgreSQL 14.8) was included in the package and got installed.

I need to unbundle it so that the new system matches the existing systems. I tried using QPI but postgreSQL 14.8 version is already installed so it did not give me an option to only unbundle it. I realized I should have installed the database using QPI before installing Qliksense enterprise.

Please let me know if there is any way to only unbundle the database?

Re: Unbundle Qliksense repository database

mpc — Tue, 09 Jul 2024 07:00:17 GMT

Hi,

I think the easiest way to achieve this is to:

Stop all Qlik Sense Service except the Repository Database
Perform a backup: https://help.qlik.com/en-US/sense-admin/May2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backing-up-a-site.htm
Stop the Database Service
Follow this process: https://community.qlik.com/t5/Official-Support-Articles/How-to-configure-Qlik-Sense-to-use-a-dedicated-PostgreSQL/ta-p/1791775

Tada !

Kind regards

Re: Unbundle Qliksense repository database

Sangeeta — Mon, 15 Jul 2024 07:56:08 GMT

Thanks for the solution. I went through the documentation but as mentioned I cannot use QPI to unbundle because the database is already version 14.8, I checked if I can manually download it from postgreSQL website but the version available is 14.12. My goal is to have all my environments with same configuration so this will probably not serve my purpose.

Re: Unbundle Qliksense repository database

mpc — Mon, 15 Jul 2024 08:07:28 GMT

https://www.manageengine.com/products/desktop-central/software-installation/silent_install_PostgreSQL-14-(14.8).html You can find the 14.8 installer here

Re: Unbundle Qliksense repository database

Sangeeta — Tue, 16 Jul 2024 09:27:27 GMT

Thankyou. I will try this.

Re: Unbundle Qliksense repository database

Bo_PT — Wed, 12 Feb 2025 14:01:17 GMT

Hi, Sangeeta , did you make it work? We met the same situation.