Supporting Encryption in Postgresql

From: Murat Kantarcioglu <kanmurat(at)cs(dot)purdue(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Supporting Encryption in Postgresql
Date: 2004-09-09 21:03:09
Message-ID: chqgec$2ujk$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

For our research project, I need to implement an encryption support for
Postgressql. At this current phase, I need to at least support page
level encryption In other words, each page that belongs to a certain
sensitive table will be stored encrypted on the harddisk.
Since we are trying to have a new design that can start the decryption
before even we see the data, I need to have some kind of thread support.

My questions are in order to support page level encryption(i,e encrypt
each page before writing back to disk and decrypt each page after we
read from disk.) which parts of the code should be changed?
Our more simply, is /src/backend/storage/smgr/md.c the only code
that does the disk access?

Since our design requires thread support (we will do some of the
decryption, before we see the data, therefore during disk access, we
need to continue decryption) Can you suggest me a good thread lib you
think will work fine with postgresql ?

Thanks for your help.

Murat Kantarcioglu, PhD Candidate,
Computer Science Department,
Purdue University

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2004-09-09 21:30:27 Clarification of action on Delete
Previous Message Joe Conway 2004-09-09 20:30:29 Re: x86_64 configure problem