Limits per plan
| Plan | Connections |
|---|---|
| 1 GB | 22 |
| 2 GB | 47 |
| 4 GB | 97 |
The error
too many connections or remaining connection slots are reserved means every connection is in use.
Fixes
- Use a connection pool in your app and keep it small (for example 5 to 10 per app server). Most frameworks have a setting for it.
- Close idle connections: long-running scripts and open GUI tools hold connections too.
- See who's connected:
SELECT usename, application_name, client_addr, state FROM pg_stat_activity; - Move to a bigger plan if you really need more: Move to a bigger plan.
Was this article helpful? Thanks for your feedback!
