DevHeads.net

Postings by AYahorau

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.

ODBC cliens is hanging if network connection is broken

Hello PostgreSQL Community!

I downloaded and installed the latest version of PostgreSQL from
<a href="https://www.postgresql.org/ftp/source/v10.4/" title="https://www.postgresql.org/ftp/source/v10.4/">https://www.postgresql.org/ftp/source/v10.4/</a> on my SLES 12 system.
Here is my configuration of unixODBC:

odbcinst,ini
[PostgreSQL]
Description=PostgreSQL ODBC driver
Driver=/usr/local/lib/psqlodbcw.so
FileUsage=1

odbc.ini
[sles12-1]
Description = PostgreSQL connection to rtpdb
Driver = PostgreSQL
Database = rtpdb
Servername = sles12-1
Username =
Password =
Port = 5432
Protocol = 7.4+
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ConnSettings =

As a Driver in odbcinst.ini I specified the p