lots of troubleshooting with postgresql these days on my local dev machine. for example, after loading a customer’s DB we could not connect to it from rails server. we kept getting
“IDENT” authentication failures.
turns out we were trying to login with the default user postgres which is the db admin built in, and those connections are refused, UNLESS, you change a special file :
edit the file /etc/postgresql/8.4/main/pg_hba.conf
and in the first lint for the ‘postgres’ user, change the ‘METHOD’ column to ‘md5′
so the first line should look like this:
local all postgres md5
don’t forget to restart postgres after that:
sudo /etc/init.d/postgresql restart
