From: | Jason Tishler <jason(at)tishler(dot)net> |
---|---|
To: | George Weaver <georgew1(at)mts(dot)net> |
Cc: | pgsql-cygwin(at)postgresql(dot)org |
Subject: | Re: Trouble with Cygrunsrv |
Date: | 2003-01-13 21:03:01 |
Message-ID: | 20030113210301.GI1012@tishler.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David P. Caldwell | 2003-01-13 21:13:29 | Re: Another XP Pro experience |
Previous Message | Jason Tishler | 2003-01-13 20:54:21 | Re: Another XP Pro experience |