Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've used Brew to install PostgreSQL. I want to log in with psql. Since I haven't set a password I 'm trying to login without one. When I try I get this:

psql: fe_sendauth: no password supplied

I have this in pg_hba.conf:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
local   all             all                                     trust
host    all             all               trust
host    all             all             ::1/128                 trust

Brew is a clean install. I believe I've removed all instances of postgres (psql doesn't run if I remove the brewed postgresql).

What am am I missing?

share|improve this question

migrated from Oct 20 '12 at 17:37

This question came from our site for professional and enthusiast programmers.

Seems like the file was not read properly.

  1. make sure that you restarted the postgresql-server after editing the file
  2. make really sure that it's restarted (I ran into this twice...)
  3. try again.

I searched one day for one suche error and a simple restart was all that was needed.

Also: with the last homebrew-install I made, my current user was setup automatically without password. so I could just execute psql template0 and was connected to the server.

From there, you can create databases, roles and so on.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.