Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Diane
Partner - Contributor III
Partner - Contributor III

[Qlik Sense] Change user postgre database separate

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:

Diane_0-1676389742457.png

 

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

Labels (1)
1 Reply
Alan_Slaughter
Support
Support

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