Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.
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
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:
If you want to see the existing RootAdmins execute the following filter
"RolesString" = 'RootAdmin'
"UserId" = `swr`
Then just add RootAdmin to the RolesString column.
Postgres 9.6 doesnt come with PgAdmin tool by default. You might want to download it and then configure your postgres database.
I managed to complete this by downloading pgAdmin4.
Documented here should anyone require:
Restoring RootAdmin role on QS July / PostgreSQL 9.6 after Server Name change