idea EGDB Postgres Azure Flexible Server - SuperUser privileges in ArcGIS Enterprise Ideas https://community.esri.com/t5/arcgis-enterprise-ideas/egdb-postgres-azure-flexible-server-superuser/idi-p/1543711 <P>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 <A href="https://community.esri.com/t5/arcgis-enterprise-ideas/non-superuser-sde-database-user-on-postgresql/idi-p/1158952" target="_self">post</A> where an issue is described that on flexible server no SuperUser rights will be available anymore.&nbsp;</P><P>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.</P><P>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.</P><P>Has anyone else experienced any limitations using Postgres Azure flexible Server&nbsp; and running an Enterprise Geodatabase?</P> Mon, 30 Sep 2024 07:01:28 GMT Bernd_Loigge 2024-09-30T07:01:28Z EGDB Postgres Azure Flexible Server - SuperUser privileges https://community.esri.com/t5/arcgis-enterprise-ideas/egdb-postgres-azure-flexible-server-superuser/idi-p/1543711 <P>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 <A href="https://community.esri.com/t5/arcgis-enterprise-ideas/non-superuser-sde-database-user-on-postgresql/idi-p/1158952" target="_self">post</A> where an issue is described that on flexible server no SuperUser rights will be available anymore.&nbsp;</P><P>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.</P><P>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.</P><P>Has anyone else experienced any limitations using Postgres Azure flexible Server&nbsp; and running an Enterprise Geodatabase?</P> Mon, 30 Sep 2024 07:01:28 GMT https://community.esri.com/t5/arcgis-enterprise-ideas/egdb-postgres-azure-flexible-server-superuser/idi-p/1543711 Bernd_Loigge 2024-09-30T07:01:28Z