Rails 8 - ActiveRecord::ConnectionNotEstablished:

1

Hey !

I try to deploy and Rails 8 projects with a postresql DB. I have set up a DB on Render (try a Postgresql@16 and @14) but I still have this error when it tries to deploy :

connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
Couldn't create 'blog_tuto_production_cache' database. Please check your configuration.
bin/rails aborted!
ActiveRecord::ConnectionNotEstablished: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory (ActiveRecord::ConnectionNotEstablished)
	Is the server running locally and accepting connections on that socket?
Caused by:
PG::ConnectionBad: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory (PG::ConnectionBad)
	Is the server running locally and accepting connections on that socket?

my database.yml :

production:
  primary: &primary_production
    <<: *default
    database: blog_tuto_production
    username: blog_tuto
    password: <%= ENV["BLOG_TUTO_DATABASE_PASSWORD"] %>
  cache:
    <<: *primary_production
    database: blog_tuto_production_cache
    migrations_paths: db/cache_migrate
  queue:
    <<: *primary_production
    database: blog_tuto_production_queue
    migrations_paths: db/queue_migrate
  cable:
    <<: *primary_production
    adapter: postgresql
    database: blog_tuto_production_cable
    migrations_paths: db/cable_migrate

if u guys have any suggestion ?
Thanks :slight_smile: