I haven't tried this -- we don't use DBI currently -- but wouldn't it get treated as any other connection if you point the DBI connection to the pgbouncer host / port / database ? pgbouncer should redirect the query according the rules in its .ini file.
HTH,
Greg Williamson
From: Prashant Bharucha <prashantbharucha@yahoo.ca> To: pgsql-general@postgresql.org Sent: Sunday, August 26, 2012 6:51 PM Subject: [GENERAL] PGBouncer Connection Using Perl DBI
Hello ,
Could you please tell me some one ,how to do connection PGBouncer using Perl DBI module ?