use DBI;
$dbh = DBI->connect("dbi:Pg:dbname=mydb;host=localhost;port=5432;",
                    $username,
                    $password,
                    {AutoCommit => 0, RaiseError => 1, PrintError => 0}
                   );