Re: Connection pool

Thanks! I'll look into it.

On Mon, Sep 6, 2010 at 2:54 PM, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> wrote:
> 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
>