WarehousePG Enterprise Manager 1.2 release notes

Release Date: 02 Jun 2026

WarehousePG Enterprise Manager (WEM) 1.2 includes new features, enhancements, and bug fixes.

Resource management schedules: Define schedules to automatically apply resource group and resource queue settings at specific days and times. Each schedule can target multiple groups at once, supports dry-run preview, manual activation, and pause/resume controls, and logs every execution in a history view.
Query Editor as a standalone page: The Query Editor is now a top-level page with dedicated role-based access controls, making it easier to find and govern SQL authoring separately from workload monitoring.
Configuration History: A new Configuration History tab on the Cluster page provides a time-ordered audit trail of configuration parameter changes, helping teams quickly identify what changed and when.
Prometheus remote write receiver: WEM can now accept inbound metrics from Grafana Alloy or any Prometheus-compatible client, unifying cluster and infrastructure metrics at the /prom/metrics endpoint.
Service identity and PXF integration: The WEM system service now runs as gpadmin instead of root, which is required for PXF integration. Two new CLI commands, wem configure-pxf-sandbox and wem configure-user, handle post-install PXF configuration and OS user changes. No manual steps are required when upgrading from 1.0 or 1.1. See Upgrading WEM.

Alerts subsystem: WEM's internal alert engine has been removed. Alert rules are now defined as Prometheus rule files. Recreate any rules previously configured through WEM as Prometheus YAML files. See Alert rules for the pre-built rules shipped with WEM.

gpadmin OS user is now required for fresh installs. The installer fails if gpadmin doesn't exist on the WEM host. On hosts where the older WEM ran as root, the upgrade automatically configures WEM to continue running as root. See Prerequisites and Upgrading WEM.

Force password change: Administrators can now require a user to change their password at next login directly from the WEM interface. See Managing the user lifecycle.

Role-level Postgres settings: You can now configure Postgres parameters at the role level from the role edit form in Access Management. Role-level settings override cluster-wide defaults for sessions started by that role.
Admin-only action enforcement: Action buttons restricted to Admin users are now disabled rather than hidden for non-admin users, making permission boundaries visible across the interface.

Reason input on cancel and terminate dialogs: When canceling a query or terminating a session, you can now provide an optional reason. The reason is recorded in the WEM audit log. See Monitoring and evaluating queries.

Date-range picker in System Metrics: The System Metrics page now includes a date-range picker, giving you precise control over the time window displayed across all charts and tables.

State column in Sessions: The Sessions tab in Query Monitoring now includes a State column showing the current connection state. The Connections column has been removed.

Fixed the username not displaying in the top right of the screen when the user's full name is empty.

Fixed the Dashboard CPU and Memory charts not aggregating data correctly across nodes.

Fixed PXF cluster status detection from systemd. Fixed an upgrade-time failure where ~gpadmin/gpAdminLogs was not created, causing systemctl restart wem to log install: cannot change owner and permissions of '/home/gpadmin/gpAdminLogs': No such file or directory.

Fixed pagination controls not appearing when the page size equals the total number of items.

Fixed the coordinator and standby being incorrectly included in the Segment Details table.