Whole Database or Table AES encryption
Hi,
Is there any way to (virtually) encrypt whole databases or tables with
AES or other types of encryption ?
Regards,
Aaron
--
Aaron Gray
Independent Open Source Software Engineer, Computer Language
Researcher, Information Theorist, and amateur computer scientist.
On Wed, Apr 27, 2022 at 05:21:41PM +0100, Aaron Gray wrote:
Hi,
Is there any way to (virtually) encrypt whole databases or tables with
AES or other types of encryption ?
You can use storage encryption via the operating system. Cybertec has a
patch for PG 12 and the community is working on an implementation,
perhaps for PG 16. You can also do column-level encryption on the
server side via pgcrypto, or on the client side.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
On Wed, 27 Apr 2022 at 18:01, Bruce Momjian <bruce@momjian.us> wrote:
On Wed, Apr 27, 2022 at 05:21:41PM +0100, Aaron Gray wrote:
Hi,
Is there any way to (virtually) encrypt whole databases or tables with
AES or other types of encryption ?You can use storage encryption via the operating system. Cybertec has a
patch for PG 12 and the community is working on an implementation,
perhaps for PG 16.
I would be very interested in this, are there any further pointers as
to where to look at this ?
Is there a repo branch in place working on this or any documentation ?
Cheers,
Aaron
--
Aaron Gray
Independent Open Source Software Engineer, Computer Language
Researcher, Information Theorist, and amateur computer scientist.
On 4/28/22 18:55, Aaron Gray wrote:
On Wed, 27 Apr 2022 at 18:01, Bruce Momjian<bruce@momjian.us> wrote:
On Wed, Apr 27, 2022 at 05:21:41PM +0100, Aaron Gray wrote:
Hi,
Is there any way to (virtually) encrypt whole databases or tables with
AES or other types of encryption ?You can use storage encryption via the operating system. Cybertec has a
patch for PG 12 and the community is working on an implementation,
perhaps for PG 16.I would be very interested in this, are there any further pointers as
to where to look at this ?
Is there a repo branch in place working on this or any documentation ?Cheers,
Aaron
There is a commercial product which supports database encryption,
including PostgreSQL, it's called Voltage:
The company that I work for uses it to encrypt data in both Oracle and
PostgreSQL databases.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
On Thu, Apr 28, 2022 at 11:55:09PM +0100, Aaron Gray wrote:
On Wed, 27 Apr 2022 at 18:01, Bruce Momjian <bruce@momjian.us> wrote:
On Wed, Apr 27, 2022 at 05:21:41PM +0100, Aaron Gray wrote:
Hi,
Is there any way to (virtually) encrypt whole databases or tables with
AES or other types of encryption ?You can use storage encryption via the operating system. Cybertec has a
patch for PG 12 and the community is working on an implementation,
perhaps for PG 16.I would be very interested in this, are there any further pointers as
to where to look at this ?
Is there a repo branch in place working on this or any documentation ?
https://wiki.postgresql.org/wiki/Transparent_Data_Encryption
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
On Fri, 29 Apr 2022 at 00:32, Bruce Momjian <bruce@momjian.us> wrote:
On Thu, Apr 28, 2022 at 11:55:09PM +0100, Aaron Gray wrote:
I would be very interested in this, are there any further pointers as
to where to look at this ?
Is there a repo branch in place working on this or any documentation ?https://wiki.postgresql.org/wiki/Transparent_Data_Encryption
Many thanks,
Aaron
On Fri, 29 Apr 2022 at 00:00, Mladen Gogala <gogala.mladen@gmail.com> wrote:
There is a commercial product which supports database encryption, including PostgreSQL, it's called Voltage:
The company that I work for uses it to encrypt data in both Oracle and PostgreSQL databases.
I was looking for open source solutions, but thanks anyway.
Aaron