Hello!
Background: Cygwin 1.3.10(0.51/3/2), PostgreSQL 7.2.1
I had been running ipc-daemon and postmaster as NT services for about a
month with no problems. I followed the install instructions provided in the
READMEs with Cygwin, installing postmaster to run as an NT service as the
user 'postgres', and running initdb as Administrator since I can't seem to
switch context to postgres.
As I said this has worked fine for me up until a couple days ago after I
installed Service Pack 3. When the machine came up from rebooting,
postmaster did not start, and in the Application Event Log I had this error:
starting service `postmaster' failed: execv: 1, Not owner.
I was unable to manually start the service or use 'net start postmaster', it
just quit with the same message. I looked on the archives here and saw a
recommendation to change the password of the postgres user and reinstall the
service, but I had the same result. The only way I could get it working was
to reinstall the service to run as 'Administrator' and give him privileges
to logon as a service. I'd rather not attach this to the Administrator
account though.
Does anyone know what I could be doing wrong? I tend to think either the
reboot after SP3 didn't shut down the service gracefully or maybe there was
security update in the service pack that finally enforced the discrepancy in
ownership between the /usr/share/postgresql/data directory (Administrator)
and the service (postgres). Regardless, I would appreciate any help or
advice on this problem!
Thanks in advance,
Brian