I’ve gone through the documentation and understand that pg_tde allows encryption at the table level .
However, I have an existing PostgreSQL database (needs to be migrated to Percona Server for PostgreSQL) and would like to clarify:
Is there a way to encrypt the entire database or existing tables in-place using pg_tde, or is it required to create new encrypted tables and migrate the data manually?
Also, are there any plans to support full database-level encryption in future releases?
Because of how PGSQL stores data on disk, on a table-by-table basis, it is not possible to encrypt “entire database”.
You don’t need to create new tables, you can ALTER in place
1 Like