Postgres fe sendauth no password supplied


fe_sendauth: no password supplied

If you’re getting this error in your local development when trying to use PostgreSQL set your pg_hba.conf to include a trust line for the hosts involved to fix the problem.

The default location for pg_hba.conf can be found here: /etc/postgresql/9.0/main/pg_hba.conf

I changed the following lines at the bottom of the file

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:</code>
host    all         all         ::1/128               trust

Remember to restart your postgres server ;)

-Matt

29 May 2011