[Qlik Sense] Change user postgre database separate

Diane — Tue, 14 Feb 2023 15:50:01 GMT

Hello,
We have our postgre database on a separate server and we want to change the password of the qrsowner account which is the user of the database.
We have done the following actions:
- modification on password on the postgre database
- modification in the [InstallFolder]\Qlik\Sense\Repository\Repository.exe.config with the QlikSenseUtil.exe
- use of scripts :

cd "C:\Program Files\Qlik\Sense\AppDistributionService"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword

cd "C:\Program Files\Qlik\Sense\HybridDeploymentService"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword

cd "C:\Program Files\Qlik\Sense\Licenses"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword

but we still have the following error on the postgre base:

023-02-14 14:41:25 CET;6641;qsrowner;SenseServices;28P01;DETAIL: Password does not match for user "qsrowner".
Connection matched pg_hba.conf line 83: "host SenseServices qsrowner 0.0.0.0/0 md5"
2023-02-14 14:41:26 CET;6654;qsrowner;SenseServices;28P01;FATAL: password authentication failed for user "qsrowner"
2023-02-14 14:41:26 CET;6654;qsrowner;SenseServices;28P01;DETAIL: Password does not match for user "qsrowner".
Connection matched pg_hba.conf line 83: "host SenseServices qsrowner 0.0.0.0/0 md5"

so we tried to do the following script:

cd "C:\Program Files\Qlik\Sense\NotifierService\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword

cd "C:\Program Files\Qlik\Sense\MobilityRegistrarService\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword

cd "C:\Program Files\Qlik\Sense\PrecedentsService\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword

cd "C:\Program Files\Qlik\Sense\NLAppSearch\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword

cd "C:\Program Files\Qlik\Sense\NLBroker\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword

cd "C:\Program Files\Qlik\Sense\DataPrepService\install"
.\Configure-Service.ps1 localhost 4432 qliksenserepository YourPassword

I have the error when running the script:

Can you help me to know why I have an error on the postgre database and why I can't make the changes in the other databases.

Thanks in advanced

Re: [Qlik Sense] Change user postgre database separate

Alan_Slaughter — Tue, 14 Feb 2023 16:28:08 GMT

Hi Diane, depending upon certain versions it may not be available to change the password.

Please use this link to change your password:
https://community.qlik.com/t5/Official-Support-Articles/How-to-reset-forgotten-PostgreSQL-password-in-Qlik-Sense/ta-p/1712725

topic Re: [Qlik Sense] Change user postgre database separate in Management & Governance

[Qlik Sense] Change user postgre database separate

Re: [Qlik Sense] Change user postgre database separate