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@tishler.net>
To: "George Weaver" <georgew1@mts.net>
Cc: <pgsql-cygwin@postgresql.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
>