Too Many Connections? Count Them and Size Your Pool

[julia-kafarska]

Full tutorial with screenshots: https://blog.light-cloud.com/tutorials/database-metrics-and-connections

Part 8 of 8 of the series Databases on Light Cloud.

Fix 'too many connections for role' on Light Cloud PostgreSQL: check the 10-connection limit, see who holds connections, and size pool max x instances.

Level: Intermediate · Time: about 10 minutes · Plan: Lite · Stack: PostgreSQL, Node.js, node-postgres

Steps

• Step 1: Check the limit
• Step 2: See who is connected
• Step 3: What happens at the limit
• Step 4: Size the pool

Source code: https://github.com/light-cloud-com/tutorial-database-basics

---

Questions, problems with a step, or a screen that no longer matches the console? Reply here. Every tutorial is re-run on the live platform before it is published, and this thread is where fixes get discussed.