Thank you so much this solved my issue. I hadn’t set the password for postgres user.
You can set the password like
// starts the postgesql terminal
sudo -u postgres psql
// set the password
\password postgres
after typing this command in the terminal set the new password,
1 Like