[Bucardo-general] Connection Pooling

[David E. Wheeler]

On Oct 2, 2012, at 10:02 PM, Greg Sabino Mullane <greg at endpoint.com> wrote:

> Because you would be connected to the existing session, which 
> would more than likely have session_replication_role = 'replica', 
> which allows you to shoot yourself in the foot quite effectively 
> indeed.

Oh, I see. Hrm. I wonder if pgBouncer would reset such things before assigning a connection to a new client.

> Would be cool if pgbouncer would look at the application_name 
> and reject non-matching ones.

I’ll go ask the pgBouncer folks. Not that it matters if session pooling is kind of pointless.

Best,

David