Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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...