Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client

Hi Stefan,

Is your PGHOST environment variable set?

If not psql will be using /tmp by default(i.e. unix domain socket which is the 'local' line in the pg_hba.conf file), try
psql -h localhost ...

If this does NOT work it explains why your odbc.ini settings are not working, you could then try changing the odbc.ini line to:-
Servername = /tmp

Regards,
Jeremy
Tyco Safety Products/CEM Systems Ltd.

________________________________

This e-mail contains privileged and confidential information intended for the use of the addressees named above. If you are not the intended recipient of this e-mail, you are hereby notified that you must not disseminate, copy or take any action in respect of any information contained in it. If you have received this e-mail in error, please notify the sender immediately by e-mail and immediately destroy this e-mail and its attachments.