For passwordless login, use this in terminal:
then for reset password type it:
Then for quit it type:
sudo -u <user_name> psqlit will ask for your system password then enter it:
then for reset password type it:
\password postgresIt will ask for new password. Enter it.
Then for quit it type:
\q
If this doesn't work then, after getting enter into psql terminal window try following command
ReplyDelete$ ALTER USER postgres PASSWORD 'new_password';