Re: Trouble with Cygrunsrv

Hi Jason,

Thanks for you ideas - you did provide a tip (see below) which is helping
zero in on the problem.

I think I'm making progress, although I have not solved the problem yet.

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".

I have run cygrunsrv configured as follows:

"cygrunsrv --install postmaster --path /bin/postmaster --a "'-D
/bin/data' -i" --dep ipc-daemon --termsig INT --shutdown"

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."

Thus it appears that Postmaster is trying to start but for some reason is
troubled by the location of the database.

I have tried every "-D" configuration I can think of without success.
PG_Version is in c:\cygwin\bin\data\ and I have not trouble starting with
pg_ctl.

Any thoughts? Anyone?

I really appreciate the help.

George

----- Original Message -----
From: "Jason Tishler" <jason(at)tishler(dot)net>
To: "George Weaver" <georgew1(at)mts(dot)net>
Cc: <pgsql-cygwin(at)postgresql(dot)org>
Sent: Friday, January 10, 2003 3:28 PM
Subject: Re: [CYGWIN] Trouble with Cygrunsrv

> George,
>
> On Fri, Jan 10, 2003 at 11:25:24AM -0600, George Weaver wrote:
> > XP Home.
>
> Argh! XP Home has caused at least some people on the list to have
> problems running PostgreSQL as a service. I don't have access to XP
> Home. So I, can't really help if it is different than NT/2000 in this
> regard.
>
> > Is the next post you referred to the one referring to PostgreSQL
7.3.1.1?
>
> Sorry, for being ambiguous. I meant the attached.
>
> 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 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>