topic Re: Postgres Superuser in Management & Governance

Postgres Superuser

barry_stevens — Wed, 31 Jan 2018 21:51:20 GMT

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

Re: Postgres Superuser

barry_stevens — Wed, 31 Jan 2018 22:04:37 GMT

That is the PostgreSQL superuser password.

Re: Postgres Superuser

Levi_Turner — Thu, 01 Feb 2018 00:47:38 GMT

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

Re: Postgres Superuser

barry_stevens — Thu, 01 Feb 2018 01:20:42 GMT

Shared...

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

Re: Postgres Superuser

Levi_Turner — Thu, 01 Feb 2018 07:45:55 GMT

Version?

Re: Postgres Superuser

barry_stevens — Thu, 01 Feb 2018 19:38:36 GMT

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

Re: Postgres Superuser

Levi_Turner — Thu, 01 Feb 2018 21:00:07 GMT

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.

Re: Postgres Superuser

barry_stevens — Fri, 02 Feb 2018 01:18:29 GMT

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