Good question! Yet I suspect if it were a permissions issue the service would not first start and then stop. I would expect some kind of request denied message. Still, I won't throw out any possibilities at this point. With the XP Home version I'm not sure how I would find out. The account has admin privileges but I don't know how I would get more detailed info about what that includes. (I knew how to do it on NT but this XP is more automated, and I don't know how to get behind the curtain) So, do you know how
As I write this, I re-installed the IPC daemon as a service to see how I might get more details about the error message, and now it works! I don't know if it makes a difference that this time I installed it from the Cygwin prompt rather than from a batch file.
But now the problem has shifted. Now when I try to start the postmaster service, it returns a system error 1069: "The service did not start due to a logon error." I am logged on as "postgres" (an admin account) and in the Service Manager it shows "Log on as .\postgres" so I'm not sure where the problem comes from. Any ideas.
Does the postgres local user account have permission to start and stop services
I'm running on Windows XP Home version, using Cygwin 1.3.14-1, PostgreSQL 7.2.3, and the ipc-daemon in Cygipc 1.11-1. I have followed the instructions in usr/doc/Cygwin/postgresql-7.2.3.README. I put it into a small script file that looks like:
ipc-daemon --install-as-service
cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user postgres --shutdown
mkdir /usr/share/postgresql/data
chown postgres /usr/share/postgresql/data
initdb -D /usr/share/postgresql/data
net start ipc-daemon
net start postmaster
Yet when the script gets to "net start ipc-daemon" I get the message:
The Cygwin IPC Daemon service is starting.
The Cygwin IPC Daemon service could not be started.
So, of course, the postmaster service also failed. When I tried going through the Service Manager to start ipc-daemon, it said the service on Local System "started then stopped" and suggested "Some services stop automatically if they have no work to do"
Can anyone suggest what I might be doing wrong?
Dave
