1PMDAPOSTGRESQL(1)           General Commands Manual          PMDAPOSTGRESQL(1)
2
3
4

NAME

6       pmdapostgresql - PostgreSQL database PMDA
7

DESCRIPTION

9       pmdapostgresql  is a Performance Co-Pilot PMDA which extracts live per‐
10       formance data from a running PostgreSQL database.
11

INSTALLATION

13       pmdapostgresql uses a configuration file from (in this order):
14       ·   /etc/pcpdbi.conf
15       ·   $PCP_PMDAS_DIR/postgresql/postgresql.conf
16       ·   ./postgresql.conf
17
18       This file can contain overridden values (Perl code)  for  the  settings
19       listed at the start of pmdapostgresql.pl, for example:
20       ·   $database  -  database  access  method and database name, [default:
21           'dbi:Pg:dbname=postgres'] (see DBI(3) for details)
22       ·   $username - username to connect to the  database  [default:  'post‐
23           gres']
24       ·   $password - password to connect to the database [default: '']
25       ·   $os_user - operating system username (PMDA will run with the corre‐
26           sponding user id) [default: $username]
27
28       Once this is setup, you can access the names and values for  the  post‐
29       gresql performance metrics by doing the following as root:
30
31             # cd $PCP_PMDAS_DIR/postgresql
32             # ./Install
33
34       To uninstall, do the following as root:
35
36             # cd $PCP_PMDAS_DIR/postgresql
37             # ./Remove
38
39       pmdapostgresql  is  launched  by  pmcd(1)  and should never be executed
40       directly. The Install and Remove scripts notify pmcd(1) when the  agent
41       is installed or removed.
42

FILES

44       /etc/pcpdbi.conf
45           configuration file for all PCP database monitors
46       $PCP_PMDAS_DIR/postgresql/postgresql.conf
47           configuration file for pmdapostgresql
48       $PCP_PMDAS_DIR/postgresql/Install
49           installation script for the pmdapostgresql agent
50       $PCP_PMDAS_DIR/postgresql/Remove
51           undo installation script for the pmdapostgresql agent
52       $PCP_LOG_DIR/pmcd/postgresql.log
53           default log file for error messages from pmdapostgresql
54

PCP ENVIRONMENT

56       Environment variables with the prefix PCP_ are used to parameterize the
57       file and directory names used by PCP. On each  installation,  the  file
58       /etc/pcp.conf  contains  the  local  values  for  these variables.  The
59       $PCP_CONF variable may be used to specify an alternative  configuration
60       file, as described in pcp.conf(5).
61

SEE ALSO

63       PCPIntro(1), pmdadbping(1) and DBI(3).
64
65
66
67Performance Co-Pilot                  PCP                    PMDAPOSTGRESQL(1)
Impressum