On Sun, 2011-12-11 at 19:59 -0400, gato pardo wrote:
Started GET “/album/” for 126.96.36.199 at Sun Dec 11 19:28:07 -0400
PGError (FATAL: Peer authentication failed for user “postgres” ):
in the log/production.log file
Any help would be very much appreciated .
I would not recommend that user ‘postgres’ is the user of any postgresql
database from within rails but that is not an answer to your question
but only a suggestion.
If you check your RAILS_ROOT/config/database.yml file, you should have a
section at least for ‘development’, ‘test’ and ‘production’
You don’t say what is different from each configuration (obviously only
the development & production configurations are relevant to your
question) and you don’t tell us if the the server is the same for both
development and production.
If I was going to guess, I would think that your development section
uses a ‘socket’ to connect (something like /var/lib/mysql/mysqld.sock)
and in production, you don’t use a socket so it tries to use TCP/IP Port
5432 which would cause user postgres to fail unless specifically
configured in the pg_hba_conf file (but user postgres is really intended
to use only via a local socket.
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.