Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

barry_stevens
Contributor II

Postgres Superuser

Hi All,

I have a Qlik instance where I don't know the superuser password, I am aware there are plenty of discussions around how to reset the superuser password, what I would like to know is the Superuser (not the Qlik Repository User) password stored or used anywhere in Qlik ie if I change it will I need to change in Qlik somewhere?

Cheers

Barry

1 Solution

Accepted Solutions
Employee
Employee

Re: Postgres Superuser

No worries. If you happen to be using the postgres user for connections from the Repository service to the database you should be able to tell using the ConnectionStringEditor  (default location: C:\Program Files\Qlik\Sense\Repository\Util\ConnectionStringEditor\ConnectionStringEditor.exe ) to inspect the underlying connection string. If the user is postgres, then you'd want to update the password (generally need to run as admin to write to %ProgramFiles%). If it's qliksenserepository, then this change should not affect Qlik Sense.

7 Replies
barry_stevens
Contributor II

Re: Postgres Superuser

That is the PostgreSQL superuser password.

Employee
Employee

Re: Postgres Superuser

Whether it's used depends on what has been configured. Are you on Shared or Sync persistence? Version?

barry_stevens
Contributor II

Re: Postgres Superuser

Shared...

Thanks for the attachment too, I'll give this ago in the next day or so...

Employee
Employee

Re: Postgres Superuser

Version?

barry_stevens
Contributor II

Re: Postgres Superuser

doh, miss-read your last response, read as "Shared or sync persistence version?"

Version is 3.2 SR1, yes we know we need to upgrade it, hence trying to make sure we have the correct password

Employee
Employee

Re: Postgres Superuser

No worries. If you happen to be using the postgres user for connections from the Repository service to the database you should be able to tell using the ConnectionStringEditor  (default location: C:\Program Files\Qlik\Sense\Repository\Util\ConnectionStringEditor\ConnectionStringEditor.exe ) to inspect the underlying connection string. If the user is postgres, then you'd want to update the password (generally need to run as admin to write to %ProgramFiles%). If it's qliksenserepository, then this change should not affect Qlik Sense.

barry_stevens
Contributor II

Re: Postgres Superuser

Thanks, Looks like it is using the qliksenserepository user...

Community Browser