Re: Trouble with Cygrunsrv

George,

On Fri, Jan 10, 2003 at 04:00:32PM -0600, George Weaver wrote:
> Thanks for you ideas - you did provide a tip (see below) which is
> helping zero in on the problem.

You are welcome.

> The PostgreSQL database that I have been using (starting up postmaster
> with pg_ctl) is located in "C:\cygwin\bin\data".  Everything works
> perfectly when I start postmaster with pg_ctl.  I have the environment
> variable PGDATA set to "data".

BTW, /bin/data is a strange place for the PostgreSQL data directory.

> I have run cygrunsrv configured as follows:
>
> "cygrunsrv --install postmaster --path /bin/postmaster --a "'-D /bin/data' -i" --dep ipc-daemon --termsig INT
--shutdown"

The above runs postmaster under the LocalSystem account which is *not*
recommended.  You should use the cygrunsrv "--user" option to specify a
different user (e.g., postgres).

> Cygrunsrv configured as above installs the service.  When I try to
> start the service I get:
>
> "C:\cygwin\bin>net start postmaster
> The postmaster service is starting.
> The postmaster service could not be started."
>
> In \var\log\postmaster.log  (Thanks for the TIP!!) I find:
>
> "FATAL 1:  File  /bin/data/PG_VERSION is missing. This is not a valid data directory."

What user ran initdb?  It *must* be the same user that owns the
postmaster process.

Of course, you may have different problems caused by XP Home...

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