PostgreSQL no password supplied

Question

$ brew install postgresql
$ initdb /usr/local/var/postgres -U kimball -W

Entered blank password when prompted. Also tried with no flags previously, but still get locked out.

$ cat /usr/local/var/postgres/pg_hba.conf | grep trust
# METHOD can be "trust", "reject", "md5", "password", "gss", "sspi",
# CAUTION: Configuring the system for local "trust" authentication
# the database superuser.  If you do not trust all your local users,
local   all             all                                     trust
host    all             all             127.0.0.1/32            trust
host    all             all             ::1/128                 trust
$ psql -U kimball
Password for user kimball: 
psql: fe_sendauth: no password supplied

Can anyone please help?

Answer 1

Use this:

$ psql -U kimball -h localhost

Also, do keep in mind that trust policy for all users connecting from all hosts is not a good idea.

Answer 2

It might be that your kimball user doesn't have the login privilege. Try:

$ psql -U postgres

From in there:

alter user kimball superuser login;

And then, back in the shell:

$ psql -U kimball