Portal Backend – Upgrade to PostgreSQL 18.x

[ds-hzimmer]

Description

Goal: Upgrade the Portal (Backend) to use PostgreSQL 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.03 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.

Notes

• If applicable please test for compatibility of any potentially used PostgreSQL extensions or other individual database configurations of your product.

[ds-sdileo]

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

[ds-hzimmer]

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

[ds-hzimmer]

Update: The PostgreSQL update to version 18.x was performed by some services as a test, but will be postponed to Release 26.06. Milestone adapted accordingly

Reasoning: Not all core services will participate in the 26.03 release and test phase with new versions and thus not complete this version update and change of image provider to Cloud Pirates.

See discussion in Tractus-X Office Hours meetings Tractus-X Open Meetings (view)

Further details can be discussed in upcoming 26.06 alignment and planning meetings.