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?