pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Will PostgreSQL 16 supports native transparent data encryption ?
Date: Thu, 7 Sep 2023 12:31:33 -0400
Message-ID: <ZPn65Z9PYT8Rr0Ki@tamriel.snowman.net> (raw)
In-Reply-To: <d99415a7-0b18-e3b4-8e83-a2f7c85ee079@gmail.com>
References: <CA+Y0QKpJ4MMRvVxxgo0X3ErC1c2jxCz9BU+RC2=gzqyKf27F=A@mail.gmail.com>
	<ZOP3/ybrp++iw0Er@momjian.us>
	<c22d16ee-02a6-7522-d151-66f8db8e14a1@gmail.com>
	<ZOeqvLGDLcZXJ49i@tamriel.snowman.net>
	<d99415a7-0b18-e3b4-8e83-a2f7c85ee079@gmail.com>

Greetings,

* Ron (ronljohnsonjr@gmail.com) wrote:
> On 8/24/23 14:08, Stephen Frost wrote:
> > * Ron (ronljohnsonjr@gmail.com) wrote:
> > > On 8/21/23 18:49, Bruce Momjian wrote:
> > > > On Mon, Aug 21, 2023 at 07:02:46PM +0300, Mostafa Fathy wrote:
> > > > > It is mentioned here https://www.postgresql.org/about/press/faq/#:~:text=
> > > > > Q%3A%20What%20features%20will%20PostgreSQL%2016%20have%3F that native
> > > > > transparent data encryption is being worked on and it may be delivered with
> > > > > PostgreSQL 16.
> > > > > 
> > > > > Is PostgreSQL 16 beta version includes native transparent data encryption or
> > > > > not ? because I checked the docs https://www.postgresql.org/docs/16/index.html
> > > > > and couldn't find anything related to transparent data encryption.
> > > > > 
> > > > > If not supported yet in the beta version I would like to know if PostgreSQL 16
> > > > > final version will support native transparent data encryption or not?
> > > > Not, PG 16 will not support it, and I am unclear if later major versions
> > > > will either.
> > > That's disappointing, since TDE makes PCI audits that much simpler.
> > There's ongoing work happening for TDE support and we'd love to hear
> > from folks who would like to see it included.
> 
> PgBackRest currently encrypts it's binary backups.

pgbackrest is optionally able to encrypt backups, sure, and that's
certainly a good thing, though having a way for the process performing
the backup to not be able to actually see the unencrypted data in the
first place eliminates that as an attack vector.

> 1. What kind of encryption would there be?  AES256 makes the auditors happy.

Supported options for AES would be 128, 192 and 256.

> 2. Would TDE-enabled pg_dump create encrypted dump files?

No, pg_dump is a client utility and hasn't got anything to do with TDE
really.

> 3. Would TDE obviate the need for PgBackRest's encryption?

The short answer to this is 'probably yes, when TDE is enabled on the
cluster'.  Clearly, pgbackrest would continue to support encryption and
there will be some things in PG that aren't encrypted that it might be
nice to have encrypted, depending on your particular security folks, but
you wouldn't need pgbackrest's encryption to ensure that the principle
user data is encrypted.

> 4. How would encrypted "pg_dump --format=plain" work?  Or could it only work
> with the other formats (which is fine by me)?

pg_dump isn't impacted by TDE.

> >    You can expect an updated patch set for the September commitfest.
> 
> For that which will be Pg 17?

Probably still optimistic to be thinking about this for PG17, but
hopefully some of the preliminary work will be able to get into PG17
even if full TDE does not.

> > Getting more folks to test it
> > and use it and review it would certainly help move it forward.
> 
> By any chance, will binaries be created after the September commitfest? 
> (Hoops must be jumped through to get development packages installed on the
> database servers I have access to, but I'd jump through them if needed.)

This would be something to ask the package maintainers... but I tend to
doubt they'd want the additional work; there's already lots and lots of
packages they're dealing with and to add on packages for every patch
that's posted to the PG mailing lists would be a huge task..

Thanks,

Stephen

Attachments:

  signature.asc (application/pgp-signature, 832B) download

view thread (11+ messages)  latest in thread

Message-ID: <ZPn65Z9PYT8Rr0Ki@tamriel.snowman.net>
Permalink:  ../ZPn65Z9PYT8Rr0Ki@tamriel.snowman.net/
Also on:    postgresql.org/message-id/ZPn65Z9PYT8Rr0Ki@tamriel.snowman.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: sfrost@snowman.net, ronljohnsonjr@gmail.com
  Subject: Re: Will PostgreSQL 16 supports native transparent data encryption ?
  In-Reply-To: <ZPn65Z9PYT8Rr0Ki@tamriel.snowman.net>
  References: <CA+Y0QKpJ4MMRvVxxgo0X3ErC1c2jxCz9BU+RC2=gzqyKf27F=A@mail.gmail.com> <ZOP3/ybrp++iw0Er@momjian.us> <c22d16ee-02a6-7522-d151-66f8db8e14a1@gmail.com> <ZOeqvLGDLcZXJ49i@tamriel.snowman.net> <d99415a7-0b18-e3b4-8e83-a2f7c85ee079@gmail.com> <ZPn65Z9PYT8Rr0Ki@tamriel.snowman.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox