Install and Configure PostgreSQL (Check)

Hi All, Not sure what is the mistake. I followed the instruction.

  1. Downloaded and installed postgres
  2. created db
  3. created role with superuser privileges
  4. changed the owner of the db to the created user
  5. granted all the privileges to the user to the DB
  6. alter the password to use the md5 hash generated
  7. changed the hba config file to use md5 instead of trust for both local and host

Can please help to take a look into my session./

Hi @rksakthiraam

Possibly you had some miss-configuration in hba conf that is why you were not able to login to postgresql using credentials you created. Below is the screenshot from your original answer.

psql