Postgres Pro
Downloads
Home   >   mailing lists

Using PG with Windows EFS or TrueCrypt for encryption - Mailing list pgsql-general

From Brady Mathis
Subject Using PG with Windows EFS or TrueCrypt for encryption
Date
Msg-id AANLkTi=O3if-WsSK+NS2uuFbLq1zCEiZWnaE2MuhDmEx@mail.gmail.com
Whole thread Raw
Responses Re: Using PG with Windows EFS or TrueCrypt for encryption  (Magnus Hagander <magnus@hagander.net>)
Re: Using PG with Windows EFS or TrueCrypt for encryption  ("Massa, Harald Armin" <chef@ghum.de>)
List pgsql-general
Tree view
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@r-hsoftware.com | 877.696.6547 ext 102

pgsql-general by date:

Previous
From: Greg Swisher
Date:
Subject: pg_standby logging issues
Next
From: Jonathan Tripathy
Date:
Subject: Uncommitted Data