pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase Encryption
10+ messages / 8 participants
[nested] [flat]
* Database Encryption
@ 2003-06-17 18:18 JR Richards <jr@ebcrp.org>
2003-06-19 14:11 ` Re: Database Encryption Jonathan Gardner <jgardner@jonathangardner.net>
2003-06-19 17:22 ` Re: Database Encryption Ragnar <postgres@ragnark.vestdata.no>
0 siblings, 2 replies; 10+ messages in thread
From: JR Richards @ 2003-06-17 18:18 UTC (permalink / raw)
To: pgsql-admin
I'm interested in using a passwords table with my Access front end, but
need to encrypt the passwords over the network. Can anyone help me get
started on this kind of project?
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Database Encryption
2003-06-17 18:18 Database Encryption JR Richards <jr@ebcrp.org>
@ 2003-06-19 14:11 ` Jonathan Gardner <jgardner@jonathangardner.net>
1 sibling, 0 replies; 10+ messages in thread
From: Jonathan Gardner @ 2003-06-19 14:11 UTC (permalink / raw)
To: JR Richards <jr@ebcrp.org>; pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Tuesday 17 June 2003 11:18, JR Richards wrote:
> I'm interested in using a passwords table with my Access front end, but
> need to encrypt the passwords over the network. Can anyone help me get
> started on this kind of project?
>
Isn't ODBC what is being used between PostgreSQL and Access? I am not sure on
the details, but that is the place to start looking for an answer. If ODBC
can support secure SSL/TLS connections, then you can just use that to
connect.
If Access can't handle a secure connection, then you have no options but to
abandon Access.
- --
Jonathan Gardner <jgardner@jonathangardner.net>
(was jgardn@alumni.washington.edu)
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE+8cSgWgwF3QvpWNwRApg3AJ9VCLFOWmuxrfVS2DL8f8e1M2enWQCfSO+c
DoT/2UWQY1vJ1W2WP2Cmfc0=
=JfLg
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Database Encryption
2003-06-17 18:18 Database Encryption JR Richards <jr@ebcrp.org>
@ 2003-06-19 17:22 ` Ragnar <postgres@ragnark.vestdata.no>
1 sibling, 0 replies; 10+ messages in thread
From: Ragnar Kjørstad @ 2003-06-19 17:22 UTC (permalink / raw)
To: JR Richards <jr@ebcrp.org>; +Cc: pgsql-admin
On Tue, Jun 17, 2003 at 11:18:57AM -0700, JR Richards wrote:
> I'm interested in using a passwords table with my Access front end, but
> need to encrypt the passwords over the network. Can anyone help me get
> started on this kind of project?
I would think that you could use ssh or stunnel to securely tunnel the
traffic.
Alternatively some kind of VPN would do.
--
Ragnar Kjørstad
Zet.no
^ permalink raw reply [nested|flat] 10+ messages in thread
* database encryption
@ 2007-02-07 10:23 Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-07 14:35 ` Re: database encryption Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 10+ messages in thread
From: Olivier Boissard @ 2007-02-07 10:23 UTC (permalink / raw)
To: pgsql-admin
Hello,
I'd like to know which solutions exist encrypt postgresql database ?
Did you already use an encryption method ?
I saw on the web that there is a contrib (pgcypto) but I can't estimate
its efficiency
Olivier
Attachments:
olivier.boissard.vcf (text/x-vcard, 239B) download
begin:vcard
fn:Olivier Boissard
n:Boissard;Olivier
org:Cerene Services
adr:;;3 rue Archimede;La Chapelle Saint Luc;;10000;France
email;internet:olivier.boissard@cerene.fr
tel;work:03.25.74.11.78
tel;fax:03.25.78.39.67
version:2.1
end:vcard
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: database encryption
2007-02-07 10:23 database encryption Olivier Boissard <olivier.boissard@cerene.fr>
@ 2007-02-07 14:35 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-02-08 08:13 ` Re: database encryption Olivier Boissard <olivier.boissard@cerene.fr>
0 siblings, 1 reply; 10+ messages in thread
From: Andrew Sullivan @ 2007-02-07 14:35 UTC (permalink / raw)
To: pgsql-admin
On Wed, Feb 07, 2007 at 11:23:03AM +0100, Olivier Boissard wrote:
> I saw on the web that there is a contrib (pgcypto) but I can't estimate
> its efficiency
Well, it works for some people. What are you trying to accomplish
with "database encryption"?
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
--George Orwell
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: database encryption
2007-02-07 10:23 database encryption Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-07 14:35 ` Re: database encryption Andrew Sullivan <ajs@crankycanuck.ca>
@ 2007-02-08 08:13 ` Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-08 11:52 ` Re: database encryption Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 10+ messages in thread
From: Olivier Boissard @ 2007-02-08 08:13 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; +Cc: pgsql-admin
Andrew Sullivan a écrit :
> On Wed, Feb 07, 2007 at 11:23:03AM +0100, Olivier Boissard wrote:
>
>> I saw on the web that there is a contrib (pgcypto) but I can't estimate
>> its efficiency
>>
>
> Well, it works for some people. What are you trying to accomplish
> with "database encryption"?
>
> A
>
>
I would like to insert sensitive data into postgresql tables.
These informations must be well-protected as they are confidential but
they must be "decrypted" by php programs too.
(These PHP programs will be encrypted by php encryptions program.)
I was thinking about a system in which only the php programs will be
able to manage stored informations. In case of theft or unexpected
access to servers nobody could be able to retrieve the stored data
without the authorized key.
Olivier
Attachments:
olivier.boissard.vcf (text/x-vcard, 239B) download
begin:vcard
fn:Olivier Boissard
n:Boissard;Olivier
org:Cerene Services
adr:;;3 rue Archimede;La Chapelle Saint Luc;;10000;France
email;internet:olivier.boissard@cerene.fr
tel;work:03.25.74.11.78
tel;fax:03.25.78.39.67
version:2.1
end:vcard
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: database encryption
2007-02-07 10:23 database encryption Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-07 14:35 ` Re: database encryption Andrew Sullivan <ajs@crankycanuck.ca>
2007-02-08 08:13 ` Re: database encryption Olivier Boissard <olivier.boissard@cerene.fr>
@ 2007-02-08 11:52 ` Michael Fuhr <mike@fuhr.org>
2007-02-08 14:30 ` Re: database encryption Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 10+ messages in thread
From: Michael Fuhr @ 2007-02-08 11:52 UTC (permalink / raw)
To: Olivier Boissard <olivier.boissard@cerene.fr>; +Cc: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-admin
On Thu, Feb 08, 2007 at 09:13:48AM +0100, Olivier Boissard wrote:
> I was thinking about a system in which only the php programs will be
> able to manage stored informations. In case of theft or unexpected
> access to servers nobody could be able to retrieve the stored data
> without the authorized key.
What about theft or compromise of the server running the PHP code?
In general it's a good idea to encrypt and decrypt as close to where
the cleartext is needed to limit exposure, but you should also
consider the vulnerability of the system that holds the key. For
some applications it might make sense to use public-key encryption
with the exposed (e.g., Internet-facing) server having only the
public (encryption) key and a more protected backend server having
the corresponding private (decryption) key.
Without knowing the requirements and the threat model it's impossible
to suggest a suitable solution. Can you be more specific about what
you're trying to do?
--
Michael Fuhr
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: database encryption
2007-02-07 10:23 database encryption Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-07 14:35 ` Re: database encryption Andrew Sullivan <ajs@crankycanuck.ca>
2007-02-08 08:13 ` Re: database encryption Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-08 11:52 ` Re: database encryption Michael Fuhr <mike@fuhr.org>
@ 2007-02-08 14:30 ` Bruce Momjian <bruce@momjian.us>
2007-02-09 08:03 ` Re: database encryption Olivier Boissard <olivier.boissard@cerene.fr>
0 siblings, 1 reply; 10+ messages in thread
From: Bruce Momjian @ 2007-02-08 14:30 UTC (permalink / raw)
To: Michael Fuhr <mike@fuhr.org>; +Cc: Olivier Boissard <olivier.boissard@cerene.fr>; Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-admin
Michael Fuhr wrote:
> On Thu, Feb 08, 2007 at 09:13:48AM +0100, Olivier Boissard wrote:
> > I was thinking about a system in which only the php programs will be
> > able to manage stored informations. In case of theft or unexpected
> > access to servers nobody could be able to retrieve the stored data
> > without the authorized key.
>
> What about theft or compromise of the server running the PHP code?
> In general it's a good idea to encrypt and decrypt as close to where
> the cleartext is needed to limit exposure, but you should also
> consider the vulnerability of the system that holds the key. For
> some applications it might make sense to use public-key encryption
> with the exposed (e.g., Internet-facing) server having only the
> public (encryption) key and a more protected backend server having
> the corresponding private (decryption) key.
>
> Without knowing the requirements and the threat model it's impossible
> to suggest a suitable solution. Can you be more specific about what
> you're trying to do?
We do have an encryption section in our documentation:
http://www.postgresql.org/docs/8.2/static/encryption-options.html
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: database encryption
2007-02-07 10:23 database encryption Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-07 14:35 ` Re: database encryption Andrew Sullivan <ajs@crankycanuck.ca>
2007-02-08 08:13 ` Re: database encryption Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-08 11:52 ` Re: database encryption Michael Fuhr <mike@fuhr.org>
2007-02-08 14:30 ` Re: database encryption Bruce Momjian <bruce@momjian.us>
@ 2007-02-09 08:03 ` Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-09 16:28 ` Re: database encryption Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 10+ messages in thread
From: Olivier Boissard @ 2007-02-09 08:03 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Michael Fuhr <mike@fuhr.org>; Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-admin
Bruce Momjian a écrit :
> Michael Fuhr wrote:
>
>> On Thu, Feb 08, 2007 at 09:13:48AM +0100, Olivier Boissard wrote:
>>
>>> I was thinking about a system in which only the php programs will be
>>> able to manage stored informations. In case of theft or unexpected
>>> access to servers nobody could be able to retrieve the stored data
>>> without the authorized key.
>>>
>> What about theft or compromise of the server running the PHP code?
>> In general it's a good idea to encrypt and decrypt as close to where
>> the cleartext is needed to limit exposure, but you should also
>> consider the vulnerability of the system that holds the key. For
>> some applications it might make sense to use public-key encryption
>> with the exposed (e.g., Internet-facing) server having only the
>> public (encryption) key and a more protected backend server having
>> the corresponding private (decryption) key.
>>
>> Without knowing the requirements and the threat model it's impossible
>> to suggest a suitable solution. Can you be more specific about what
>> you're trying to do?
>>
>
> We do have an encryption section in our documentation:
>
> http://www.postgresql.org/docs/8.2/static/encryption-options.html
>
>
>
Thanks for responses.
I expose the context of my question :
I need to install a server for a specific web application written in PHP.
This one works by making queries to a postgresql database. The database
contains confidential data.
For several reasons the server will be installed inside the Local
network of our client. I will not be able to supervise and control it.
As it's a fussy situation I am thinking about encryption.
I was thinking about PHP encryption solution (Zend or Ioncube) for the
web application protection.
But sensitive data must be protected too.
Pgcrypto seemed to be the encryption solution but I am not sure it's a
good idea because all keys will be located on server ( if I have well
understood) and the documention explain that the data will appear on
"clear text" for a short period.
Olivier
Attachments:
olivier.boissard.vcf (text/x-vcard, 239B) download
begin:vcard
fn:Olivier Boissard
n:Boissard;Olivier
org:Cerene Services
adr:;;3 rue Archimede;La Chapelle Saint Luc;;10000;France
email;internet:olivier.boissard@cerene.fr
tel;work:03.25.74.11.78
tel;fax:03.25.78.39.67
version:2.1
end:vcard
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: database encryption
2007-02-07 10:23 database encryption Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-07 14:35 ` Re: database encryption Andrew Sullivan <ajs@crankycanuck.ca>
2007-02-08 08:13 ` Re: database encryption Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-08 11:52 ` Re: database encryption Michael Fuhr <mike@fuhr.org>
2007-02-08 14:30 ` Re: database encryption Bruce Momjian <bruce@momjian.us>
2007-02-09 08:03 ` Re: database encryption Olivier Boissard <olivier.boissard@cerene.fr>
@ 2007-02-09 16:28 ` Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 10+ messages in thread
From: Bruno Wolff III @ 2007-02-09 16:28 UTC (permalink / raw)
To: Olivier Boissard <olivier.boissard@cerene.fr>; +Cc: Bruce Momjian <bruce@momjian.us>; Michael Fuhr <mike@fuhr.org>; Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-admin
On Fri, Feb 09, 2007 at 09:03:20 +0100,
Olivier Boissard <olivier.boissard@cerene.fr> wrote:
> Thanks for responses.
> I expose the context of my question :
>
> I need to install a server for a specific web application written in PHP.
> This one works by making queries to a postgresql database. The database
> contains confidential data.
Who are you trying to keep this data from? Does this include the client?
Who needs to see the decrypted data? Does the database need to in order
to efficiently do queries? Does the webserver/php server need to or does
it produce output that the end user can download and decrypt on their end?
> For several reasons the server will be installed inside the Local
> network of our client. I will not be able to supervise and control it.
Again, is your client being treated as an opponent? Are you worried about
other threats such as stolen servers or back up tapes?
> As it's a fussy situation I am thinking about encryption.
> I was thinking about PHP encryption solution (Zend or Ioncube) for the
> web application protection.
> But sensitive data must be protected too.
Again, from who?
> Pgcrypto seemed to be the encryption solution but I am not sure it's a
> good idea because all keys will be located on server ( if I have well
> understood) and the documention explain that the data will appear on
> "clear text" for a short period.
Whether or not that is a problem depends on what kind of attacks you are
trying to protect against. If you are trying to protect against the case
where the db server gets owned, having the keys on the server will make them
available to the attacker.
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2007-02-09 16:28 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-06-17 18:18 Database Encryption JR Richards <jr@ebcrp.org>
2003-06-19 14:11 ` Jonathan Gardner <jgardner@jonathangardner.net>
2003-06-19 17:22 ` Ragnar <postgres@ragnark.vestdata.no>
2007-02-07 10:23 database encryption Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-07 14:35 ` Re: database encryption Andrew Sullivan <ajs@crankycanuck.ca>
2007-02-08 08:13 ` Re: database encryption Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-08 11:52 ` Re: database encryption Michael Fuhr <mike@fuhr.org>
2007-02-08 14:30 ` Re: database encryption Bruce Momjian <bruce@momjian.us>
2007-02-09 08:03 ` Re: database encryption Olivier Boissard <olivier.boissard@cerene.fr>
2007-02-09 16:28 ` Re: database encryption Bruno Wolff III <bruno@wolff.to>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox