Re: [GENERAL] PGBouncer Connection Using Perl DBI

2012-08-28 Thread Jeff Janes
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

Re: [GENERAL] PGBouncer Connection Using Perl DBI

2012-08-28 Thread prashantbharucha
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

Re: [GENERAL] PGBouncer Connection Using Perl DBI

2012-08-27 Thread Greg Williamson
Greg Williamson > > From: Prashant Bharucha >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

Re: [GENERAL] PGBouncer Connection Using Perl DBI

2012-08-26 Thread Craig Ringer
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

[GENERAL] PGBouncer Connection Using Perl DBI

2012-08-26 Thread Prashant Bharucha
Hello ,   Could you please tell me some one ,how to do connection PGBouncer using Perl DBI module ?   Thanks Prashant