Re: encryption problem

Bruce Momjian wrote:
>
> Sylvain Sainnier wrote:
> > Hello
> >
> > I would encrypt data that I insert in my table, and I don't know how to do
> > this.
> > can you help me
>
> I would look at /contrib/pgcrypto for encryption/decryption routines.

Or look into encrypting the entire filesystem you have your data
directory in. There are several commercial products and I've seen
a HOWTO for Linux somewhere that describes it with open source
stuff. Basically you mount a huge encrypted file through the
loopback device and an encrypt/decrypt driver.


Jan

>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being
right. #
# Let's break this rule - forgive
me.                                  #
#==================================================
JanWieck@Yahoo.com #