|
NAME | DESCRIPTION | INSTALLATION | FILES | PCP ENVIRONMENT | SEE ALSO | COLOPHON |
PMDAPOSTGRESQL(1) General Commands Manual PMDAPOSTGRESQL(1)
pmdapostgresql - PostgreSQL database PMDA
pmdapostgresql is a Performance Co-Pilot PMDA which extracts live
performance data from a running PostgreSQL database.
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.
/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
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).
PCPIntro(1), pmdadbping(1) and DBI(3).
This page is part of the PCP (Performance Co-Pilot) project.
Information about the project can be found at ⟨http://www.pcp.io/⟩.
If you have a bug report for this manual page, send it to
pcp@oss.sgi.com. This page was obtained from the project's upstream
Git repository ⟨git://git.pcp.io/pcp⟩ on 2017-07-05. If you discover
any rendering problems in this HTML version of the page, or you
believe there is a better or more up-to-date source for the page, or
you have corrections or improvements to the information in this
COLOPHON (which is not part of the original manual page), send a mail
to man-pages@man7.org
Performance Co-Pilot PCP PMDAPOSTGRESQL(1)