VMware Greenplum Command CenterをOrbStackのLinux Machine上のRocky Linuxにインストールし、
こちらの記事で作った環境のモニタリングを行うメモ。
cd /Users/${USER}/Downloads
pivnet download-product-files --product-slug='gpdb-command-center' --release-version='7.1.1' --glob='*.zip'
unzip greenplum-cc-web-7.1.1-gp7-el8-x86_64.zip
gpadminで作業
createdb gpadmin
$ gpconfig -s shared_preload_libraries
Values on all segments are consistent
GUC : shared_preload_libraries
Coordinator value: metrics_collector
Segment value: metrics_collector
gpconfig -c gp_enable_query_metrics -v on
gpstop -r -a
gpssh -f ~/hostfile_exkeys 'sudo mkdir -p /usr/local/greenplum-cc-7.1.1; sudo chown -R gpadmin:gpadmin /usr/local/greenplum-cc-7.1.1'
gpssh -f ~/hostfile_exkeys 'sudo ln -s /usr/local/greenplum-cc-7.1.1 /usr/local/greenplum-cc'
cat <<EOF > gpcc.conf
path = /usr/local/greenplum-cc
display_name = gpcc
master_port = 5432
web_port = 28080
rpc_port = 8899
enable_ssl = false
enable_kerberos = false
language = 1
EOF
./greenplum-cc-web-7.1.1-gp7-el8-x86_64/gpccinstall-7.1.1 -c gpcc.conf
Read setup config from gpcc.conf
Greenplum Command Center will be installed in /usr/local/greenplum-cc/greenplum-cc-7.1.1
********************************************************************************
* WARNING: Your connections to GPCC will be insecure. *
********************************************************************************
INSTALLATION IN PROGRESS...
********************************************************************************
* Please check your .pgpass file for the default password. *
* We recommend changing the default password for the gpmon user unless you *
* plan to connect through LDAP or kerberos. *
********************************************************************************
CREATING SUPERUSER 'gpmon'...
CREATING COMMAND CENTER DATABASE 'gpperfmon'...
RELOADING pg_hba.conf. PLEASE WAIT ...
********************************************************************************
* *
* INSTALLATION IS ALMOST COMPLETED *
* *
* The last step is to update the metrics_collector extension, which needs to *
* restart the Greenplum Database cluster. Please proceed to $GPCC_HOME and *
* follow the instructions in this file: *
* *
* update-extension.txt *
* *
* Some new features may not be available before the update is done. *
* *
* To use GPCC with the old metrics_collector extension, source gpcc_path.sh *
* and run 'gpcc start'. *
* *
********************************************************************************
$ cat /usr/local/greenplum-cc/greenplum-cc/update-extension.txt
Please update metrics_collector extension with the following steps.
Skip if you've just reinstalled GPCC without any changes to GPDB binary.
For more information please check the documentation.
######################################
# #
# I M P O R T A N T N O T I C E #
# #
######################################
!!! GPDB RESTART is required. !!!
When upgrading GPDB to a newer version,
DO NOT use "gppkg --migrate" to migrate the previous metrics_collector.
If you have to use "gppkg -- migrate" for some other packages,
first run "gppkg -r" to remove metrics_collector from the old GPDB installation.
Before you proceed with updating the metrics_collector extension,
be sure to back up these original files, in case you decide to roll back:
$GPHOME/lib/postgresql/metrics_collector.so
$GPHOME/share/postgresql/extension/metrics_collector*
$GPHOME/share/postgresql/extension/gp_wlm*
>-------------------------------------
1. cd /usr/local/greenplum-cc/greenplum-cc-7.1.1/gppkg
2. Stop GPCC: gpcc stop
3. Drop extension: psql gpperfmon -c 'drop extension metrics_collector'
4. List the packages installed:
After GPDB 7: gppkg query
Before GPDB 7: gppkg -q --all
5. Remove the old version of the metrics_collector:
After GPDB 7: gppkg remove MetricsCollector"
Before GPDB 7: gppkg -r MetricsCollector-<version>"
6. Install the new version:
After GPDB 7: gppkg install MetricsCollector-7.1.1_gp_7.0.0-<OS>-<ARCH>.gppkg
(NOTE: If "gppkg query" does not show any installed MetricsCollector packages, you may need to use "gppkg instll -f" instead.)
Before GPDB 7: gppkg -i MetricsCollector-7.1.1_gp_7.0.0-<OS>-<ARCH>.gppkg
7. Restart GPDB
8. Restart GPCC: gpcc start
echo 'source /usr/local/greenplum-cc/greenplum-cc/gpcc_path.sh' >> ~/.bashrc
source ~/.bashrc
cd /usr/local/greenplum-cc/greenplum-cc-7.1.1/gppkg
gpcc stop
psql gpperfmon -c 'drop extension metrics_collector'
gppkg query
gppkg remove MetricsCollector
gpssh -f ~/hostfile_exkeys 'mv $GPHOME/lib/postgresql/metrics_collector.so $GPHOME/lib/postgresql/metrics_collector.so.bak'
gpssh -f ~/hostfile_exkeys 'mv $GPHOME/share/postgresql/extension/gp_wlm--0.1.sql $GPHOME/share/postgresql/extension/gp_wlm--0.1.sql.bak'
gpssh -f ~/hostfile_exkeys 'mv $GPHOME/share/postgresql/extension/gp_wlm.control $GPHOME/share/postgresql/extension/gp_wlm.control.bak'
gpssh -f ~/hostfile_exkeys 'mv $GPHOME/share/postgresql/extension/metrics_collector--1.0.sql $GPHOME/share/postgresql/extension/metrics_collector--1.0.sql.bak'
gpssh -f ~/hostfile_exkeys 'mv $GPHOME/share/postgresql/extension/metrics_collector.control $GPHOME/share/postgresql/extension/metrics_collector.control.bak'
gppkg install MetricsCollector-7.1.1_gp_7.1.0-rocky8-x86_64.gppkg -a
gpstop -r -a
gpcc start
http://gp-coordinator.orb.local:28080
cat ~/.pgpass