EGDB Postgres Azure Flexible Server - SuperUser privileges

54
0
6 hours ago
Status: Open
Bernd_Loigge
Occasional Contributor

We are currently in the process of moving our Enterprise Postgres Single Server Geodatabase to Postgres Flexible Server as Single Server will retire soon. We found an older blog post where an issue is described that on flexible server no SuperUser rights will be available anymore. 

So far with adopting a few things we managed to test the migration using Azure functionality on our staging system and we were able to migrate roles, permissions and data tables. A clone of the DB was created.

But we are unsure if there will be other limitations in the future using flexible server where the SDE user will not have SuperUser privileges.

Has anyone else experienced any limitations using Postgres Azure flexible Server  and running an Enterprise Geodatabase?