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!