Changing password for the Postgres user

I recently updated my Ubuntu from 13.04 to the next Long Term Support (LTS) version which is 14.04. Unfortunately my postgreSQL database did not allow the OS user to login, saying it was a bad password.

I recalled my earlier post from some time back, where I had addressed this issue. However even switching to postgres user did not seem to work, as the system complained that I was entering the wrong password.

I needed to reset my password for the OS level postgres user. For this, I entered the following command on my terminal.

$ sudo passwd postgres

This prompted me to enter the sudo password followed by the new password for the postgres user.

Now I followed the steps from my previous post to reinstate the passwords for my OS level user.