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

Hi List

The problems continue - I've now raised the debug logging values to maximum
on the 9.4 instance here that I cannot connect to via unixODBC in Centos
6.5.

This is what the log looks like if I run

---
isql -v pgdb-cdr dbuser dbpass
---

:

---
< 2015-07-21 09:05:11.187 SAST >LOG:  00000: connection received:
host=[local]
< 2015-07-21 09:05:11.187 SAST >LOCATION:  BackendInitialize,
postmaster.c:4007
< 2015-07-21 09:05:11.188 SAST >LOG:  00000: connection authorized:
user=dbuser database=dbpass
< 2015-07-21 09:05:11.188 SAST >LOCATION:  PerformAuthentication,
postinit.c:258
< 2015-07-21 09:05:11.193 SAST >LOG:  08006: could not send data to client:
Broken pipe
< 2015-07-21 09:05:11.193 SAST >LOCATION:  internal_flush, pqcomm.c:1368
< 2015-07-21 09:05:11.193 SAST >FATAL:  08006: connection to client lost
< 2015-07-21 09:05:11.193 SAST >LOCATION:  ProcessInterrupts,
postgres.c:2885
< 2015-07-21 09:05:11.193 SAST >LOG:  00000: disconnection: session time:
0:00:00.006 user=dbuser database=dbpass host=[local]
< 2015-07-21 09:05:11.193 SAST >LOCATION:  log_disconnections,
postgres.c:4511
---

This generates on the commandline

---
# isql -v pgdb-cdr dbuser dbpass
[S1000][unixODBC]The database does not exist on the server
or user authentication failed.
[ISQL]ERROR: Could not SQLConnect
---

so the real problem is a broken UNIX pipe when isql is trying to connect to
Postgres.

Any idea what I can do with this new information in order to solve the ODBC
connection problem from isql?

Thanks

Stefan