Cannot connect to Postgres
secondbreakfast
PROOP

a year ago

I am trying to connect my Rails app to Postgres, and I keep getting this issue:

PG::ConnectionBad: could not connect to server: No such file or directory (PG::ConnectionBad)

Is the server running locally and accepting

connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

View Deploy details

ⓘ Deployment information is only viewable by project members and Railway employees.

Solved

4 Replies

secondbreakfast
PROOP

a year ago

Following up here - curious if this is a platform issue or something easy that's usually debuggable? Need to explore other options if it's the former.


Hey Will,

It's looking like the data tab shows that your DB is working fine: https://railway.com/project/fbd7347d-1537-468a-bd13-0aaef347e82a/service/7bf9d004-bdae-4b3b-8bbd-19e70a09ac83/data?environmentId=cab417c7-1d51-4ad9-8b19-a9ed65aea639

Can you tell me how you are connecting to the DB?

- Angelo


Status changed to Awaiting User Response Railway about 1 year ago


I am also on a meet bridge if you's like to debug this in realtime with me: https://meet.google.com/hnx-zxgj-uta


Exfiling- it seems that the variable when set to production made ActiveRecord freak out and make it unable to connect to the DB. Setting it to development made it work- now that I think of it, there may be some IPv6 weirdness on the part of Rails - but we can have smarter people than I look into that.

Marking as solved.


Status changed to Solved angelo-railway about 1 year ago


Loading...