Two versions of PostgreSQL?

[user467341]

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

[Alan_Slaughter]

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-fro...

[user467341]

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_De...), 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.

[Albert_Candelario · Accepted solution]

Hello @user467341 ,

I reckon this has been answered already here.

https://community.qlik.com/t5/Deployment-Management/Backup-question-on-Qlik-Sense-Repository-Databas...

Cheers,

Albert