Installs the Command Center database (gpperfmon) and optionally enables the data collection agents.
gpperfmon_install [--enable --password gpmon_password --port gpdb_port] [--pgpass path_to_file] [--verbose] gpperfmon_install --help | -h | -?
The gpperfmon_install utility automates the steps required to enable the data collection agents. You must be the Greenplum Database system user (gpadmin) in order to run this utility. If using the --enable option, Greenplum Database must be restarted after the utility completes.
ALTER DATABASE gpperfmon SET OPTIMIZER = OFF
In Greenplum Database 18.104.22.168, GPORCA co-exists with the legacy query optimizer. For information about GPORCA, see "Querying Data" in the Greenplum Database Administrator Guide.
When run without any options, the utility will just create the gpperfmon database (the database used to store system metrics collected by the data collection agents). When run with the --enable option, the utility will also run the following additional tasks necessary to enable the data collection agents:
- Creates the gpmon superuser role in Greenplum Database. The data collection agents require this role to connect to the database and write their data. The gpmon superuser role uses MD5-encrypted password authentication by default. Use the --password option to set the gpmon superuser's password. Use the --port option to supply the port of the Greenplum Database master instance.
- Updates the $MASTER_DATA_DIRECTORY/pg_hba.conf file. The
utility adds the following lines to the host-based authentication file
local gpperfmon gpmon md5 host all gpmon 127.0.0.1/28 md5Note:
It may be necessary to edit the pg_hba.conf file after running the gpperfmon_install utility to limit the gpmon role's access to databases or to change the authentication method. After you edit the file, run gpstop -u to reload the file in Greenplum Database.
- To limit access to just the gpperfmon database edit the
pg_hba.conf file and in the host entry for the
gpmon user change the second field from all to
host gpperfmon gpmon 127.0.0.1/28 md5
The gpperfmon_install utility assumes the default MD5 authentication method. Greenplum Database may optionally be configured to use the SHA-256 or SHA-256-FIPS hash algorithm to compute the password hashes saved in the system catalog. This is incompatible with the MD5 authentication method, which expects an MD5 hash or clear text password in the system catalog. Because of this, if you have enabled the SHA-256 or SHA-256-FIPS hash algorithm in the database, you must edit the pg_hba.conf file after running the gpperfmon_install utility to change the authentication method for the gpmon role from md5 to password:
local gpperfmon gpmon md5 host all gpmon 127.0.0.1/28 password
The password authentication method submits the user's clear text password for authentication and should not be used on an untrusted network. See "Protecting Passwords in Greenplum Database" in the Greenplum Database Administrator Guide for more information about configuring password hashing.
- To limit access to just the gpperfmon database edit the pg_hba.conf file and in the host entry for the gpmon user change the second field from all to gpperfmon:
- Updates the password file (.pgpass). In order to allow
the data collection agents to connect as the gpmon role without a
password prompt, you must have a password file that has an entry for the
gpmon user. The utility adds the following entry to your password file
(if the file does not exist, the utility will create
*:5432:gpperfmon:gpmon:gpmon_passwordIf your password file is not located in the default location (~/.pgpass), use the --pgpass option to specify the file location.
- Sets the server configuration parameters for Greenplum Command Center. The
following parameters must be enabled for the data collection agents to begin collecting
data. The utility will set the following parameters in the Greenplum Database
postgresql.conf configuration files:
- gp_enable_gpperfmon=on (in all postgresql.conf files)
- gpperfmon_port=8888 (in all postgresql.conf files)
- gp_external_enable_exec=on (in the master postgresql.conf file)
For information about the Greenplum Command Center, see the Greenplum Command Center Administrator Guide.
- In addition to creating the gpperfmon database, performs the additional steps required to enable the data collection agents. When --enable is specified the utility will also create and configure the gpmon superuser account and set the Command Center server configuration parameters in the postgresql.conf files.
- --password gpmon_password
- Required if --enable is specified. Sets the password of the gpmon superuser.
- --port gpdb_port
- Required if --enable is specified. Specifies the connection port of the Greenplum Database master.
- --pgpass path_to_file
- Optional if --enable is specified. If the password file is not in the default location of ~/.pgpass, specifies the location of the password file.
- Sets the logging level to verbose.
- --help | -h | -?
- Displays the online help.
Greenplum Command Center requires the gpperfmon the database role gpmon. After the gpperfmon database and gpmon role have been created, you can change the password for the gpmon role and update the information that Greenplum Command Center uses to connect to the gpperfmon database:
- Log into Greenplum Database as a superuser and change the gpmon
password with the ALTER ROLE
# ALTER ROLE gpmon WITH PASSWORD 'new_password' ;
- Update the password in .pgpass file that is used by Greenplum Command
Center. The default file location is the gpadmin home directory
(~/.pgpass). The .pgpass file contains a line with the
- Restart the Greenplum Command Center with the Command Center gpcmdr
$ gpcmdr --restart
Create the gpperfmon database only:
$ su - gpadmin $ gpperfmon_install
Create the gpperfmon database, create the gpmon superuser, and enable the data collection agents:
$ su - gpadmin $ gpperfmon_install --enable --password p@$$word --port 5432 $ gpstop -r