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

Re: Can't open more than 128 connections

From: "Nguyen, Lam Thuy" <l7nguyen(at)fcg(dot)com>
To: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Can't open more than 128 connections
Date: 2008-02-05 18:34:34
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
and here is more info :
 I set max_connecion =300, but it only  allows upto 128 connections.
I tried to change some para in postgresql.conf file (shared_buffer...), but it was not efficient.
I read some document in postgres site said that i should change some para of System V IPC, but how do i change them ?
I am using WinXP, SP2, 4GB of GAM
Could you help me as soon as you can.
I am look forward hearing you.


From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp]
Sent: Tue 2/5/2008 12:42 PM
To: Nguyen, Lam Thuy
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Can't open more than 128 connections

Nguyen, Lam Thuy wrote:
> hello,
> I'm trying to open 300 connections to a database using Microsoft odbc
> .NET and psqlodbc.  At the 129th connection attempt i get an
> exception:
> {"ERROR [IM005] [Microsoft][ODBC Driver Manager] Driver's
> SQLAllocHandle on SQL_HANDLE_DBC failed" }
> State: "IM005"

Which version of psqlodbc driver are you using ?

Hiroshi Inoue

This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient.  Any review, reliance, or distribution by others or forwarding without express permission is strictly prohibited.  If you are not the intended recipient, please contact the sender and delete all copies.

In response to

pgsql-odbc by date

Next:From: Rainer BauerDate: 2008-02-05 22:05:03
Subject: Re: How to open more than 300 connections to postgres database.
Previous:From: Nguyen, Lam ThuyDate: 2008-02-05 18:29:46
Subject: Re: Can't open more than 128 connections

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