Re: Application Level Encryption - Mailing list pgsql-general

From Michel Pelletier
Subject Re: Application Level Encryption
Date
Msg-id CACxu=vKTzXPf=6TK5_LZu1OkhYj1_oMtdKYgFLJ5kKBozKoxbA@mail.gmail.com
Whole thread Raw
In response to Re: Application Level Encryption  (Sam Gendler <sgendler@ideasculptor.com>)
Responses RE: Application Level Encryption
List pgsql-general


On Sun, Jul 5, 2020 at 3:23 PM Sam Gendler <sgendler@ideasculptor.com> wrote:


On Sun, Jul 5, 2020 at 11:41 AM Michel Pelletier <pelletier.michel@gmail.com> wrote:


I'm working on an approach where the decrypted DEK only lives for the lifetime of a transaction, this means hitting the kms on every transaction that uses keys.  It will be slower, but the time the decrypted key stays in memory would be minimized.

Watch out for KMS api quotas if you go that route.  Their docs don't state what the default quotas are, so you have to go to your quotas page in the console to find out, but they likely aren't very high and might well be exceeded by the transaction rate on even a relatively small db instance.

Thanks for pointing that out, it's true that it's a limited route with cloud KMS.   If you control the device like a Zymkey in a secure enclosure, the cost is minimal, although the key derivation rate is very slow.

-Michel


 

pgsql-general by date:

Previous
From: Sam Gendler
Date:
Subject: Re: Application Level Encryption
Next
From: Zahir Lalani
Date:
Subject: RE: Application Level Encryption