SSI DIM Wallet Stub – Upgrade to PostgreSQL 17.x

[ds-hzimmer]

Description

Goal: Upgrade the SSI DIM Wallet Stub to use/support PostgreSQL 17.x for database persistence installation version. This aligns it with the Tractus-X strategy of harmonizing all products to a common, long-term-supported PostgreSQL major release. Support for PostgreSQL 17.x ensures coverage through the Tractus-X 25.12 / Catena-X "Saturn" and "Titan" release lifecycles.

See main issue eclipse-tractusx/sig-release#1501 for further details.

Test and Release Management will coordinate this activity.

Why it matters

• Ensures long database version support (support scheduled through November 2029).
• Applies PostgreSQL performance, efficiency, and security benefits.
• Avoids future upgrade complexity across major versions.
• Enhances consistency across all Tractus-X components when persistence is used.

Acceptance Criteria

1. Enable PostgreSQL 17.x configuration for the DIM Wallet Stub persistence module (if persistence mode is selected).
2. Run regression and integration tests of the wallet stub in database-enabled mode under the milestone release test phase to confirm functionality and performance parity.

If upgrade cannot be completed in time for the 25.12 release due to unforeseen issues, document the limitation in release notes and plan for completion in the next release.

Notes

• Only applicable when persistence mode is enabled (non-memory mode).
• Ensure compatibility with any database-specific configurations used by the product.

[ds-sdileo]

Hi @tom-rm-meyer-ISST could you please assign the task to your team? Can you estimate when we can expect the PostgreSQL upgrade?