Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
X-Authentication-Warning: slinky.cs.nyu.edu: pechtcha owned process doing -bs
Date: Mon, 25 Aug 2003 13:51:24 -0400 (EDT)
From: Igor Pechtchanski <pechtcha AT cs DOT nyu DOT edu>
Reply-To: cygwin AT cygwin DOT com
To: Jason Tishler <jason AT tishler DOT net>
cc: cygwin AT cygwin DOT com
Subject: Re: postgres help
In-Reply-To: <3F4A4323.1000308@mitre.org>
Message-ID: <Pine.GSO.4.56.0308251342130.601@slinky.cs.nyu.edu>
References: <3F46A361 DOT 7090603 AT mitre DOT org> <20030824210706 DOT GO1676 AT tishler DOT net>
 <3F4A2BAB DOT 5060404 AT mitre DOT org> <20030825155443 DOT GC2088 AT tishler DOT net>
 <3F4A4323 DOT 1000308 AT mitre DOT org>
Importance: Normal
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Umm, Jason (Tishler), you might want to change the service management
section in the docs to use "cygrunsrv -S", "cygrunsrv -E" and "cygrunsrv
-Q" (for query).  These work just as well as "net start" and "net stop",
and cygrunsrv has an additional benefit of being pty-aware, so it should
always produce output in a remote session.  BTW, I don't know of a "net"
equivalent to "cygrunsrv -Q" for querying the status of a service.
	Igor

On Mon, 25 Aug 2003, Jason House wrote:

> Thanks for the help everyone (Jason, Igor and Jonathan)
>
> #2 did solve the problem.  I have also upgraded the cygwin version to
> 1.5 which was probably another problem.
>
> Now all I have to do is figure out how to use postgres ;)
>
> Some recommended doc improvements (to prevent questions from people like
> me... even though the doc already contains all the needed information)
> - for the "net start postmaster" command for NT/XP, it might be nice
> mention that "net start" and the services applet can give false
> positives to the postmaster process starting successfully.  in the
> applet, a manual refresh will reveal that it hasn't really been
> "started".  From the command line "net stop postmaster" will give an
> error if it truly didn't start up...
> - Mention the uname command in comment 14 as a way to check the cygwin
> version.  I know that I *should* have remembered this...
> - cross referencing bugs to individual commands would also be nice
>
> Jason Tishler wrote:
> > Jason,
> >
> > On Mon, Aug 25, 2003 at 11:30:51AM -0400, Jason House wrote:
> >
> >>JHOUSE AT MM112379-2K ~
> >>$ cat /var/log/postmaster.log
> >>IpcSemaphoreInitialize: semctl(id=2, 0, SETVAL, 0) failed: Invalid argument
> >>LOG:  startup process (pid 2548) exited with exit code 1
> >>LOG:  aborting startup due to startup process failure
> >
> >
> > The above indicates that postmaster did not start up.  I have seen
> > reports of the above error message before.  Unfortunately, I have not
> > received definitive confirmation of a solution.
> >
> > Does the following from the README help?
> >
> >     2. It is recommended to delete all cygipc temporary files
> >     (/tmp/cygipc* and /tmp/MultiFile*) before starting postmaster under
> >     a different user account.  Otherwise, postmaster will fail to start
> >     due to IPC errors.  Note cygipc 2.x automatically removes these
> >     files during normal shutdown so this issue has been essentially
> >     obviated.
> >
> > What PostgreSQL and cygipc versions are you running?
> >
> > Jason

-- 
				http://cs.nyu.edu/~pechtcha/
      |\      _,,,---,,_		pechtcha AT cs DOT nyu DOT edu
ZZZzz /,`.-'`'    -.  ;-;;,_		igor AT watson DOT ibm DOT com
     |,4-  ) )-,_. ,\ (  `'-'		Igor Pechtchanski, Ph.D.
    '---''(_/--'  `-'\_) fL	a.k.a JaguaR-R-R-r-r-r-.-.-.  Meow!

"I have since come to realize that being between your mentor and his route
to the bathroom is a major career booster."  -- Patrick Naughton

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/