Brady, 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. > > moving data and subfolder on NTFS is a Level-20 operation. The usual cases for PostgreSQL-Service not starting ar:
a) user account has wrong privileges b) user account has lost "Logon as Service" c) password of user account was changed / invalidate by some system policy / administrator d) user account which the PostgreSQL service logs on with is not able to acces the data-directories. d) is usually anaylizable via the system eventviewer. Most likely cause during your copy operation: the permission on the directories where changed. OR: the link to the Data-directory (part of the service-configuration) within services.msc is no longer valid (as in: data in different place) I can confirm that is possible to have a database on a TrueCrypt encrypted volume. It is dog slow. My impression is that data from that encypted volume is not really cached. Harald > Has anyone implemented something like this for PG in Windows? > > Thanks! > Brady > > -- > Brady Mathis | bmat...@r-hsoftware.com | 877.696.6547 ext 102 > -- GHUM GmbH Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 Amtsgericht Stuttgart, HRB 734971 - persuadere. et programmare
