What's important to understand is that if you migrate from PostgreSQL community to one of these distributions and encrypt your tables using the respective solution offered by the distribution, moving back to PostgreSQL Community will require a logical backup (pg_dump) and restore.
Thank you to the group members for the responses to my previous questions about TDE problems with PgSQL 17.
I would like to enquire that based on the anecdotal experience of group members, which TDE solution works best for PgSQL 17 databases. The scenario I have is of a large number of tables (15-20K) and some tables with 100M tuples each. The total database size is 4TB.
I understand there may be variations and specific testing is required, however high-level pointers and feedback would be valuable.