PMDAPOSTGRESQL(1) Performance Co-Pilot PMDAPOSTGRESQL(1)NAMEpmdapostgresql - PostgreSQL database PMDA
DESCRIPTIONpmdapostgresql is a Performance Co-Pilot PMDA which extracts live
performance data from a running PostgreSQL database.
INSTALLATIONpmdapostgresql uses a configuration file from (in this order):
· /etc/pcpdbi.conf
· $PCP_PMDAS_DIR/postgresql/postgresql.conf
This file can contain overridden values (Perl code) for the settings
listed at the start of pmdapostgresql.pl, namely:
· database name (see DBI(3) for details)
· database username
Once this is setup, you can access the names and values for the
postgresql performance metrics by doing the following as root:
# cd $PCP_PMDAS_DIR/postgresql
# ./Install
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/postgresql
# ./Remove
pmdapostgresql is launched by pmcd(1) and should never be executed
directly. The Install and Remove scripts notify pmcd(1) when the agent
is installed or removed.
FILES
/etc/pcpdbi.conf
configuration file for all PCP database monitors
$PCP_PMDAS_DIR/postgresql/postgresql.conf
configuration file for pmdapostgresql
$PCP_PMDAS_DIR/postgresql/Install
installation script for the pmdapostgresql agent
$PCP_PMDAS_DIR/postgresql/Remove
undo installation script for the pmdapostgresql agent
$PCP_LOG_DIR/pmcd/postgresql.log
default log file for error messages from pmdapostgresqlSEE ALSOpmcd(1), pmdadbping.pl(1) and DBI(3).
3.6.10 Performance Co-Pilot PMDAPOSTGRESQL(1)