WarehousePG Enterprise Manager prerequisites

Note

These instructions assumes you have installed Prometheus and Loki. You can deploy dedicated instances for WEM or integrate with your existing enterprise monitoring stack.

Prerequisites

  • WarehousePG (WHPG) version 6.x running on RHEL 7 or RHEL 8.
  • 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.
  • Loki 3.5 or later. You can deploy a dedicated instance for WEM or integrate with your existing enterprise monitoring stack.
  • Prometheus 3.5.0 or later with remote_write enabled. You can deploy a dedicated instance for WEM or integrate with your existing enterprise monitoring stack.
  • 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: An active installation of 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:

SourceDestinationUse
WHPG CoordinatorPrometheus:9090Push host level metrics
WHPG CoordinatorLoki:3100Push log files
WEMPrometheus:9090Retrieve host level metrics
WEMLoki:3100Retrieve log metrics
End userWEM:8080Access to WEM console

Could this page be better? Report a problem or suggest an addition!