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 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_=--