Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

John,

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.