Upgrade PostgreSQL to 14.8 - Password issue

sOnO — Thu, 14 Sep 2023 10:43:08 GMT

Hello experts!

I need to update my PostgreSQL 9.6 to 14.8 to upgrade my whole QlikSense installation to August 2023 version.

the QPI notes indicates that I need to update my password to avoid issue with special caracters (my case):
https://community.qlik.com/t5/Official-Support-Articles/Release-Notes-Qlik-Sense-PostgreSQL-installer-version-1-3-0-May/ta-p/2078236

QB-15164: Qlik PostgreSQL Installer not working when Postgres superuser password contains special characters.

I used the following procedure:
https://community.qlik.com/t5/Official-Support-Articles/How-to-reset-forgotten-PostgreSQL-password-in-Qlik-Sense/ta-p/1712725

but it says I need to update postgres and qliksenserepository with the the same password:

The passwords must be the same for both, when making changes.

QlikSense install process doen's force to have same password, so I'm confused if I should:

Update with same password only during PostgreSQL update, then I can put my former passwords back and go on with August 2023 release.
I must now consider that both passwords need to be identical for the future releases.

Your advices will be heavily appreciated

Regards

Sylvain

Re: Upgrade PostgreSQL to 14.8 - Password issue

John_Sathya — Wed, 20 Sep 2023 14:18:17 GMT

@sOnO ,

While using the QPI tool this is a limitation that you can't use specail charachters in the super Admin password and having same Password for the users.

As you said this can be changed once you complete the upgrade so that shouldn't be an issue. If you anyway planning on upgrade you can easily take a backup of the Database, Unistall Qlik Sense, Install Latest version of Qlik Sense (Comes bundled with lates postgres version) then restore the Database.

topic Re: Upgrade PostgreSQL to 14.8 - Password issue in Management & Governance

Upgrade PostgreSQL to 14.8 - Password issue

Re: Upgrade PostgreSQL to 14.8 - Password issue