Re: Encryption with customer provided key in a multi tenant Postgres JSONB DB

Hi David,

Thanks for the reply.

I just wanted to check if there is any possibility or any activity ongoing
which can enable database or fine granular level encryption in future.

Probably then i can wait otherwise i have to move towards Client Side
encryption as you mentioned.

Best Regards,
Saurav

On Thu, Nov 12, 2020 at 11:44 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Wed, Nov 11, 2020 at 10:49 PM Saurav Sarkar <saurav(dot)sarkar1(at)gmail(dot)com>
> wrote:
>
>> We have a multi tenant application where for each tenant we create
>> separate tables . So for e.g. if i have 100 tenants then i have 100 tables.
>>
>> Now we want to have encryption for the data in the tables with the tenant
>> provided key. Is it possible to encrypt tables in the same database with
>> different keys. ?
>>
>> I learnt that PostgreSQL itself does not support encryption at database
>> level or other finer granular levels . May i please know if in future can
>> this be supported ? or is it not possible technically at all ?
>>
> So you answered your own question...though you can encrypt the data being
> stored within the table by supplying it pre-encrypted and letting the
> client deal with encryption and decryption - which is probably your best
> bet anyway.
>
> Almost everything is possible if you throw enough time and effort at it so
> I'm not sure how to constructively answer the last two questions. Why do
> you ask?
>
> David J.
>
>