Re: Connection pool

Hi,

On 6 September 2010 10:34, Mark Paylaga <mpaylaga(at)gmail(dot)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 connections for each request. The simple way to do it is to hardcode and create x number of connections. Is there a way to just 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(at)postgresql(dot)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(dot)ru(at)gmail(dot)com / Skype: gray-hemp / ICQ: 29353802