| 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: | Whole Thread | Raw Message | 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 |