Feature Request: SSI DIM Middle Layer – Upgrade to support PostgreSQL 17.x #211
Description
Description
Goal: Upgrade the SSI DIM Middle Layer to use/support PostgreSQL 17.x, thus aligning it with the Tractus-X strategy of harmonizing major database versions across all products for long-term support. This upgrade ensures compatibility through the lifespan of Tractus-X 25.12 respectively Catena-X "Saturn" and "Titan" releases.
See main issue eclipse-tractusx/sig-release#1501 for more details.
Why it matters
- Ensures long-term support for the database version (PostgreSQL 17.x is supported until November 2029).
- Gains performance, efficiency, and security improvements of the newer PostgreSQL release.
- Reduces future upgrade risk/effort jumping several major versions and promotes consistency across Tractus-X products.
Acceptance Criteria
- Update the PostgreSQL configuration (via Helm chart or other deployment settings) to version 17.x (e.g. 17.5 as currently the newest supported "stable" version).
- Run regression and integration tests during the milestone release to confirm functionality and performance align with expectations from the previous version.
If this cannot be completed in time for the 25.12 release due to technical or time constraints, please document this in this issue / in the release notes and plan it for the next cycle.
Notes
- Please ensure compatibility with any individual Postgres-specific extensions and configurations of your product