[Question] Update Operator Image to PPG 17.5.3+ for pg_tde/pgBackRest Integration

[ducnm0711]

Proposal

Hello team

We've encountered a blocker while testing pg_tde integration with PostgreSQL in Kubernetes using the Percona PostgreSQL Operator.

It appears the crucial pg_tde utilities needed for pgBackRest integration were introduced in PostgreSQL version 17.5.3 and later from the Percona distribution. The relevant commit is: https://github.com/percona/postgres/commit/415cb8dd5bbb589a928c5c542fcc38a720b3e502

As the current latest operator version is based on ppg17.5.2 (percona-postgresql-operator:2.7.0-ppg17.5.2-postgres), our pgBackRest testing is currently blocked.

Is there a timeline for when the operator will be updated to include Percona PostgreSQL 17.5.3 or a later version?

Thank you for your support.

Use-Case

The pg_tde command-line utilities (available in PPG 17.5.3+) is needed to ensure pgBackRest is able to correctly handle backups and restores of encrypted databases

Is this a feature you are interested in implementing yourself?

No

Anything else?

N/A

[gkech]

Hello @ducnm0711 , thanks for this issue.

With the 2.8 release of the operator that is going soon, we are updating the images which are using PG 17.6. Given that you can install pg_tde without issues. So please wait for some days and we can rediscuss.

[nmarukovich]

@ducnm0711 version 2.8.0 was released on November 13, so you can try to use it.

[ducnm0711]

Thank you for the release. We will test and close the ticket with result once done. Perhaps I can help contribute back to the community with document on how to use pg_tde in k8s environment.