Cannot connect to Postgres

secondbreakfastPRO

3 months 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

secondbreakfastPRO

3 months 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.


3 months ago

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[bot] 3 months ago


3 months 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


3 months ago

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 3 months ago