From:
tractusx-dev <tractusx-dev-bounces@xxxxxxxxxxx> on behalf of Gurschler Evelyn, FG-222 via tractusx-dev <tractusx-dev@xxxxxxxxxxx>
Date: Monday, 18. September 2023 at 14:11
To: tractusx-dev@xxxxxxxxxxx <tractusx-dev@xxxxxxxxxxx>
Cc: Gurschler Evelyn, FG-222 <Evelyn.Gurschler@xxxxxx>
Subject: Re: [tractusx-dev] Review for TRG 5.07 - PostgreSQL version
Hi Sigi,
I’m currently looking into upgrading from Postgres 14 to 15.
I’d like to align on how to properly execute and document this change.
For the usage of the
PostgreSQL Helm chart from Bitnami as dependency, I attempted to perform a pg_upgrade but I’m facing some issues and
asked for support in this issue:
https://github.com/eclipse-tractusx/sig-infra/issues/271
As
PostgreSQL version 15.x.
as dependency is already widely used: @all Has anybody already performed a successful pg_upgrade using the Helm Chart from Bitnami and if not, how did you perform the upgrade?
Something like done here
https://github.com/bitnami/charts/tree/main/bitnami/keycloak#to-1200 /
https://github.com/bitnami/charts/tree/main/bitnami/postgresql#upgrading by Bitnami, essentially just referring to the official documentation from PostgreSQL, can be considered a very minimal approach but in the case of an external database we’re probably
limited to this.
Regarding alignment on minor versions: Even though your PR isn’t pinning a specific minor version, do you consider it necessary to align for specific releases like the
next one, 23.12, on a specific minor version? The testing phase is planned to start in the end of Oct and I’d assume that there shouldn’t be a minor version change after that point in time.
Thank you and kind regards,
Evelyn
From: tractusx-dev <tractusx-dev-bounces@xxxxxxxxxxx> on behalf of "Kiermayer, Siegfried via tractusx-dev" <tractusx-dev@xxxxxxxxxxx>
Reply to: tractusx developer discussions <tractusx-dev@xxxxxxxxxxx>
Date: Saturday, 16. September 2023 at 15:21
To: "tractusx-dev@xxxxxxxxxxx" <tractusx-dev@xxxxxxxxxxx>
Cc: "Kiermayer, Siegfried" <siegfried.kiermayer@xxxxxxx>
Subject: [tractusx-dev] Review for TRG 5.07 - PostgreSQL version
|
Sent from outside the BMW organization - be CAUTIOUS, particularly with links and attachments.
|
|
Absender außerhalb der BMW Organisation - Bitte VORSICHT beim Öffnen von Links und Anhängen.
|
Hello Everyone,
I'd like to bring to your attention that I've initiated a pull request to transition our PostgreSQL version from major version 14 to 15. You can find the details here:
Pull Request on GitHub
This is a forum for open discussion and suggestions, so your input is highly valued.
Given that a change like this involves some effort, I'm pleased to report that it's being announced well in advance. Our next scheduled release is a few months away, providing ample
time for everyone to update dependencies and make any necessary alignments.
According to our dashboard
Catena-X Dashboard, the most widely used PostgreSQL version is 15.x.
If you're considering an upgrade to your PostgreSQL Helm chart, please take a moment to discuss your plans on our mailing list first. This will help maintain alignment across all
applications and deployments.
Additionally, we are in the process of implementing an automated mechanism that will issue reminders whenever new minor versions become available.
Thank you for your attention and collaboration.
Best regards,
Sigi