Azure options / database config

[jannikbuschke]

hi there,

Im currently migrating an EF core based app to marten and am doing the first steps to test in azure with PostgresFlexible server.

After some initial hickups the app is usable for some time, but after adding some events to the event store I usually get the following error:

Npgsql.PostgresException (0x80004005): 53300: remaining connection slots are reserved for non-replication superuser connections
at Npgsql.Internal.NpgsqlConnector.g__ReadMessageLong|213_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
at Npgsql.Internal.NpgsqlConnector.g__OpenCore|193_1(NpgsqlConnector conn, SslMode sslMode, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
at Npgsql.Internal.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
at Npgsql.ConnectorPool.OpenNewConnector(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
at Npgsql.ConnectorPool.g__RentAsync|27_0(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
at Npgsql.NpgsqlConnection.g__OpenAsync|45_0(Boolean async, CancellationToken cancellationToken)
at Marten.Services.AutoOpenSingleQueryRunner.Query[T](ISingleQueryHandler`1 handler, CancellationToken cancellation)
at Marten.Events.Daemon.HighWater.HighWaterDetector.loadCurrentStatistics(CancellationToken token)
at Marten.Events.Daemon.HighWater.HighWaterDetector.Detect(CancellationToken token)
at Marten.Events.Daemon.HighWater.HighWaterAgent.DetectChanges()
Exception data:
Severity: FATAL
SqlState: 53300
MessageText: remaining connection slots are reserved for non-replication superuser connections
File: postinit.c
Line: 832
Routine: InitPostgres

I assume my code either does not properly dispose connections or the azure database is not properly configured. Any hints on what to look at is highly appreciated