This content has been marked as final. Show 2 replies
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
Connect to the server using the following settings:
Tablesand double click on the table
If you want to see the existing RootAdmins execute the following filter
"RolesString" = 'RootAdmin'
"UserId" = `swr`
Then just add
RootAdmin to the