ruby on rails - Trying to set up postgres for ror app, getting error - fe_sendauth: no password supplied

Question

Getting:

An error has occurred:

Error connecting to the server: fe_sendauth: no password supplied

Settings in database.yml are the same as the app setup on other machines.

How can I set things up so that I don't need a password hardcoded?

I can view the db ok using PgAdmin-III.

I'd rather not have the password in database.yml as other machines using this app don't have/need it, so it seems likely to be something about my Pg install.

Answer 1

You need to change your change your pg_hba.conf. Here's an example of mine:

pg_hba.conf:

TYPE  DATABASE        USER            ADDRESS                 METHOD

host    all             all             127.0.0.1/32            trust

host    all             PC             127.0.0.1/32            trust

host    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.