Rails not using Postgres user account -
i'm using rails 3.0 , postgresql 8.4 on ubuntu 10.10 , ruby 1.9.2p136 pg gem. when run rake db:migrate, error fatal: password authentication failed user "my_os_user_account", when expected log in database my_db_username specified in database.yml.
i have md5 authentication configured in pg_hba.conf both unix socket , ip connections , can log in using psql on command line. have tried setting authentication trust. psql allows me log in without entering password, rails gives fatal: role "my_os_user_account" not exist.
here's database.yml:
development: adapter: postgresql database: my_project_dev user: my_db_username password: my_password pool: 5 timeout: 5000 with additional near-identical entries test , production.
the correct key username is, in fact, username , not user. easy mistake, easy fix.
Comments
Post a Comment