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

From John R Pierce
Subject Re: encrypting data stored in PostgreSQL
Date
Msg-id 5345BCF2.5020608@hogranch.com
Whole thread Raw
In response to Re: encrypting data stored in PostgreSQL  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
On 4/9/2014 2:07 PM, Rob Sargent wrote:
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?\

does this backend sql reporting system need access to the contents of this encrypted data (presumably credit card numbers or some such ?)   if so, then it too would need to be able to decrypt the data and would have to possess the decryption key(s).



-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: encrypting data stored in PostgreSQL
Next
From: Scott Marlowe
Date:
Subject: Re: Linux vs FreeBSD