Ugur Mutlu

I had the same issue. What I did is:

• Uninstall Postgresql
• Install it again by following the instructions here: https://docs.microsoft.com/en-us/windows/wsl/tutorials/wsl-database#install-postgresql
• open a terminal and run "psql -U postgres"
• create a new user by running "CREATE USER user_name WITH PASSWORD 'your_password';"
• check if the user is created "\du"
• add some roles "ALTER ROLE user_name CREATEROLE CREATEDB"
• update your database.yml file with your new user credentials.
• run "rake db:create"
• your DB should be created.