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

Performance Co-Pilot                                   PCP                                     PMDAPOSTGRESQL(1)