I have the following role in my system:


There is no password. Trying to connect to the db from within the same machine using either psql or PgAdmin3 to the above role I'm getting:

psql: fe_sendauth: no password supplied

When the password is set I can connect perfectly.

The pg_hba.conf is default - merely:

host    all             all               password
host    all             all             ::1/128                 password

Create Role statement help says:

PASSWORD password

Sets the role's password. (A password is only of use for roles having the LOGIN attribute, but you can nonetheless define one for roles without it.) If you do not plan to use password authentication you can omit this option. If no password is specified, the password will be set to null and password authentication will always fail for that user. A null password can optionally be written explicitly as PASSWORD NULL.

Can I deduct from that that having a NULL password password authentication will always fail? Is this also the case for MD5 authentication? Is there anyway to connect using an NULL password role without specifying trust authentication?

1 Answer 1


Indeed an empty password is equivalent to no password so it's not going to be accepted by the server when pg_hba.conf says that a password is required.

Still, there are various ways to avoid inputting the password:

  • trust method in pg_hba.conf, possibly constrained to a specific user and database
  • client-side PGPASSWORD environment variable
  • client-side .pgpass file
  • dummy password like "test" stored in the same place than the login name
  • Thanks! I don't mind to input password when there is one, I just look into a way of connecting when there is no password at all...
    – Vic
    Dec 31, 2012 at 14:43
  • I believe adding trust entries for these users is the only way Dec 31, 2012 at 14:49
  • @Vic: Well, there are also the ident and peer authentication methods but those, too, are only for trusted clients ... Dec 31, 2012 at 21:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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