@Marvin I'm running a prefect server with version 2.14.4 and seeing jobs crashing with these errors in the server logs:

asyncpg.exceptions.TooManyConnectionsError: remaining connection slots are reserved for non-replication superuser connections

How can I resolve and is there a way to increase the max connection pool?

The error you're encountering,

asyncpg.exceptions.TooManyConnectionsError

, typically occurs when the database connection limit is exceeded. This is common in environments using PostgreSQL. You can address this issue by altering the database configuration to allow more connections or by optimizing how connections are used. To resolve this issue with Prefect 2.x, consider the following options: 1. Increase PostgreSQL Connection Limit: - You can modify the PostgreSQL configuration to increase the maximum number of connections. - Look for the

max_connections

parameter in your PostgreSQL

postgresql.conf

file and increase its value. Note that PostgreSQL may need to be restarted to apply changes. 2. Configure Prefect for Better Database Connection Management: - Prefect uses

asyncpg

for PostgreSQL connections. You can manage the connection pool size by configuring Prefect. - While there wasn't a direct example found, you can typically manage connection pools by setting environment variables or configurations if supported by Prefect for your specific database setup. 3. Adjust Prefect Work Pool Concurrency: - If configuring direct database settings isn't viable, consider adjusting the concurrency limits on Prefect's work pools using CLI commands. You can use

set-concurrency-limit

or

clear-concurrency-limit

to adjust how many concurrent operations are run, which might reduce the load on the database. If you're using a different database or setup, please provide more specifics so that I can assist further. For more detailed instructions based on your environment, you might want to consult the following Prefect documentation references: - General database setup and environment variables: Prefect 2.x Hosting Guide - Work Pools and Queues: Prefect 2.x Work Pools Feel free to return if you need more detailed help or further explanation.