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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Stefan Viljoen" <viljoens(at)verishare(dot)co(dot)za>
Cc: 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-21 13:34:10
Message-ID: 27855.1437485650@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

"Stefan Viljoen" <viljoens(at)verishare(dot)co(dot)za> writes:
> This was my definition in /etc/odbc.ini:

Hm, I just noticed this bit:

> Protocol=9.4

Others with more ODBC experience can correct me, but I suspect that the
ODBC driver has no idea what to do with that value. The PG wire protocol
hasn't changed since 7.4, and I thought that "7.4" was generally the right
thing to use there.

Also, have you tried looking into the resulting TraceFile and/or
DebugFile? You'd probably have to modify

> DebugFile=/var/log/postgresql_debug.log

as I sure hope /var/log is not writable to you.

regards, tom lane

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Ramesh Reddy 2015-07-21 15:11:51 Re: When will you be adding ISC_REQ_MUTUAL_AUTH to the ODBC dwSSPIFlags variable?
Previous Message Stefan Viljoen 2015-07-21 09:23:21 Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client