topic Problem when upgrading PostgreSQL from 9.6 to 14.8 in Management & Governance

Problem when upgrading PostgreSQL from 9.6 to 14.8

prabin3 — Fri, 15 Nov 2024 20:55:30 GMT

We are using Qlik version May 2022 and wanted to upgrade to the new version of Qlik Sense May 2024.

During the update of PostgreSQL we encountered the following problems:

For the default location, we receive an error message that the user does not have write permissions for C:\Program Files\PostgreSQL\14. for every oder installation we used the same user and there has never been a similar issue.

By changing the path to C:\PostgreSQL\14 we were able to continue, but the backup failed.

All Qlik services were stopped, except for the Qlik sense repository database.

The user we used to install ProstgreSQL is an administrative user with permissions to write.

#ProstgreSQL

Re: Problem when upgrading PostgreSQL from 9.6 to 14.8

Alan_Slaughter — Mon, 12 Aug 2024 20:14:56 GMT

Hi Prabin3, maybe this will help:

1. https://community.qlik.com/t5/Official-Support-Articles/How-to-check-effective-permissions-on-a-file/ta-p/1715783

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

Re: Problem when upgrading PostgreSQL from 9.6 to 14.8

M_B — Wed, 21 Aug 2024 09:50:38 GMT

Are you using the QPI tool?

Right-click the installer, go to properties and check "unblock" and apply change. Next, try to run the installer as administrator. This might fix the issue of not being able to use the default path.