Is it possible rotate the Qlik Sense PostgreSQL password?

[jrathgebercs]

Hi All,

We are installing Qlik Sense using a silent script and we are able to do it. Unfortunately, my organization does not permit the use of passwords that are known to either the developer or those who installed it. The password will be available at the center location and rotates every six or 12 months. If the password rotates on the center location, we are looking for a script to update the password for the PostgreSQL database.

Is there any script to update/reset the password for the Postgres database using command prompt or PowerShell?

This is super urgent if it is possible please share the script or suggest.?

Thank you.

[David_Friend]

@jrathgebercs yeah that is going to be tough to accomplish.  If anyone has potential scripts etc. please share them!

Have you split Postgres from QlikSense using QPI tool?  That may make this easier, not sure.

bookmark this:
https://community.qlik.com/t5/Official-Support-Articles/How-to-change-the-Qlik-Sense-Enterprise-on-W...

The connection strings have to be updated as it notes.

[jrathgebercs]

HI @David_Friend ,

Thank you for your response.

We are not using QPI tools to split the Postgres. Actually, we are looking for script which we can run on cmd prompt or PowerShell script to rotate the password.

We will pass the password variable using parameter at run time.

Thank you.

[Levi_Turner]

I'd describe it as semi-automated. Here's a guide I wrote for a customer many moons ago.

[jrathgebercs]

Hi @Levi_Turner ,

Thank you for sharing the details. Currently, I am trying to understand the details which you have shared.

I also went through below article and changed the password manually but after changes the password. I was unable to access QMC and hub.

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

Thank you .!!