pmdapostgresql(1) - Linux man page

Name

pmdapostgresql - PostgreSQL database PMDA

pmdapostgresql is a Performance Co-Pilot PMDA which extracts live performance data from a running PostgreSQL database.

pmdapostgresql 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.

/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 pmdapostgresql