Re: encrypting data stored in PostgreSQL

On Wed, Apr 9, 2014 at 01:52:51PM -0700, 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.

I have a presentation that covers some of this:

Securing PostgreSQL From External Attack
http://momjian.us/main/presentations/features.html#securing

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +