Re: encrypting data stored in PostgreSQL - Mailing list pgsql-general

From Rob Sargent
Subject Re: encrypting data stored in PostgreSQL
Date
Msg-id 5345B674.1020809@gmail.com
Whole thread Raw
In response to Re: encrypting data stored in PostgreSQL  (John R Pierce <pierce@hogranch.com>)
Responses Re: encrypting data stored in PostgreSQL  (Ken Tanzer <ken.tanzer@gmail.com>)
Re: encrypting data stored in PostgreSQL  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On 04/09/2014 02:52 PM, John R Pierce wrote:
On 4/9/2014 1:40 PM, CS_DBA wrote:
Hi All;

We have a client with this requirement:

At rest data must be encrypted with a unique client key

Any thoughts on how to pull this off for PostgreSQL stored data?

encrypt the data in the client application before sending it to the database server, decrypt it in the client when you need it back.



How does that affect backend sql reporting?\

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: encrypting data stored in PostgreSQL
Next
From: Ken Tanzer
Date:
Subject: Re: encrypting data stored in PostgreSQL