Evrytime i run, su - postgres it asks me for a password which I did not set. I simply installed the postgres. I have gone to the pg_hba.conf.

# Database administrative login by Unix domain socket
local   all             postgres                               trust


# "local" is for Unix domain socket connections only
local   all         all                               ident
# IPv4 local connections:
host    all         all          md5
# IPv6 local connections:
host    all         all         ::1/128               md5

I changed the postgres method from ident to trust and then ran sudo /etc/init.d/postgresql restart. Even then it continues to ask for password. i am not sure where am I going wrong?

What should I do?

  • 2
    The password prompt when running su is done by the operating system not by Postgres.
    – user1822
    Jun 21, 2012 at 21:29
  • so is the password of the operating system??
    – Sam007
    Jun 21, 2012 at 21:31
  • It is the password of the postgres user in the OS. if you're a sudoer, you can sudo su - postgres. If you're not a sudoer then you probably shouldn't be attempting this anyway. Also, you should revert the changes that you made in you pg_hba.conf file.
    – swasheck
    Jun 21, 2012 at 21:33
  • ya i am sudoer and i wish to remove that password of the postgres, for which i changed the method from ident to trust
    – Sam007
    Jun 21, 2012 at 21:40

1 Answer 1


I was finally able to solve the issue thanks to this site,


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.