Upgrading WarehousePG Enterprise Manager

Upgrade Collector before upgrading WarehousePG Enterprise Manager (WEM). No service shutdown is required before running the upgrade commands.

Upgrading Collector

Run these commands from the WarehousePG coordinator.

1. On the coordinator, download the new Collector package 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. Create a file named all_hosts listing every host in the cluster:

   → WrapCopy

   cdw
   scdw
   sdw1
   sdw2

3. Copy the package to all hosts:

   • WHPG 7
   • WHPG 6

   → WrapCopy

   gpsync -f all_hosts edb-whpg-observability-collector*.rpm =:/tmp/

   → WrapCopy

   gpscp -f all_hosts edb-whpg-observability-collector*.rpm =:/tmp/

4. Upgrade the package on all hosts:

   → WrapCopy

   gpssh -f all_hosts -u gpadmin -e "sudo dnf upgrade -y /tmp/edb-whpg-observability-collector*.rpm"

5. Redeploy the updated Collector service across all hosts:

   → WrapCopy

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

Upgrading WEM

Run these commands on the WEM host:

1. Download the new WEM package 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 whpg-enterprise-manager

2. Install the new WEM package:

   → WrapCopy

   sudo dnf upgrade whpg-enterprise-manager*.rpm

   Upgrading to 1.2: service identity change

   WEM 1.2 changes the service identity from root to gpadmin. The upgrade handles both common cases automatically:

   • gpadmin exists on the WEM host (typical when WEM is co-located with WHPG): The upgrade adjusts file ownership so the gpadmin-run service can write logs. The service user change takes effect on systemctl restart wem.

   • gpadmin is missing (older standalone WEM host that ran as root): The upgrade automatically sets WHPG_ALLOW_ROOT=1 in wem.conf so the service continues running as root, with instructions written to the service configuration for switching to gpadmin later.

   If you have a custom service configuration override that sets User=root, the service refuses to start after the upgrade. Either remove the override or set WHPG_ALLOW_ROOT=1 in /etc/wem/wem.conf.

3. Restart the WEM service to apply the update:

   → WrapCopy

   systemctl restart wem

WEM 1.2 introduces an optional remote write receiver that allows WEM to accept inbound metrics from Grafana Alloy or any Prometheus-compatible client via a POST /write endpoint. This feature is disabled by default and requires explicit configuration to enable. See Remote write receiver (optional) in the Configuring WEM section for details.