Re: Connection pool - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: Connection pool
Date
Msg-id AANLkTi=OkAGqbcD1jc46-xZ6yhvtLosQFXsF8w2oszc6@mail.gmail.com
Whole thread Raw
In response to Connection pool  (Mark Paylaga <mpaylaga@gmail.com>)
Responses Re: Connection pool
List pgsql-general
Hi,

On 6 September 2010 10:34, Mark Paylaga <mpaylaga@gmail.com> wrote:
> Hi sorry if this has been asked already.
> Is there any mechanism to do connection pooling for libpqxx already?
> Or any new developments for this?
>
> Our one dbwriter service instance recieves requests simultaneously to write to the database. We need separate db
connectionsfor each request. The simple way to do it is to hardcode and create x number of connections. Is there a way
tojust use connection pooling? 

There are two programs implementing connection pulling for PG. No need
to implement it in your application.

- pgbouncer (http://wiki.postgresql.org/wiki/PgBouncer)
- pgpool (http://pgpool.projects.postgresql.org/)


>
>  Can anyone point me to the right direction? Thanks.
>
> Mark
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802

pgsql-general by date:

Previous
From: Mark Paylaga
Date:
Subject: Connection pool
Next
From: Magnus Hagander
Date:
Subject: Re: Compiling extension C with MingW in windows, Error...