PMDAPOSTGRESQL(1)

NAME
pmdapostgresql - PostgreSQL database PMDA

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

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

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 pmdapostgresql

SEE ALSO
pmcd(1), pmdadbping.pl(1) and DBI(3).