Today, we had some issues with applications not being able to connect an Azure Database for PostgreSQL instance. The error was:
53300: remaining connection slots are reserved for non-replication superuser connections
I understand there are connection count limits (see: https://learn.microsoft.com/en-us/azure/postgresql/concepts-limits). However, how is an administrator expected to be able to perform problem diagnosis (ex: check for misbehaving applications) if they cannot login without access to the
The PostgreSQL superuser attribute is assigned to the azure_superuser, which belongs to the managed service. You do not have access to this role.