On Tue, Aug 28, 2012 at 8:33 AM, prashantbharucha
wrote:
> Hi Craig
>
> I got connection to pgbouncer,but how do i pass actual database parameter
> to connect .
>
> I attached my perl script and getting error : prepared statement
> "dbdpg_p27841_1"
That doesn't look like a complete error message
Hi Craig
I got connection to pgbouncer,but how do i pass actual database parameter
to connect .
I attached my perl script and getting error : prepared statement
"dbdpg_p27841_1"
Thanks
my $PGDBNAME = 'test';
my $PGDBSERVER = '172.16.40.19';
my $PGDBUSER = 'postgres';
my $PGDBPASSWD = 'post
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
>_
On 08/27/2012 09:51 AM, Prashant Bharucha wrote:
Hello ,
Could you please tell me some one ,how to do connection PGBouncer using
Perl DBI module ?
Exactly the same way you connect to PostgreSQL normally: specify a
hostname, port and database name. Instead of specifying those for the
PostgreSQ