Postgres Database Connection Error
lekiaanonim
PROOP

a month 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

0 Replies

sorry, too many clients already

Where do you see this error?


lekiaanonim
PROOP

a month ago

1432571418771718100


Is it possible you have more than 100 connections?


lekiaanonim
PROOP

a month ago

I don't think so


lekiaanonim
PROOP

a month ago

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


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


Make sure your app is closing connections as well


But just redeploy


lekiaanonim
PROOP

a month ago

Okay. How do I make my app close connections?


What framework are you using


lekiaanonim
PROOP

a month ago

Django


Django should close them automatically


lekiaanonim
PROOP

a month ago

It works now after redeploying


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


lekiaanonim
PROOP

a month ago

Yeah, I do


Could be an issue with Railway not closing connections. 🤷


lekiaanonim
PROOP

a month ago

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


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


I’m going to get flamed for saying that


Loading...