EPIC Goal

Validate compatibility of RHDH with PostgreSQL 17 as an external database on all supported Cloud providers (AWS RDS, Azure Database for PostgreSQL, GCP Cloud SQL).

Update the matrix for manual testing to account for PostgreSQL 14-17 across all supported cloud platforms.

Update automated tests to support PostgreSQL 14-17 and ensure they run on a nightly basis in the CI pipeline.

Background/Feature Origin

Backstage upstream has bumped their supported PostgreSQL versions to 13-17 (testing the newest and oldest in the range) in version 1.37.0. RHDH aims to support PostgreSQL 17.

Customers are already planning upgrades to PostgreSQL 17 and need official support confirmation from Red Hat.

Why is this important?

• Enables customers to deploy and upgrade to PostgreSQL 17 with confidence
• Prevents blocking customer adoption of PostgreSQL 17 for compliance or security requirements
• Maintains parity with cloud provider database offerings (AWS RDS, Azure, GCP all support PostgreSQL 17)

User Scenarios

• Enterprise customers upgrading their external PostgreSQL databases from 13-16 to version 17
• New RHDH deployments using PostgreSQL 17 as the backing database on AWS RDS
• Azure customers using Azure Database for PostgreSQL version 17 with RHDH
• GCP customers deploying RHDH with Cloud SQL PostgreSQL 17
• Development teams testing RHDH with PostgreSQL 17 to validate compatibility before production deployment
• Customers with security/compliance requirements mandating the latest PostgreSQL version

Dependencies (internal and external)

• PostgreSQL 17 availability on supported cloud platforms:
• AWS RDS for PostgreSQL 17
• Azure Database for PostgreSQL version 17
• GCP Cloud SQL for PostgreSQL 17
• Backstage 1.37.0+ which includes PostgreSQL 17 support
• Updated CI/CD infrastructure to test against PostgreSQL 14-17
• Test environment access to cloud-based PostgreSQL 17 instances
• No dependency on integrated database (covered by separate epic RHIDP-9570)

Acceptance Criteria

Release Enablement/Demo - Provide necessary release enablement details and documents

DEV - Upstream code and tests merged: [link to meaningful PR or GitHub Issue]

DEV - Upstream documentation merged: [link to meaningful PR or GitHub Issue]

QE - Manual test matrix updated to include PostgreSQL 14-17 on all cloud providers (Azure, GCP - or less if automation finished first)

QE - Automated tests merged and running nightly for PostgreSQL 14-17 (AWS + more if automation finished)

QE - Upgrade path validated (PostgreSQL 16 to 17)