Skip site navigation (1) Skip section navigation (2)

Encrypted data.

From: Ben Clewett <B(dot)Clewett(at)roadrunner(dot)uk(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Encrypted data.
Date: 2003-07-22 13:00:53
Message-ID: 3F1D3585.3080105@roadrunner.uk.com (view raw or flat)
Thread:
Lists: pgsql-novice
Dear Novice,

I notice from section 4.28 of 
http://developer.postgresql.org/docs/pgsql/doc/FAQ that encrpytion of 
data within PostgreSQL is only possible by using an encrypted file 
system.  I belive?

In order to protect our distributed database from it's own users, we 
have a requirement to encrypt the data in the system, or by some other 
means make the content unreadable.

I'm looking into finding some system for in-line coding and uncoding of 
non-index fields, hopefully from clear text to same-length ascii text, 
so that VARCHAR(n) can remain the same.

Firstly I was wondering whether there are any plans for this to be 
included in the distribution at a low-level, so that I don't have to 
code my application to do this, and therefore keys may be encrypted yet 
remain correctly ordered etc.   If anybody knows, I would be interesting 
in knowing, and would be interested in helping if at all possible.

Secondly, has anybody had experience with these issues, and can suggest 
another acceptable way of protecting the data by making it unreadable / 
unavailable to all?

Thanks for your help again,

Ben.


In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2003-07-22 13:47:57
Subject: Re: CREATE TYPE with array
Previous:From: Saulius SkruibisDate: 2003-07-22 12:02:30
Subject: Localization

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group