From: sk@pobox.com
To: pgsql-interfaces@postgresql.org
Subject: Re: Connection Pooling...(Repost)...please do help..
Date: Fri, 15 Dec 2000 16:31:49 GMT
Message-ID: <3a3a4515.3642788@192.168.1.1> (raw)
In-Reply-To: <69F195289743D411B428009027E293C402671039@CLTEXCH1>
References: <69F195289743D411B428009027E293C402671039@CLTEXCH1>
Thanks Joel,
Yes there is. But it only keeps your unused connections on for a given
amount of time, so as to avoid opening new connections when you open a
connection again within the stipulated time.
In our case, we keep the connection open till the application has any
forms open. Problem in this case is that multiple users from different
workstations are opening connections on the PG server on RH 6.2.
What we want to do is start closing connections from applications
after query and somehow pool the connections on the Linux server.
Would like comments on this strategy and a how-to on this....help?
anyone?
With best regards.
Sanjay.
On Wed, 13 Dec 2000 15:19:53 -0500, in
tci.lists.rdbms.postgresql.interfaces you wrote:
>I know that the ODBC "engine" on Win32-based systems is capable of
>performing connection pooling, but I am not sure if the driver has to
>support it or not...anyone? Check the "Connection Pooling" tab on the ODBC
>admin window in control panel. If you don't have one, you might try
>upgrading MDAC.
>
>Joel
>
>-----Original Message-----
>From: Sanjay Arora [mailto:sk@pobox.com]
>Sent: Wednesday, December 13, 2000 7:19 PM
>To: pgsql-interfaces@postgresql.org
>Subject: [INTERFACES] Connection Pooling...(Repost)...please do help...
>
>
>I am using postgreSQL v. 7.0.2 on RH Linux 6.2 on the server with VB6
>Application accessing the DB through postgrSQL ODBC driver v. 6.50.
>
>I want to pool my connections on the postgreSQL server. Can some people
>give me some pointers? Some Web Resources for studying this subject? My
>experience on connection pooling is limited to MTS in MS environs.
>
>With best regards.
>
>Sanjay.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: sk@pobox.com
Subject: Re: Connection Pooling...(Repost)...please do help..
In-Reply-To: <3a3a4515.3642788@192.168.1.1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox