Trace-X – Upgrade to PostgreSQL 18.x

[ds-hzimmer]

Description

Goal: Upgrade Trace-X Traceability FOSS to usePostgreSQL 18.x (edit: this goal was changed from 17.x according to latest TRG updates and discussions with committers in November 2025) 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 26.04 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 18.x support currently scheduled until November 2030)
• 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

1. Upgrade database configuration to PostgreSQL 18.x
2. 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 26.03 release (edit: updated from 25.12) 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.

[ds-sdileo]

Hi @rogocof could you please assign the task to your team? Can you estimate when we can expect the PostgreSQL upgrade?

[rogocof]

Hi @ds-sdileo, with the next release (25.12)

[ds-hzimmer]

Target version in title and description was updated to PostgreSQL 18.x