Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers-win32pgsql-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

pgsql-odbc by date

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

pgsql-hackers-win32 by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group