Bug#536656: pgadmin III and psql unable to connect

2009-11-08 Thread Dennis Gearon
I was able to finally get in with command line psql. I changed all lines in 'pg_hba.conf' to end with 'md5' versus some of them ending in 'ident'. I also changed the password on the postgres user to match the password on the database user postgres. That was done first, but seemed to have no effe

Bug#536656: pgadmin III and psql unable to connect

2009-11-08 Thread Dennis Gearon
Additional information . . . I compared the old '.conf' file with the new one. The ONLY difference that I could see was that the 'listen localhost' directive in the old version was active, and the new version wasn't. So uncommented it, restarted tne new (8.4) version, and no difference. BTW,

Bug#536656: pgadmin III and psql unable to connect

2009-11-08 Thread Dennis Gearon
I have just updated Ubuntu (a debian flavor) to 9.10. I am afraid to say, that I did it as soon as it came out, only because of the updater prompt. Overall it's much better than previous versions However, it upgraded postgres to 8.4 and I can't connect to it as per exactly this bug. If I use