1.Creating the gpperfmon Database
This topic describes how to create the Command Center gpperfmon database and enable the gpperfmon data collection agents. This task must be completed one time for the Greenplum Database system, before you install Greenplum Command Center.When the data collection agents are enabled, their processes are started and stopped (using gpstart and gpstop ) on the Greenplum segment hosts along with the Greenplum Database server processes. Greenplum Database includes a gpperfmon_install utility that performs the following tasks:
- Creates the Command Center database (gpperfmon).
- Creates the Command Center superuser role ( gpmon ).
- Configures Greenplum Database server to accept connections from the gpmon role (edits the pg_hba.conf and .pgpass files).
- Sets the Command Center server configuration parameters in the Greenplum Database server postgresql.conf files.
1.1Enabling the Collection Agents
(1)Log in to the Greenplum master host as the gpadmin user.
$ su - gpadmin
(2)Source the path file from the Greenplum Database installation directory:
# source /usr/local/greenplum-db/greenplum_path.sh
(3)Run the gpperfmon_install utility with the –enable option. You must supply the connection port of the Greenplum Database master server process, and set the password for the gpmon superuser that will be created. For example:
$ gpperfmon_install --enable --password 123qwe --port 5432
Note:The gpperfmon_install utility creates entries for the gpmon user in the $MASTER_DATABASE/pg_hba.conf file. The password you specify is saved in a .pgpass file in the gpadm