WarehousePG Enterprise Manager prerequisites

Prerequisites

• WarehousePG (WHPG) version 6.x running on RHEL 7, RHEL 8, or RHEL 9.

• 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.

• gpadmin OS user on the WEM host. On hosts where WHPG is already installed, gpadmin is provisioned automatically. On standalone WEM hosts, create it first:

  → WrapCopy

  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.

• 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.

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: