Re: Connecting PG via pgBouncer

[Pongracz Istvan <..hidden..>]

Ok,

It seems, the following happens:

" Programs such as PgBouncer which cache connections at a low level should not use prepared statements via DBD::Pg, or must take extra care in the application to account for the fact that prepared statements are not shared across database connections. "

I found it here: http://search.cpan.org/dist/DBD-Pg/Pg.pm

So, it seems, it will not work with pgbouncer transparently? 

It is sad, due to that, I successfully setup an environment with failover postgresql servers in HA environment, but the automated failover, which switch from died DB server to the hot standby server based on pgbouncer.

Any hint? Or forget it?

Cheers,

István