Skip to content

PostgreSQL instance has exceeded the maximum number of allowed concurrent connections #21

@wilsonccccc

Description

@wilsonccccc

Found fatal error: FATAL: sorry, too many clients already

PostgreSQL has a default connection limit (often 100), most likely we don’t manage connections properly (e.g., not using pooling or not closing connections), and this limit is quickly hit

  1. Use a Connection Pool
  2. Set pool_recycle or pool_timeout (to prevent zombie connections)
  3. Close connections when done (especially in scripts or jobs)

Or any optimization we have to apply.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions