Rails console no password supply error

Question

I am running a rails application with postgresql as a database, I have a user on the database with empty password. The application runs successfully but when I am trying to use a model from the console I am getting the following error.

PG::ConnectionBad: fe_sendauth: no password supplied

Answer 1

Short answer, in your database.yml file, replace:

host: localhost with host: ''

This should do the trick.

For long answer and explanation, look at this answer