Trying to set up postgres for ror app, getting error - fe_sendauth: no password supplied
You need to change your change your pg_hba.conf
. Here's an example of mine:
pg_hba.conf
:
TYPE DATABASE USER ADDRESS METHODhost all all 127.0.0.1/32 trusthost all PC 127.0.0.1/32 trusthost all all ::1/128 trust
Note that trust
means that anyone on address
(in this case localhost) can connect as the listed user (or in this case any user of their choice). This is really only suitable for development configurations with unimportant data. Do not use this in production.
@rodrigo-zurek was spot on; you have to change the pg_hba.conf
. Just want to add this answer for the OSX users because the pg_hba.conf
is located in a different place by default.
sudo su - postgresvim /Library/PostgreSQL/<YOUR_VERSION>/data/pg_hba.conf
The default will have md5
in the column METHOD
, but replace all of those with trust
:
# TYPE DATABASE USER ADDRESS METHOD# "local" is for Unix domain socket connections onlylocal all all trust# IPv4 local connections:host all all 127.0.0.1/32 trust# IPv6 local connections:host all all ::1/128 trust
Then, open up pgAdmin III inside your Applications/PostgreSQL 9.X, right click the database (e.g. PostgreSQL 9.4 (localhost)
), and click Reload Configuration
. After this, I was able to rake db:create
.
No password supplied means you have set it up to require password authentication and no password is being supplied. Here is documentation for 9.0: http://www.postgresql.org/docs/9.0/static/auth-methods.html
Keep in mind that local auth was changed from "ident" to "peer" in 9.1 to avoid confusion. See the 9.1 docs at http://www.postgresql.org/docs/9.1/static/auth-methods.html
Also keep in mind that this is an ordered rule set with first match governing. Furthermore local and localhost are different. Local is for local UNIX domain socket connections, while host localhost would be for network connections to localhost. So it sounds like you have some troubleshooting to do but hopefully the docs should help.