Re: How to lose transaction history (xmin values, WAL, etc.)?

From: Richard Walker <richard(at)softimp(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to lose transaction history (xmin values, WAL, etc.)?
Date: 2010-05-21 01:03:57
Message-ID: 4BF5DBFD.2090009@softimp.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Hunsberger wrote:
> If you really need security of some form at the physical database
> level then don't screw around with convoluted hacks. Encrypt the
> critical data in the database and be done with it.

If the hacker gets root access so they can read
the raw database files, they most likely also
have access to the means to decrypt any
encrypted data. This is particularly so if
the database updates are being done by stored
procedures.

If encryption/decryption happens
on a separate (not-also-compromised) client,
then OK. Do you know of a way to deal with
this if the application is on the same computer
as the database?

--
Richard Walker
Software Improvements Pty Ltd
Phone: +61 2 6273 2055
Fax: +61 2 6273 2082

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Walker 2010-05-21 01:11:00 Re: How to lose transaction history (xmin values, WAL, etc.)?
Previous Message Ketema Harris 2010-05-20 23:57:09 Re: [PHP] Some undefined function errors