[psqlodbc-Bugs][1011265] psqlodbc driver won't connect when socket not in /tmp

psqlodbc-Bugs item #1011265, was changed at 2015-01-22 09:01 by Heikki Linnakangas
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011265&group_id=1000125
Or by replying to this e-mail entering your response between the following markers:
#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+
(enter your response here, only in plain text format)
#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+#+

>Status: Closed
Priority: 3
Submitted By: David Riedel (dpriedel)
Assigned to: Nobody (None)
Summary: psqlodbc driver won't connect when socket not in /tmp
Category: None
Group: None
>Resolution: Out of Date
Category: None
Group: None
Resolution: None


Initial Comment:
Arch Linux recenty updated their PostgreSQL to move the socket directory from /tmp to /run/postgresql.  The database
andpsql both run fine. 

However, psqlodbc can no longer connect to the database.

PostgreSQL version 9.2.1

psqlodbc version 09.01.0200

error message returned when attempting to connect:

[08001][unixODBC]Could not connect to the server;
Could not connect to remote socket immedaitely
[ISQL]ERROR: Could not SQLConnect

If I tell the database to use /tmp (passing -o "-k /tmp" to pg_ctl) then odbc access works but psql access does not.



----------------------------------------------------------------------

Comment By: Heikki Linnakangas (hlinnaka)
Date: 2015-01-22 08:44

Message:
This is a crappy answer, but the driver was changed recently to always use libpq for connecting. So it should behave
justthe same as psql now... 

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1011265&group_id=1000125