Rails/Postgresql: getting "password authentication failed for user postgres" error on production server

Rails 3.0.1/Ruby 1.9.2 with Postgresql 8.4 work great on my home machine, however I'm getting this error on a Ubuntu server.

I'm sure that the password I upplied in the database.yml file is correct, because when I log in as "postgres", it lets me in:

sudo -u postgres psql template1 Password: psql (8.4.5)

I have edited the "pg_hba.conf" file like this:

# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database
# super user can access the database using some other method.
# Noninteractive
# access to all databases is required during automatic maintenance
# (custom daily cronjobs, replication, and similar tasks).
#
# Database administrative login by UNIX sockets
local   all         postgres                          md5

And this is what I get in my Rails app's production log:

PGError (FATAL: Ident authentication failed for user "postgres"):

ansaurus

tags:

views:

answers:

Rails/Postgresql: getting "password authentication failed for user postgres" error on production server

related questions