pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database 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