BPDM – Upgrade to PostgreSQL 17.x #1435
Description
Description
Goal: Upgrade BPDM to use PostgreSQL 17.x in order to harmonize all Tractus-X products to a common and long-term-supported PostgreSQL major-release version. This ensures support through the expected operative lifetime of Tractus-X 25.12 respectively Catena-X "Saturn" and "Titan" releases.
See main issue eclipse-tractusx/sig-release#1501 for further details.
The applicable TRG 5.07 - Chart Dependencies will also be updated.
Test and Release Management will coordinate this activity.
Why it matters
- Ensures long support window for used database version (PostgreSQL 17.x support currently scheduled until November 2029)
- PostgreSQL performance, efficiency, and security improvements included in this release
- Potentially reduces upgrade risks/efforts when having to make an upgrade "jump" by several major PostgreSQL versions in the future.
- Better harmonizes the supported PostgreSQL (major) version across all Tractus-X products for a release.
Acceptance Criteria
- Upgrade database configuration to PostgreSQL 17.x
(Note: Currently the latest stable minor version is 17.5 but this may change during release phase. Version 18.x is currently not yet a stable release version). - Successfully run all regression and integration tests of your product's release candidate using the new DB version in the milestone release test phase to ensure expected functionality and performance are in line with the version you upgraded from.
If upgrade cannot be completed within the intended 25.12 release due to time/effort/identified functionality problems with the upgrade, please document this in this issue and in the release check issue/release notes, and plan completion for the next release milestone.
Notes
- If applicable please test for compatibility of any potentially used PostgreSQL extensions or other individual database configurations of your product.