Re: encrypting data stored in PostgreSQL

[Rob Sargent <robjsargent@xxxxxxxxx>]

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?\