Problemas con create db o cualquier comando con database

[BenjaminTala]

Segui paso a paso e intente los troubleshoots en los otros issues yu nada me ha servido. Siguiendo paso a pasoo la guia me dio este error al crear el database:

Tambien intente cambiando directamente el usuario y clave de database.yml y tengo este error:

y me entrego esto:

Llevo tres dias seguidos haciendo arreglos distintos que me han recomendado y nada me sirve. Espero me puedan ayudar

[BenjaminTala]

Ahora intente desde mi laptop y tengo este mismo error:

root@Jitalanator:~/CinemaApi# rails db:create
We could not find your database: postgres. 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

Couldn't create 'CinemaApi_development' database. Please check your configuration.
rails aborted!
ActiveRecord::NoDatabaseError: We could not find your database: postgres. 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

Caused by:
PG::ConnectionBad: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist

Tasks: TOP => db:create
(See full trace by running task with --trace)
root@Jitalanator:~/CinemaApi#

[OrregoSilva]

Hola!
Me da la idea que no tienes creado el superusuario de Linux, ya que estás trabajando en root y no en ~. Probablemente, cuando estabas iniciando Ubuntu por primera vez, te saltaste ese paso al apretar enter a las indicaciones. Esta guia te puede ayudar.

[seemab-bukhari]

Please share database.yml as well.
There are two problems with the above error:

1. DB name is twice set in the configurations once as postgres and then as CinemaApi_development
2. Root or any other role doesn't exist in postgres locally. Once the role is created you can set the correct username/password in database.yml