--- parse_pg_stat.pl 2002/09/13 16:26:53 1.1 +++ parse_pg_stat.pl 2003/08/08 10:49:52 1.2 @@ -3,13 +3,14 @@ use strict; use DBI; -my $user = "dpavlin"; my $host = shift @ARGV || ''; $host = ";host=$host" if ($host); +my $user = shift @ARGV || "dpavlin"; +my $pass = shift @ARGV || ""; my $sql = "select sum(numbackends),sum(xact_commit),sum(xact_rollback),sum(blks_read),sum(blks_hit) from pg_stat_database"; -my $dbh = DBI->connect("DBI:Pg:dbname=template1$host",$user,"") || die $DBI::errstr; +my $dbh = DBI->connect("DBI:Pg:dbname=template1$host",$user,$pass) || die $DBI::errstr; my $sth=$dbh->prepare($sql); if ($sth->execute()) {