Re: can't start postmaster as service

This is the exact behavior I'm seeing, using 7.3.2. I followed the
steps in the README for installing everything, with the exception of the
data directory, which is slightly different. My data dir does show up
as
drwx------+ 2 postgres None 0 Mar 4 19:00 pgdata
So, I'm guessing that it's not a permissions issue. I'm able to start
postmaster from the command line as the postgres user. The service just
fails to start, giving error 1062. As you noted below, this is not
good. Is there a known cause for this error and (hopefully) a solution?

Andy

-----Original Message-----
From: pgsql-cygwin-owner(at)postgresql(dot)org
[mailto:pgsql-cygwin-owner(at)postgresql(dot)org] On Behalf Of Jason Tishler
Sent: Friday, February 14, 2003 5:55 AM
To: Christian Strobl
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] can't start postmaster as service

Christian,

On Thu, Feb 13, 2003 at 07:58:51PM +0100, Christian Strobl wrote:
> i wanted to start postgres at win2000 as service with
> the following commands:
>
> 1) cygrunsrv --install postmaster --path
> /usr/bin/postmaster --args "-
>
> 2)cygrunsrv -S ipc-daemon
>
> 3) D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT
> --user postgres --shutdown
>
> 4) cygrunsrv -S postmaster

I hope that you really executed the following:

$ 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
$ cygrunsrv -S ipc-daemon # actually this step is optional
$ cygrunsrv -S postmaster

> BUT at the last command i get the follwing error-message:
> cygrunsrv: Error starting a service:
> QueryServiceStatus: Win32 error 1062:

Note the following:

$ fgrep 1062 /usr/include/w32api/winerror.h
#define ERROR_SERVICE_NOT_ACTIVE 1062L

which is not good. :.)

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html