Re: Encrypting a single column - Mailing list pgsql-admin

From Tino Schwarze
Subject Re: Encrypting a single column
Date
Msg-id 20071214180346.GB30811@easy2.in-chemnitz.de
Whole thread Raw
In response to Re: Encrypting a single column  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
On Fri, Dec 14, 2007 at 11:54:58AM -0600, Kevin Grittner wrote:

> > We need to encrypt an individual column in a table. I've noticed that
> > pgcrypto can do this.
> >
> > However we have one problem, our software runs through a closed
> > source "connectivity kit" that allows it to use a postgres dbms, so
> > our programs cant sent an individual sql statement to give the
> > password.
>
> I assume that you're trying to protect against a backup of the
> database falling into the wrong hands?  If so, your connectivity
> layer should be doing the work.

I think, he should go for encrypted backup instead if that's what he
wants to accomplish.

> If you're trying to protect against something else, please clarify.

+1

Bye,

Tino.

--
www.craniosacralzentrum.de
www.lebensraum11.de
www.spiritualdesign-chemnitz.de

Tino Schwarze * Parkstraße 17h * 09120 Chemnitz

pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: Large Objects
Next
From: Anibal Acosta
Date:
Subject: Corrupt backup file after pg_dump (from windows)