Re: Enquiry about TDE with PgSQL - Mailing list pgsql-general

From Fernando Laudares Camargos
Subject Re: Enquiry about TDE with PgSQL
Date
Msg-id CAF0m2_E=iFFOZSX7HTPkyukVqjuGjrwwb+zvy70px6WyJz+9wg@mail.gmail.com
Whole thread Raw
In response to Enquiry about TDE with PgSQL  (Ashish Mukherjee <ashish.mukherjee@gmail.com>)
List pgsql-general
Hi Ashish,
If you are looking for "native" TDE in PostgreSQL, you won't find it in the PostgreSQL community distribution.
If you search for "postgresql tde", you will find a list of vendors that provide TDE functions in their own distributions of PostgreSQL, such as:
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.

Disclaimer: I work for Percona.

On Mon, Oct 13, 2025 at 12:55 PM Ashish Mukherjee <ashish.mukherjee@gmail.com> wrote:
Hello,

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.

Regards,
Ashish

pgsql-general by date:

Previous
From: Kai Wagner
Date:
Subject: Re: Enquiry about TDE with PgSQL
Next
From: Bruce Momjian
Date:
Subject: Re: Enquiry about TDE with PgSQL