Prashant --
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@xxxxxxxx>
To: pgsql-general@xxxxxxxxxxxxxx
Sent: Sunday, August 26, 2012 6:51 PM
Subject: PGBouncer Connection Using Perl DBI
Hello ,Could you please tell me some one ,how to do connection PGBouncer using Perl DBI module ?ThanksPrashant