...
[15:34:52 CST(-0600)] <dmccallum54> i doubt that's the cause of the failed login, but yes, you should expect fewer surprises in general with 9.x
[15:36:32 CST(-0600)] <dmccallum54> so if you run 'psql -U sspadmin -d ssp', assuming 'ssp' is the name of your db and it's running locally, does it prompt for a password?