Before you install WarehousePG Enterprise Manager (WEM), verify that your environment meets the following requirements:
WarehousePG (WHPG) version 6.x running on RHEL 7, RHEL 8, or RHEL 9, or WHPG version 7.x running on RHEL 8 or RHEL 9.
A separate host for WarehousePG Enterprise Manager (WEM), running RHEL 8 or RHEL 9.
gpadminOS user on the WEM host. On hosts where WHPG is already installed,gpadminis provisioned automatically. On the standalone WEM host, create it first:sudo useradd -r -m -d /home/gpadmin -s /bin/bash gpadmin
Loki 3.5 or later. If you don't have Loki running, see Installing the observability stack. If you're integrating with an existing instance, ensure it meets this version requirement.
Prometheus 3.5.0 or later with the remote write receiver enabled. If you don't have Prometheus running, see Installing the observability stack. If you're integrating with an existing instance, ensure it meets this version requirement.
Note
Prometheus doesn't enable the remote write receiver by default. If running Prometheus as a binary, start it with the --web.enable-remote-write-receiver flag. If running via Docker or docker-compose, add this flag to the command in your configuration. Without this flag, Prometheus silently drops metrics pushed by the Collector.
- A database user that holds the superuser role and is able to connect to your WHPG cluster from the WEM host.
- Optional: An active Anthropic account and a valid API key are required to enable the AI Assistant for query writing and optimization.
- Optional: Prometheus Alertmanager version 0.28.1 or later is required to enable centralized alert handling and notifications within WEM.
Warning
WEM is not supported for installation on Red Hat Enterprise Linux 7 (RHEL 7). This limitation applies only to where the WEM application itself is deployed. WEM is fully capable of monitoring WHPG clusters that are running on RHEL 7 nodes.
Network requirements
The following table lists the connection requirements among the different components. The ports listed are default values, you can customize them according to your environment:
| Source | Destination | Use |
|---|---|---|
| WHPG Coordinator | Prometheus:9090 | Push host level metrics |
| WHPG Coordinator | Loki:3100 | Push log files |
| WHPG Coordinator | WEM:9091 | Push metrics to remote write receiver (optional) |
| WHPG Coordinator | WEM:8081 | Host agent sends privileged operation requests to WEM's job-execution engine (also applies to the standby coordinator, if present) |
| WEM | Prometheus:9090 | Retrieve host level metrics |
| WEM | Loki:3100 | Retrieve log metrics |
| WEM | WEM:9093 | Push firing alerts to the bundled Alertmanager instance (loopback only, no external network access required) |
| End user | WEM:8080 | Access to WEM console |
Next steps
Continue to Installing the observability stack.