Re: [GENERAL] PGBouncer Connection Using Perl DBI

[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 = 'postgres';
my  $PORT = '6432';
&main ();
sub main {

    my $dbh =
DBI->connect("dbi:Pg:dbname=$PGDBNAME;host=$PGDBSERVER;port=$PORT;",$PGDBUSER,$PGDBPASSWD,{
        RaiseError => 1,
        AutoCommit => 1,
    });
print ref($dbh);
    my $sql = qq { 

                    select count(*) from a

                };

  my $cursor = $dbh->prepare($sql);
  $cursor->execute() ; 
  my $raw = $cursor->fetchrow_hashref();
}




--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/PGBouncer-Connection-Using-Perl-DBI-tp5721311p5721576.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general