chmod a+rx /usr/share/postgresql/data
net start postmaster
//Postmaster starts ok. Again, needed chmod's.
This is probably very, very wrong, bad, whatever from a security point of view, but of course, I do not know just what the correct rights should be!. I would have thought that now, it should be possible, to gradually reduce the directory rights until it fails? I reckon that doing so might reveal a 'cast iron' solution to the problems folks seem to have on this platform. I would like somebodys comments on this before I try and would prefer them correct once and for all.
Any way, tis running 'for now'.
//-------------------
I only noticed this since your e-mail and tried making the changes that follow. It dont think it made the 'real' difference to the postmaster starting problem, because I realise that I had already set the user and password manually from the services window anyway.
I noticed:-
cygrunsrv --help
....
....
-w, --passwd <password> Optional password for user. Only needed
if a user is given. If a user has an empty
password, enter `-w '. If a user is given but
no password, cygrunsrv will ask for a password
interactively.
In the readme, there is no argument shown in the line, for either -w or --passwd. (I had a password set on the postgres account, so cygrunsrv essentially ignored the credentials altogether, just did not fail or warn). I think that it 'loads' the services window logon values from these? If either user or password is missing then it leaves them as Local system Account, so, ideally the line needs to be amended to show:-
cygrunsrv --install postmaster ... ... --user postgresql --passwd $password ... ....
That also remains consistent with step 2 and footnote [11]. Alternatively, the advice that these must be set explicitly and neither argument be shown in the line.
//--------------------------------------
Thanks for your help. I now of course, would like to know what correct running permissions should be. Maybe Seth could check what his permissions are set at and let me know.
Regards
Roger
