--- title: VMware Greenplum Command CenterをOrbStackのLinux Machine上のRocky Linuxにインストールするメモ tags: ["OrbStack", "Greenplum", "Greenplum Command Center", "Tanzu", "PostgreSQL", "Rocky"] categories: ["Middleware", "RDBMS", "Greenplum", "Greenplum Command Center"] date: 2024-06-14T02:59:13Z updated: 2024-06-14T02:59:13Z --- [VMware Greenplum Command Center](https://docs.vmware.com/en/VMware-Greenplum-Command-Center/index.html)をOrbStackのLinux Machine上のRocky Linuxにインストールし、 [こちらの記事](/entries/764)で作った環境のモニタリングを行うメモ。 ``` 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 < 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-" 6. Install the new version: After GPDB 7: gppkg install MetricsCollector-7.1.1_gp_7.0.0--.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--.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 image ``` cat ~/.pgpass ``` image