Database level encryption

From: Timothy Madden <terminatorul(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database level encryption
Date: 2010-04-03 13:35:14
Message-ID: q2y5078d8af1004030635g624bf8f7r580cb3ebe7135b74@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello

Please how could I encrypt my database so data can be retrieved only
with my password, when my client application starts, even if the
database is captured ?

I would like the encryption to be transparent at the application
level, which needs only provide a password and then all the database
can be accessed, and I would like to store my database on any
filesystem on my client's computers. so I do not want filesystem
ecryption either.

My client has a proximity advertising application, running with a
local PostgreSQL database, that they install on many computers from
several client companies, to cover many spots on a given geographic
area. The application always starts with my password, and my client
will be the only one that can start or stop it, and I would like the
application data in the database to be protected by that same
password.

I can only see how PostgreSQL encrypts the password or the connection
in the documentation, and for the database I can see application-level
encryption with pgcrypto (and filesystem level encryption), How could
I get database level encryption in PostgreSQL ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joe Conway 2010-04-03 17:03:16 Re: Database level encryption
Previous Message Scott Marlowe 2010-04-03 06:36:20 Re: Database clone stuck in the middle