public inbox for [email protected]
help / color / mirror / Atom feedEnquiry about TDE with PgSQL
2+ messages / 2 participants
[nested] [flat]
* Enquiry about TDE with PgSQL
@ 2025-10-13 15:55 Ashish Mukherjee <[email protected]>
2025-10-31 14:41 ` Re: Enquiry about TDE with PgSQL Fernando Laudares Camargos <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Ashish Mukherjee @ 2025-10-13 15:55 UTC (permalink / raw)
To: pgsql-general
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Enquiry about TDE with PgSQL
2025-10-13 15:55 Enquiry about TDE with PgSQL Ashish Mukherjee <[email protected]>
@ 2025-10-31 14:41 ` Fernando Laudares Camargos <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Fernando Laudares Camargos @ 2025-10-31 14:41 UTC (permalink / raw)
To: Ashish Mukherjee <[email protected]>; +Cc: 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:
-
https://www.cybertec-postgresql.com/en/products/cybertec-postgresql-enterprise-edition-pgee/
- https://www.enterprisedb.com/products/database
- https://docs.percona.com/pg-tde/
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 <
[email protected]> 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
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-10-31 14:41 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-10-13 15:55 Enquiry about TDE with PgSQL Ashish Mukherjee <[email protected]>
2025-10-31 14:41 ` Fernando Laudares Camargos <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox