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

Hi Jeremy

Thanks for replying.

>Is your PGHOST environment variable set?

My PGHOST environment variable is NOT set.

Should I set it to 127.0.0.1 or to localhost?

>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 ...

Ok, I used this commandline:

---
psql -h localhost -U username -d asteriskcdrdb
---

and it works 100% just like

---
psql -U username -d asteriskcdrdb
---

works fine.

>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

Ok, I changed the servername line in my odbc.ini to the above, result from
isql stays the same:

---
[root@jhbasterisk pg_log]# isql -v pgdb-cdr username pword
[S1000][unixODBC]The database does not exist on the server
or user authentication failed.
[ISQL]ERROR: Could not SQLConnect
[root@jhbasterisk pg_log]#
---

Is there any way that traffic on localhost can be captured or somehow a way
in which verbosity can be raised?

It seems that the unixODBC version that ships with Centos 6.5 is just
incompatible with the ODBC driver that ships with Postgres 9.4.4... should I
consider a downgrade of Postgres?

Thank you,

Stefan