postgresql

PMDAPOSTGRESQL(1)					       Performance Co-Pilot						 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):

       o   /etc/pcpdbi.conf

       o   $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:

       o   database name (see DBI(3) for details)

       o   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).

3.8.10							       Performance Co-Pilot						 PMDAPOSTGRESQL(1)