DB <app_name>_role with password must be created before creating app.

[kisiohlova]

If <app_name>_role doesn't exist the template will create new role without password and then rails db:create, rails db:migrate will fail:

rails  db:create db:migrate
connection to server at "::1", port 5432 failed: fe_sendauth: no password supplied
Couldn't create 'app_name_development' database. Please check your configuration.
rails aborted!
ActiveRecord::ConnectionNotEstablished: connection to server at "::1", port 5432 failed: fe_sendauth: no password supplied

Caused by:
PG::ConnectionBad: connection to server at "::1", port 5432 failed: fe_sendauth: no password supplied