Installing the Collector

Install the WarehousePG (WHPG) Collector on your WHPG cluster coordinator.

Downloading and installing WHPG Collector

1. On the coordinator, download the packages from the EDB repository:

   → WrapCopy

   export EDB_SUBSCRIPTION_TOKEN=<your-token>
   export EDB_REPO=gpsupp
   curl -1sSLf "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/$EDB_REPO/setup.rpm.sh" | sudo -E bash
   sudo dnf download edb-whpg-observability-collector

2. On the coordinator, create a file all_hosts which lists all hosts in the WHPG cluster. For example:

   → WrapCopy

   cdw
   scdw
   sdw1
   sdw2
   sdw3

3. From the coordinator, transfer and install the Collector package on all hosts in the WHPG cluster:

   • RHEL 8, 9
   • RHEL 7

   → WrapCopy

   gpssh -f all_hosts -u gpadmin -e "scp gpadmin@$(hostname):edb-whpg-observability-collector*.rpm /tmp/ && sudo dnf install -y /tmp/edb-whpg-observability-collector*.rpm"

   → WrapCopy

   gpssh -f all_hosts -u gpadmin -e "scp gpadmin@$(hostname):edb-whpg-observability-collector*.rpm /tmp/ && sudo yum install -y /tmp/edb-whpg-observability-collector*.rpm"

Configuring the Collector

Once the Collector packages are installed, edit the file /var/lib/whpg-observability-collector/collector.conf on the coordinator and configure the following parameters:

• WHPG_OBS_DSN: Specify your WHPG cluster connection details. For example:

  → WrapCopy

  WHPG_OBS_DSN="host=whpg-coordinator-host port=5432 dbname=postgres user=gpadmin password=postgres sslmode=disable"

• LOKI_ENDPOINT: Point to your configured Loki endpoint for log files. For example:

  → WrapCopy

  LOKI_ENDPOINT="http://loki.hostname:3100/loki/api/v1/push"

• PROMETHEUS_ENDPOINT: Point to your configured Prometheus endpoint for host-level metrics. For example:

  → WrapCopy

  PROMETHEUS_ENDPOINT="http://prometheus.hostname:9090/api/v1/write"

Starting the Collector service

On the coordinator, run the following commands to deploy the configuration and start the service on every host in the WHPG cluster:

cd /var/lib/whpg-observability-collector
./deploy-observability 

The Collector now runs in the background on each host as the alloy service. You can manage this service using systemctl commands. For example:

To check the service status:

sudo systemctl status alloy

To enable on boot:

sudo systemctl enable alloy