pmdapostgresql man page

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):

This file can contain overridden values (Perl code) for the settings listed at the start of pmdapostgresql.pl, for example:

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

To uninstall, 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

PCP Environment

Environment variables with the prefix PCP_ are used to parameterize the file and directory names used by PCP. On each installation, the file /etc/pcp.conf contains the local values for these variables.  The $PCP_CONF variable may be used to specify an alternative  configuration file, as described in pcp.conf(5).

See Also

PCPIntro(1), pmdadbping(1) and DBI(3).

Info

PCP Performance Co-Pilot