Restoring Root Admin on QS with PostGreSQL 9.6

cmorri1988 — Thu, 28 Sep 2017 16:24:56 GMT

Hi there,

We had to change our server name today and as a result, I have lost root admin access for my login.

Please can someone talk me through how I would do this.

I have found instructions on earlier versions of PostgreSQL below, but not 9.6

Thanks!

--------------

1. Use Remote desktop to connect to the server

One the server you'll find the pgAdmin tool located under
\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin\pgAdmin3.exe

Connect to the server using the following settings:

Go to

Databases > QSR > Schemas > public > Tables and double click on the table Users
right click on "View Data" > "View All Rows"

If you want to see the existing RootAdmins execute the following filter

"RolesString" = 'RootAdmin'

"UserId" = `swr`

Then just add RootAdmin to the RolesString column.

Re: Restoring Root Admin on QS with PostGreSQL 9.6

jaisoni_trp — Thu, 28 Sep 2017 16:52:45 GMT

Postgres 9.6 doesnt come with PgAdmin tool by default. You might want to download it and then configure your postgres database.

cmorri1988 — Fri, 29 Sep 2017 09:03:31 GMT

Thanks,

I managed to complete this by downloading pgAdmin4.

Documented here should anyone require: