The permissions! Of course! Thanks, you fixed me.
Brady
--
Brady Mathis | bmathis@xxxxxxxxxxxxxxx | 877.696.6547 ext 102
On Wed, Dec 8, 2010 at 6:18 AM, Massa, Harald Armin <chef@xxxxxxx> wrote:
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 privilegesb) user account has lost "Logon as Service"c) password of user account was changed / invalidate by some system policy / administratord) 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.HaraldHas anyone implemented something like this for PG in Windows?
Thanks!
--
GHUM GmbH
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
Amtsgericht Stuttgart, HRB 734971
-
persuadere.
et programmare
--
Brady Mathis | bmathis@xxxxxxxxxxxxxxx | 877.696.6547 ext 102
