Re: How to lose transaction history (xmin values, WAL, etc.)? - Mailing list pgsql-general

From Richard Walker
Subject Re: How to lose transaction history (xmin values, WAL, etc.)?
Date
Msg-id 4BF5DBFD.2090009@softimp.com.au
Whole thread Raw
In response to Re: How to lose transaction history (xmin values, WAL, etc.)?  (Peter Hunsberger <peter.hunsberger@gmail.com>)
Responses Re: How to lose transaction history (xmin values, WAL, etc.)?  (Peter Hunsberger <peter.hunsberger@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Ketema Harris
Date:
Subject: Re: [PHP] Some undefined function errors
Next
From: Richard Walker
Date:
Subject: Re: How to lose transaction history (xmin values, WAL, etc.)?