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