Mailing-List: contact cygwin-help AT sourceware DOT cygnus DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT sources DOT redhat DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT sources DOT redhat DOT com>
List-Help: <mailto:cygwin-help AT sources DOT redhat DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT sources DOT redhat DOT com
Delivered-To: mailing list cygwin AT sources DOT redhat DOT com
From: fred AT ontosys DOT com
Date: Wed, 31 Oct 2001 07:21:38 -0600
Cc: cygwin AT cygwin DOT com
Subject: Re: cygrunsrv and postgresql
Message-ID: <20011031072138.A22250@ontosys.com>
References: <Pine DOT LNX DOT 4 DOT 33 DOT 0110311329010 DOT 14818-100000 AT tuomi DOT oulu DOT fi> <20011031130745 DOT B1126 AT ping DOT be>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
In-Reply-To: <20011031130745.B1126@ping.be>; from Q@ping.be on Wed, Oct 31, 2001 at 01:07:45PM +0100

On Wed, Oct 31, 2001 at 01:07:45PM +0100, Kurt Roeckx wrote:
> You probably have a stale pid file.  It's something very
> annoying when you don't do a proper shutdown, and don't have
> proper startup scripts.  I'm still looking for a good solution to
> this.

This is indeed an annoying problem.  I wonder if we should add
yet-another feature to cygrunsrv, causing it to execute a
specified bash command before starting the service.  This command
could perform necessary pre-start cleanup, such as removing the PID
file, either directly or by calling a script to do the work.

[All this really makes one appreciate the simplicity of Unix-style
/etc/init.d start/stop scripts.]

Anyway, just to elaborate on the prior message, the "stale pid" file
is the "postmaster.pid" file kept in the $PGDATA folder.  In my case
it's typically named "/var/pgsql/data/postmaster.pid".

> It might also help if you tell it to use a log file, redirect
> stdout (and stderr?) to some file, and it should also give a clue why
> postmaster refuses to start.

Cygrunsrv arranges to log stdout and stderr by default, appending to
"/var/log/$service_name.log".

-- 
Fred Yankowski           fred AT OntoSys DOT com      tel: +1.630.879.1312
Principal Consultant     www.OntoSys.com       fax: +1.630.879.1370
OntoSys, Inc             38W242 Deerpath Rd, Batavia, IL 60510, USA

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/