Postgres Orchestrator 0.9.1: pgpool binary installation failed with YUM Error "nothing provides libpcp.so.2()(64bit)"

Products

• VMware Tanzu for Postgres

Issue/Introduction

When attempting to deploy a cluster using VMware Tanzu for Postgres Orchestrator 0.9.1 with PgPool configuration, the installation fails during the binary deployment phase.

Error Message:

pgpool binary installation failed: command failed: install_rpms - Installing vmware-postgres17-pgpool-II...ERROR: Failed to install vmware-postgres17-pgpool-IIYUM Error Details:Problem: conflicting requests  - nothing provides vmware-postgres17-pgpool-II = 4.6.5 needed by vmware-postgres17-pgpool-II-devel-4.6.5-3.el9.x86_64 from @commandline  - nothing provides libpcp.so.2()(64bit) needed by vmware-postgres17-pgpool-II-devel-4.6.5-3.el9.x86_64 from @commandline

The issue typically occurs when following the Orchestrator Cluster HA setup

Cause

The failure was caused by a mismatch in the public RPM repository following recent infrastructure (RTO) changes. Specifically, the repository did not provide the required libpcp.so.2()(64bit) dependency and the vmware-postgres17-pgpool-II package version needed by the development headers, resulting in a YUM dependency conflict during the orchestrator deployment.

Resolution

Engineering has updated the public RPM repository to include the missing dependencies. To resolve the issue:

1. Log in to the Broadcom Customer Support Portal (CSP).
2. Download the updated Postgres Orchestrator 0.9.1 package.
3. Perform a re-fetch of the binaries in your environment to ensure the updated RPMs are pulled from the repository.
4. (Workaround if blocked): Manually remove the extra devel and extension packages of PgPool before proceeding with the installation.