Unix and Linux Discussions Tagged with postgresql |
|
Thread / Thread Starter |
Last Post |
Replies |
Views |
Forum |
|
|
|
0 |
3,113 |
Programming |
|
|
|
1 |
9,906 |
Shell Programming and Scripting |
|
|
|
0 |
1,063 |
Software Releases - RSS News |
|
|
|
3 |
5,411 |
Red Hat |
|
|
|
0 |
1,072 |
Software Releases - RSS News |
|
|
|
3 |
12,683 |
Shell Programming and Scripting |
|
|
|
5 |
11,982 |
UNIX for Advanced & Expert Users |
|
|
|
0 |
2,594 |
Software Releases - RSS News |
|
|
|
8 |
8,400 |
SuSE |
|
|
|
0 |
1,233 |
Software Releases - RSS News |
|
|
|
0 |
3,465 |
UNIX and Linux Applications |
|
|
|
0 |
1,611 |
Software Releases - RSS News |
|
|
|
0 |
1,820 |
Security Advisories (RSS) |
|
|
|
0 |
1,328 |
Security Advisories (RSS) |
|
|
|
0 |
1,224 |
Security Advisories (RSS) |
|
|
|
0 |
1,102 |
Security Advisories (RSS) |
|
|
|
1 |
3,627 |
UNIX for Advanced & Expert Users |
PMDAPOSTGRESQL(1) Performance Co-Pilot PMDAPOSTGRESQL(1)
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):
o /etc/pcpdbi.conf
o $PCP_PMDAS_DIR/postgresql/postgresql.conf
This file can contain overridden values (Perl code) for the settings listed at the start of pmdapostgresql.pl, namely:
o database name (see DBI(3) for details)
o database 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
If you want to undo the installation, 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
SEE ALSO
pmcd(1), pmdadbping.pl(1) and DBI(3).
3.8.10 Performance Co-Pilot PMDAPOSTGRESQL(1)