Select to view content in your preferred language

EGDB Postgres Azure Flexible Server - SuperUser privileges

61
1
6 hours ago
Labels (1)
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?

1 Reply
Geoeki
by
Regular Contributor

I would also like to know this as we're planning upgrading to ArcGIS Enterprise 11.3! According to this help ressource, from ArcGIS Enterprise 11.2 onwards Microsoft Azure Database for PostgreSQL Flexible Server should be supported. Can someone confirm that he/she hasn't run into issues when the SDE user doesn't have superuser privilages anymore?

0 Kudos