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

Hi again Jeremy

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

I have tried with both PGHOST set to

127.0.0.1

and set to localhost

still getting the same error with isql:

---
[root@jhbasterisk pg_log]# export PGHOST='127.0.0.1'
[root@jhbasterisk pg_log]# set | grep PGHOST
PGHOST=127.0.0.1
_=PGHOST
[root@jhbasterisk pg_log]# isql -v pgdb-cdr asteriskcdruser pword
[S1000][unixODBC]The database does not exist on the server
or user authentication failed.
[ISQL]ERROR: Could not SQLConnect
[root@jhbasterisk pg_log]# export PGHOST='localhost'
[root@jhbasterisk pg_log]# set | grep PGHOST
PGHOST=localhost
_=PGHOST
[root@jhbasterisk pg_log]# isql -v pgdb-cdr asteriskcdruser 1ndestruc#
[S1000][unixODBC]The database does not exist on the server
or user authentication failed.
[ISQL]ERROR: Could not SQLConnect
[root@jhbasterisk pg_log]#
---

psql itself is still working fine...

Is there any way I can get more resolution on "the database does not exist
on the server OR user authentication failed" - e. g. can I narrow it down
somehow to one OR the other?

Or should I just give up and can 9.4 and start trying 9.3, then 9.2, then
9.1 etc. until I get a Postgres version that can be connected from the
version of ODBC shipped with Centos 6.5?

I really wanted to try postgres 9.4 as I have postgres 8.4 running happily
on another box with Centos 6.5 ODBC working 100% fine, but 8.4 is a bit long
in the tooth and I read that 9.4 has significant speed improvements.

Anybody else reading this - ever yet got Postgres 9.4 ODBC working with the
stock Centos 6.5 unixODBC drivers?