DevHeads.net

configuration of psqlodbc and libpq

Hello!
I have a question.

I built and installed PostgreSQL on my system from the source code from
<a href="https://www.postgresql.org/ftp/source/" title="https://www.postgresql.org/ftp/source/">https://www.postgresql.org/ftp/source/</a> .
Moreover I built psqlodbc from the source code from
<a href="https://www.postgresql.org/ftp/odbc/versions/src/" title="https://www.postgresql.org/ftp/odbc/versions/src/">https://www.postgresql.org/ftp/odbc/versions/src/</a> .
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