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.
