I have noticed that postgres is very unhappy if the proper "postgres" user doesn't have access to the files. But I have also noticed that other users seem to be able to have access without causing problems.
can you please give more information about the (windows)-user "postgres" ? is it a local user on that machine? How was that user created?
Are there any group-policies or similar, or "security-applications" present, which can change the rights of this user postgres? (Or, can change the access-properties of files on the system?)
Your sentenceabout "postgres being unhappy when not having access to the files" makes me curious how you did learn that --- was somebody / something taking file access away from Postgres? Could that somebody / something still be active?
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
Using PostgreSQL is mostly about sleeping well at night.
