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 ?
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 |