Re: [GENERAL] Connection pool

2010-11-23 Thread Vick Khera
On Tue, Nov 23, 2010 at 4:42 AM, Mark Gabriel Paylaga wrote: > When two requests are received at the same time, both of the requests  will > use the same db connection resulting in an error: > Started transaction while transaction still > active > > You have multiple threads sharing the same conn

Re: [GENERAL] Connection pool

2010-11-23 Thread Mark Gabriel Paylaga
Hi, Regarding connection pooling... I may actually not need connection pooling... I have one service to write to db. The service receives one or more requests at the same time from different modules. When two requests are received at the same time, both of the requests will use the same db conne

Re: [GENERAL] Connection Pool

2010-11-02 Thread Craig Ringer
On 11/02/2010 01:42 AM, Jonathan Tripathy wrote: I would like my application to try and get a connection from the pool, and if there are none free, wait until either one is free or time is up. Rather than rolling your own connection pool, consider using one of the well-established existing on

[GENERAL] Connection Pool

2010-11-01 Thread Jonathan Tripathy
Hi Everyone, I'm trying to work with connection pools. The example I'm looking at is lockated here: http://www.developer.com/img/2009/11/Listing1_ConnectionPoolClass.html You will notice that the getConnectionFromPool method does not implement any blocking, and only returns null. I would l

Re: [GENERAL] Connection pool

2010-09-06 Thread Mark Gabriel Paylaga
Thanks! I'll look into it. On Mon, Sep 6, 2010 at 2:54 PM, Sergey Konoplev wrote: > Hi, > > On 6 September 2010 10:34, Mark Paylaga 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? >> >

Re: [GENERAL] Connection pool

2010-09-05 Thread Sergey Konoplev
Hi, On 6 September 2010 10:34, Mark Paylaga 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 databa

[GENERAL] Connection pool

2010-09-05 Thread Mark Paylaga
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 simp

[GENERAL] Connection pool or load balancer supporting ident authentication

2009-07-15 Thread Stuart Bishop
Hi. Is anyone aware of a connection pool or load balancer for PostgreSQL that supports ident based authentication? Neither pgpool-ii nor pgbouncer support this according to their docs, so I was wondering what else is out there. -- Stuart Bishop http://www.stuartbishop.net/ -- Sent via pgsql-g

[GENERAL] Connection pool/load balancer supporting ident authentication?

2009-07-14 Thread Stuart Bishop
Hi. Is anyone aware of a connection pool or load balancer for PostgreSQL that supports ident based authentication? Neither pgpool-ii nor pgbouncer support this according to their docs, so I was wondering what else is out there. -- Stuart Bishop http://www.stuartbishop.net/ -- Sent via pgsql-g