$ 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?