2 Replies Latest reply: Sep 29, 2017 5:03 AM by Carmelle Morrison RSS

    Restoring Root Admin on QS with PostGreSQL 9.6

    Carmelle Morrison

      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

      2. Open pgAdmin tool**

      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:

      3) Open the Users table

      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' 

      4) Make a user RootAdmin

      • Search for a specific user, the easiest way is again to add a filter:
      "UserId" = `swr` 

      Then just add RootAdmin to the RolesString column.

      5) Restart the repository service