configuration of psqlodbc and libpq

[email protected] Tue, 11 Jun 2019 16:00:35 +0300
Newsgroups gmane.comp.db.postgresql.odbc
Message-ID <[email protected]>
This is a multipart message in MIME format.
--=_alternative 004776CA43258416_=
Content-Type: text/plain; charset="US-ASCII"

Hello!
I have a question.

I built and installed PostgreSQL on my system from the source code from 
https://www.postgresql.org/ftp/source/ .
Moreover I built psqlodbc from the source code from 
https://www.postgresql.org/ftp/odbc/versions/src/ .
So psqlodbcw.so library is specified as a Driver in my unixODBC 
configuration. 

But I have a problem. On the one hand all the  PostgreSQL-related 
libraries are located in /usr/lib directory. On the other hand libpq5 rpm 
package is installed on my machine which locates its libraries in 
/usr/lib64 directory. So when I try to establish an odbc connection I see 
that psqlodbc uses the libraries from the /usr/lib64 directory. Not from 
the correct one (/usr/lib in my case).

So I have a question. Is it possible to configure psqlodbc driver in a way 
to use libpq from the specific libraries?
What should I do? Should I reconfigure psqlodbc, postgresql or unixODBC. 


Thank you in advance , 
Andrei 
--=_alternative 004776CA43258416_=
Content-Type: text/html; charset="US-ASCII"

<font size=2 face="sans-serif">Hello!<br>
I have a question.<br>
</font>
<br><font size=2 face="sans-serif">I built and installed PostgreSQL on
my system from the source code from </font><a href=https://www.postgresql.org/ftp/source/><font size=2 color=blue><u>https://www.postgresql.org/ftp/source/</u></font></a><font size=2>
</font><font size=2 face="sans-serif">.<br>
Moreover I built psqlodbc from the source code from </font><a href=https://www.postgresql.org/ftp/odbc/versions/src/><font size=2 color=blue><u>https://www.postgresql.org/ftp/odbc/versions/src/</u></font></a><font size=2>
</font><font size=2 face="sans-serif">.</font>
<br><font size=2 face="sans-serif">So psqlodbcw.so library is specified
as a <b>Driver </b>in my unixODBC configuration. </font>
<br>
<br><font size=2 face="sans-serif">But I have a problem. On the one hand
all the &nbsp;PostgreSQL-related libraries are located in <b>/usr/lib</b>
directory. On the other hand libpq5 rpm package is installed on my machine
which locates its libraries in<b> /usr/lib64</b> directory. So when I try
to establish an odbc connection I see that psqlodbc uses the libraries
from the <b>/usr/lib64</b> directory. Not from the correct one (<b>/usr/lib</b>
in my case).</font>
<br>
<br><font size=2 face="sans-serif">So I have a question. Is it possible
to configure psqlodbc driver in a way to use libpq from the specific libraries?<br>
What should I do? Should I reconfigure psqlodbc, postgresql or unixODBC.
<br>
<br>
</font>
<br><font size=2 face="sans-serif">Thank you in advance , </font>
<br><font size=2 face="sans-serif">Andrei </font>
--=_alternative 004776CA43258416_=--