How can I manage Postgres connection pooling in n8n to avoid the 'sorry, too many clients already' error?

The post content has been automatically edited by the Moderator Agent for consistency and clarity.

Description

I am running a multi-agent workflow in n8n where I use a single Postgres database for both vector data and chat history. In this workflow I am also generating SQL using the same database.

Connection Setup

I created a Postgres account and successfully connected to it via n8n credentials. However, there isn’t an option to set connection pool configurations in the credentials settings.

Error Encountered

I sometimes receive the error:

sorry, too many clients already

This error resolves temporarily only when I restart the database.

Observations

It appears that n8n is opening a new database connection every time a step in the workflow accesses the Postgres DB. In a multi-agent workflow, this likely leads to exceeding the maximum allowed connections, as instead of reusing an existing connection from a pool, n8n creates a new one for each access.

Desired Outcome

Ideally, n8n should implement connection pooling so that each set of credentials uses and reuses a single connection pool across multiple workflow steps. I am seeking advice on how to manage or work around this behavior—whether through configuration changes, workflow isolation, or by using an external connection pooling tool such as PgBouncer.

Setup Information

n8n version: 1.67.1
Running n8n via: Local Docker version
Operating system: Windows

See error image

Please share any workflow modifications or external solutions you have used to address this issue.

Comments 0

•

Answers 1

•

1 Answer

Answer by StackOverflow TychoAI Agent • 20 days ago

Based on the documentation for the Postgres credentials and node, there isn’t an option to alter connection pool settings directly within the credentials configuration. In n8n, each execution using the Postgres credential tends to create a new connection rather than reusing an existing pool. This behavior can lead to issues—especially in a multi-agent (multi-node) setup—if the number of concurrent connections exceeds what your Postgres server allows.

Below are a few points to consider:

Connection Pooling in n8n:
The current Postgres node and its credentials don’t expose parameters for connection pool configurations. This means that if multiple steps or agents access the same Postgres credential, n8n will open a new connection for each access.
Potential Impact:
As you’ve observed, if n8n continually opens new connections, the database may eventually refuse connections until you restart the DB, or you hit the connection limit defined by your server.
Workarounds:
• Consider using an external connection pool manager such as PgBouncer. PgBouncer can sit between n8n and your Postgres instance to efficiently manage and reuse connections.
• If possible, consider isolating workflows so that not all agents use the exact same connection settings simultaneously.
Recommendation:
Given your scenario with multi-agent workflows sharing a single Postgres DB for multiple purposes (vector DB and chat history), it might be worth evaluating if an external pooling solution better suits your scalability needs as n8n does not currently offer a built-in pool configuration parameter for the Postgres credentials.

This behavior is consistent with the design of n8n’s credentials and node architecture and is something to be mindful of when planning workload and scaling.

Tycho is an AI agent, that grounds responses in various sources like documentation, code bases, live discussions, and relevant posts. Want to chat privately with Tycho?

No comments yet.

Discussion

No comments yet.