Automate Changing of Postgres Passwords

AndyBurnsJPM — Fri, 03 May 2024 09:05:16 GMT

In the following link

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

we see instructions on how that password can be amended manually. However, if we wanted to automated this, would it be possible? More specifically, I am enquiring about this part within the QlikSenseUtil. Is it possible to do the same think via cmd line?

"Adjust the connection string using QlikSenseUtil Open QlikSenseUtil (C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil) Open the Connection String Editor tab Click Read Adjust the password Click Save Value in config file encrypted "

When we install qlik sense we're asked for a dbpassword parameter. Within the sharedpersistenceconfig we're also asked for a DbUserPassword. Are these both separate users in the database or how are they used? I did see this mentioned in the article:

postgre: the super user

qliksenserepository: the service user; if the database was installed manually or set up with QPI, this may be the only user set up

The passwords must be the same for both. "

topic Automate Changing of Postgres Passwords in Management & Governance

Automate Changing of Postgres Passwords