I can't manage to connect my postgres database to my rails app.

I get this error :

rake aborted!

ActiveRecord::NoDatabaseError: We could not find your database: railway. Which can be found in the database configuration file located at config/database.yml.

To resolve this issue:

- Did you create the database for this app, or delete it? You may need to create your database.

- Has the database name changed? Check your database.yml config has the correct database name.

To create your database, run:

bin/rails db:create

/Users/raimbaultbrieuc/Documents/caverne/backend/lib/tasks/20230902_get_data.rake:14:in `block in <main>'

Caused by:

PG::ConnectionBad: could not translate host name "postgres.railway.internal" to address: nodename nor servname provided, or not known

my database.yml looks like this:

default: &default
  adapter: postgresql
  encoding: unicode
  pool: 5

[...]

production:
  <<: *default
  url: <%= ENV['DATABASE_URL'] %>