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
       ·   ./postgresql.conf

       This file can contain overridden values (Perl code) for the settings listed at  the  start
       of pmdapostgresql.pl, for example:
       ·   $database    -    database    access    method    and    database    name,   [default:
           'dbi:Pg:dbname=postgres'] (see DBI(3) for details)
       ·   $username - username to connect to the database [default: 'postgres']
       ·   $password - password to connect to the database [default: '']
       ·   $os_user - operating system username (PMDA will run with the  corresponding  user  id)
           [default: $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

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