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.