Search code examples
ruby-on-railspostgresqlrspecguard

guard and rspec - NOT liking my postgress :test credentials in database.yml

So I have my postgres set up as such in the database.yml

test:
  adapter: postgresql
  encoding: unicode
  database: startpoint
  hostname: localhost
  pool: 5
  username: postgres
  password: password

in the terminal I generally do:

psql -h localhous -d startpoint -U postrgres

And it connects me to the database.

So I tried:

test:
  adapter: postgresql
  encoding: unicode
  database: startpoint
  hostname: localhost
  pool: 5
  username: postgres
  password:

but when guard runs I get:

`initialize': FATAL:  Peer authentication failed for user "postgres" (PG::ConnectionBad)

Ideas?

Solution

  • Make sure your user credentials are set correctly by creating a database and assigning ownership to your app's user to establish the connection. check this out