topic Re: Two versions of PostgreSQL? in Management & Governance

Two versions of PostgreSQL?

user467341 — Wed, 26 Apr 2023 08:27:49 GMT

Hi. I have took over Qlik Sense from someone and recently when I want to do a backup to Qlik Sense, I discovered that there are two versions of PostgreSQL in the PostgreSQL folder - 9.6 and 12.5.

I am not sure which PostgreSQL is my Qlik Sense using. Is there a way to find out so I can do the backup to the correct PostgreSQL?

Thanks

Re: Two versions of PostgreSQL?

Alan_Slaughter — Wed, 26 Apr 2023 11:53:03 GMT

Hi if the services are running for both you could stop one to see if you can still access the QMC.

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

Re: Two versions of PostgreSQL?

user467341 — Thu, 27 Apr 2023 00:08:43 GMT

Hi Alan,

Thanks for sharing. I saw that I have a postgresql-x64-12 service running (while my Qlik Sense Repository Database (QSR) in service status shows "Blank").

When doing the backup (following https://help.qlik.com/en-US/sense-admin/February2023/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backing-up-a-site.htm), should I continue to backup this QSR? The QSR path to executable is pointing to PostgreSQL 9.6 pg_ctl.exe while the postgresql-x64-12 is pointing to PostgreSQL 12.5 pg_ctl.exe.

Re: Two versions of PostgreSQL?

Albert_Candelario — Sat, 29 Apr 2023 14:10:27 GMT

Hello @user467341 ,

I reckon this has been answered already here.

https://community.qlik.com/t5/Deployment-Management/Backup-question-on-Qlik-Sense-Repository-Database/td-p/2064650

Cheers,

Albert