Postgres Database Connection Error
lekiaanonim
PROOP

4 months ago

Hi everyone, I just started having the error on Postgres.

psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: sorry, too many clients already connection to server at "localhost" (::1), port 5432 failed: FATAL: sorry, too many clients already

19 Replies

4 months ago

sorry, too many clients already

Where do you see this error?


lekiaanonim
PROOP

4 months ago

1432571418771718100


4 months ago

Is it possible you have more than 100 connections?


lekiaanonim
PROOP

4 months ago

I don't think so


lekiaanonim
PROOP

4 months ago

Project ID: 7701f2a0-8e16-4792-bd77-b9c21f0407c6


4 months ago

You can redeploy to fix it immediately… but I suppose it's possible Railway isn't closing connections


4 months ago

Make sure your app is closing connections as well


4 months ago

But just redeploy


lekiaanonim
PROOP

4 months ago

Okay. How do I make my app close connections?


4 months ago

What framework are you using


lekiaanonim
PROOP

4 months ago

Django


4 months ago

Django should close them automatically


lekiaanonim
PROOP

4 months ago

It works now after redeploying


4 months ago

Yeah. Do you use the Railway database UI a lot?


lekiaanonim
PROOP

4 months ago

Yeah, I do


4 months ago

Could be an issue with Railway not closing connections. 🤷


lekiaanonim
PROOP

4 months ago

Okay, I will try to find out more on the root cause


4 months ago

I’ll always recommend a desktop app like datagrip or dbeaver, you just have so much more control


4 months ago

I’m going to get flamed for saying that


Loading...