topic Re: Upgrading to August 2021 QSE on Windows - Repository Superuser PW Required? in Management & Governance

Upgrading to August 2021 QSE on Windows - Repository Superuser PW Required?

jbaechle — Mon, 15 Nov 2021 19:24:20 GMT

The August 2021 upgrade prompts for the repository database superuser password during install when a local repository database that was installed previously with QSE setup is detected (apparently for PostgreSQL upgrade purposes).

Does the August 2021 upgrade installer prompt for the repository database superuser password when QSE is configured to use a standalone PostgreSQL database for the repository?

Re: Upgrading to August 2021 QSE on Windows - Repository Superuser PW Required?

Sebastian_Linser — Mon, 15 Nov 2021 19:44:56 GMT

Hello @jbaechle

If you install with a standalone database from the start you don't get the prompt.

Since you started with the embedded and then moved to standalone it will check for two things

Qlik Repository database service
Folder c:\programdata\qlik\sense\repository\postgresql\9.6 or c:\programdata\qlik\sense\repository\postgresql\12.5

If you have the standalone DB rename the folder above to 9.6.old and run the installer again

More information here

https://community.qlik.com/t5/Knowledge/How-to-configure-Qlik-Sense-to-use-a-dedicated-PostgreSQL/ta-p/1791775

Best regards

Sebastian

Re: Upgrading to August 2021 QSE on Windows - Repository Superuser PW Required?

jbaechle — Mon, 15 Nov 2021 19:57:02 GMT

Thanks very much for the information. The initial install was done with a standalone PostgreSQL repository database so I should not expect the prompt when upgrading to August 2021. That has been the behavior I have come to expect. Qlik's online documentation for the upgrade process changed for August 2021 and states that you will be prompted for the repository superuser password. I just wanted to clarify.