Using PG with Windows EFS or TrueCrypt for encryption

From: Brady Mathis <bmathis(at)r-hsoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Using PG with Windows EFS or TrueCrypt for encryption
Date: 2010-12-08 00:19:06
Message-ID: AANLkTi=O3if-WsSK+NS2uuFbLq1zCEiZWnaE2MuhDmEx@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi -

I have searched the lists for comments about using PG with EFS and/or
TrueCrypt in order to encrypt the entire database transparently. I found a
few posts making reference to this possibility so I have tried them both,
but I didn't get either to work.

I have PG-8.3 running on Windows server 2008 (64-bit).

In the first scenario I just used Windows EFS (encrypting file system) to
encrypt the database OID folder in the data\ folder. After I did this, the
PG service started, but I could not access the database in pgAdmin.

Then I attempted to mount a normal encrypted volume with TrueCrypt, move the
data\ and sub-folders to this volume and reconfigure PG to point to this as
the data folder. Now, the PG service will not start at all.

Has anyone implemented something like this for PG in Windows?

Thanks!
Brady

--
Brady Mathis | bmathis(at)r-hsoftware(dot)com | 877.696.6547 ext 102

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Tripathy 2010-12-08 00:56:11 Uncommitted Data
Previous Message Greg Swisher 2010-12-08 00:19:02 pg_standby logging issues