in your connection string (.env), try to use "postgres" as the <user_name>.
so it should be
DATABASE_URL=postgresql://postgres:<password>@localhost:<server_port>/<db_name>