Postgres Database Connection Error
lekiaanonim
PROOP

10 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

Closed

19 Replies

10 months ago

sorry, too many clients already

Where do you see this error?


lekiaanonim
PROOP

10 months ago

1432571418771718266


10 months ago

Is it possible you have more than 100 connections?


lekiaanonim
PROOP

10 months ago

I don't think so


lekiaanonim
PROOP

10 months ago

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


10 months ago

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


10 months ago

Make sure your app is closing connections as well


10 months ago

But just redeploy


lekiaanonim
PROOP

10 months ago

Okay. How do I make my app close connections?


10 months ago

What framework are you using


lekiaanonim
PROOP

10 months ago

Django


10 months ago

Django should close them automatically


lekiaanonim
PROOP

10 months ago

It works now after redeploying


10 months ago

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


lekiaanonim
PROOP

10 months ago

Yeah, I do


10 months ago

Could be an issue with Railway not closing connections. 🤷


lekiaanonim
PROOP

10 months ago

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


10 months ago

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


10 months ago

I’m going to get flamed for saying that


Welcome!

Sign in to your Railway account to join the conversation.

Loading...