Re: database encryption

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