Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
AndyBurnsJPM
Contributor II
Contributor II

Automate Changing of Postgres Passwords

In the following link

https://community.qlik.com/t5/Official-Support-Articles/How-to-reset-forgotten-PostgreSQL-password-i...

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

Labels (3)
0 Replies