diff --git a/src/pmdas/postgresql/pmdapostgresql.pl b/src/pmdas/postgresql/pmdapostgresql.pl index e97252e..29c7593 100644 --- a/src/pmdas/postgresql/pmdapostgresql.pl +++ b/src/pmdas/postgresql/pmdapostgresql.pl @@ -18,8 +18,9 @@ use PCP::PMDA; use DBI; my $database = 'dbi:Pg:dbname=postgres'; -my $username = 'postgres'; -my $password = ''; # DBI parameter, typically unused for postgres +my $username = 'postgres'; # DB username for DB login +my $password = ''; # DBI parameter, typically unused for postgres +my $os_user = 'postgres'; # O/S user to run the PMDA # Configuration files for overriding the above settings for my $file ( '/etc/pcpdbi.conf', # system defaults (lowest priority) @@ -249,6 +250,7 @@ sub postgresql_version_query sub postgresql_connection_setup { if (!defined($dbh)) { + $pmda->log("connect to DB $database as user $username"); $dbh = DBI->connect($database, $username, $password, {AutoCommit => 1, pg_bool_tf => 0}); if (defined($dbh)) { @@ -1463,5 +1465,6 @@ postgresql_indoms_setup(); $pmda->set_fetch_callback(\&postgresql_fetch_callback); $pmda->set_fetch(\&postgresql_connection_setup); $pmda->set_refresh(\&postgresql_refresh); -$pmda->set_user('postgres'); +$pmda->log("Change to UID to user $os_user"); +$pmda->set_user($os_user); $pmda->run;