How does my new Postgres DB have maxed out connections immediately after creation?

Hi @rosspatton,

This error indicates you have maxed out the number of allowed connections to your PostgreSQL database.

The below link has information on the no of Available Backend Connection with the corresponding plan size

https://www.digitalocean.com/docs/databases/overview/#postgresql-limits

As a suggestion you can do one of the below to resolve the issue:

1. Ensure your application does not have processes that are running and keeping open connections.

2. Scale up your instance size see link above with plan size and Available Backend Connection

3. Look into connection pooling, see the link (https://www.digitalocean.com/docs/databases/how-to/postgresql/manage-connection-pools/) for connection pool information and how to create a connection pool

4. As a workaround you can setup a cronjob to close connections periodically

select pg_terminate_backend(procpid)

from pg_stat_activity

where usename = 'yourusername'

and current_query = '<IDLE>'

and query_start < current_timestamp - interval '3 minutes';

You can open a support ticket and reach out to DO support; If you require more details on managing connections for your Postgres database cluster.

https://docs.digitalocean.com/support/

I hope this helps!

Regards, Rajkishore