pgsqlODBC problems

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: pgsql-general(at)postgresql(dot)org, pgsql-hackers-win32(at)postgresql(dot)org, "Pgsql-Odbc(at)Postgresql(dot)Org" <pgsql-odbc(at)postgresql(dot)org>
Subject: pgsqlODBC problems
Date: 2005-01-13 12:33:16
Message-ID: 0IA90092R9QE7U@mail.vnet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers-win32 pgsql-odbc

Hi,
I need some information regarding pgsqlODBC driver on Windows2000. We use an
application which inserts records pallely into an SQL database via ODBC.
It estableshes 16 pallel connections and continously inserts data. The
software works well on a test environment with MS Access and MS ODBC driver.

Using Postgres the application stopps inserting rows after 2-3 hours. Is
there anybody who uses the postgres ODBC driver 24x7? Is that possible that
the odbc dll contains a memory leak or a bug?

At the time losing the connection the following entry appears in the
postgres log file:
-------------------------------------------------------------------
2005-01-12 00:01:31 LOG: unexpected EOF on client connection
2005-01-12 00:01:31 LOG: could not receive data from client: No
connection could be made because the target machine actively refused it.
-------------------------------------------------------------------

Other question: After numerous restart of the above mentioned software there
are 50-70 connections in postgres (PGAdminIII server status window). How
could I set a timeout for these connections to be destroyed quicker.

(Environment: Win2k, PG8RC2, pgsqlODBC 7.03.02.00)

Thank you very much,

-- Csaba Együd.

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.11 - Release Date: 2005.01.12.

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.11 - Release Date: 2005.01.12.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2005-01-13 12:50:08 how to determine initdb locale (after the event)?
Previous Message David Garamond 2005-01-13 11:34:30 Re: [HACKERS] Much Ado About COUNT(*)

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Kevin Brown 2005-01-13 13:03:54 Re: [pgsql-hackers-win32] [BUGS] More SSL questions..
Previous Message M.N. Swaminathan 2005-01-13 04:46:13 Re: Bugs]

Browse pgsql-odbc by date

  From Date Subject
Next Message William Yu 2005-01-13 17:13:42 Re: pgsqlODBC problems
Previous Message Ken Shaw 2005-01-12 23:03:33 Proposed addition to psqlodbc driver