I dont use postgresql,need help

Hello there. In my Rails application, I decided to use the PostgreSQL database to get rid of the license fee. I set up the local computer and entered the necessary user information. But when I checked the Rails app gives the following error. database.yml:

default: &default
  adapter: postgresql
  encoding: unicode
  database: rails_dev
  username: username
  password: password
  host: localhost
  port: 5432

  # https://guides.rubyonrails.org/configuring.html#database-pooling
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>

development:
  <<: *default
  #database: deneme

test:
  <<: *default
  database: Postgres_test

production:
  <<: *default
  database: Postgres_production
  username: Postgres
  password: <%= ENV['POSTGRES_DATABASE_PASSWORD'] %>

Note: User name and password are correct Thank you for support.

I’m far from knowing what I’m doing, but I don’t think your default shouldn’t have a database. Secondly to avoid confusion I’d use something other than postgres for your dbName. Even pstgrs would be better. I believe my database naming are the defaults. For some reason I don’t use any caps in my dbName, but it’s probably because my app is named without caps. I’m not sure how I have my development passwords set up. But here’s my database.yml with your dbName:

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

development:
  <<: *default
  database: postgres_development

test:
  <<: *default
  database: postgres_test

production:
  <<: *default
  database: postgres_production
  username: postgres
  password: <%= ENV['POSTGRES_DATABASE_PASSWORD'] %>

Good luck.

What error does Rails give?