PG::ConnectionBad: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory

Hi there,
I’m picking up this conversation from Al here.

All the details to solve this have been provided in this thread - it’s important to note that this is not a Render-specific issue; this is an application configuration issue.

Configuring Rails to use a database follows a similar pattern across most providers, a database.yml with a production attribute and the URL attribute set to use the environment variable eg:

production: 
     <<: *default
     url: <%= ENV['DATABASE_URL'] %> # ENTER THIS *EXACTLY* AS THIS, THIS READS THE VALUE OF THE DATABASE_URL environment variable programatically

And then provided you have DATABASE_URL set as an environment variable to a valid postgres connection string at runtime the Rails application will point at the correct database.

Regards,

John B
Render Support, UTC+1 :uk: