From: | "Stefan Viljoen" <viljoens(at)verishare(dot)co(dot)za> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client |
Date: | 2015-07-20 10:39:27 |
Message-ID: | 004501d0c2d8$5a4cc710$0ee65530$@verishare.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(at)jhbasterisk pg_log]# export PGHOST='127.0.0.1'
[root(at)jhbasterisk pg_log]# set | grep PGHOST
PGHOST=127.0.0.1
_=PGHOST
[root(at)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(at)jhbasterisk pg_log]# export PGHOST='localhost'
[root(at)jhbasterisk pg_log]# set | grep PGHOST
PGHOST=localhost
_=PGHOST
[root(at)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(at)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Faith, Jeremy | 2015-07-20 10:47:13 | Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client |
Previous Message | Stefan Viljoen | 2015-07-20 06:52:35 | Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client |