Re: [ANNOUNCEMENT] Updated: cygrunsrv-0.94-1

From: Don Saxton <euphobot(at)pacbell(dot)net>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [ANNOUNCEMENT] Updated: cygrunsrv-0.94-1
Date: 2001-07-19 22:42:54
Message-ID: 010d01c110a4$26fc8990$3225aa40@pacbell.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

The power just returned here which started me thinking about this. To
restart pg I needed to delete the .pid. Is it correct that cygrunsrv
solution will not change that?

I have a applictation on a collection of laptops running NT 5 which are
vulnerable to people pulling the plug and the like. To protect the restart I
was thinking about a startup .bat to delete the .pid. Is this still
necessary?

----- Original Message -----
From: "Fred Yankowski" <fred(at)ontosys(dot)com>
Newsgroups: comp.databases.postgresql.ports.cygwin
Sent: Thursday, July 19, 2001 8:54 AM
Subject: Re: [ANNOUNCEMENT] Updated: cygrunsrv-0.94-1

> On Wed, Jul 18, 2001 at 03:11:42PM -0400, Jason Tishler wrote:
> > I appear to have empirical evidence that indicates that PostgreSQL
> > can tolerate receiving SIGTERM and/or SIGINT during an NT shutdown.
> ...
> > Note that this seems to
> > indicate that a Fast Shutdown can interrupt and supersede a Smart one.
> > Message [4] indicates that PostgreSQL was able to restart without any
> > manual intervention.
>
> Excellent! Your experimental results trump my hunch, big time.
>
> > Should I submit the attached patch (with ChangeLog) to cygwin-patches
> > for consideration?
>
> Yes, please. This patch would seem to provide the last piece needed
> (along with cygrunsrv) to make PostgreSQL robust as an NT/Win2000
> service. And with no changes whatsoever to PostgreSQL code -- bonus!
>
> --
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Jason Tishler 2001-07-22 01:23:57 Re: Leaking Handles in Postgres 7.1.2 on Cygwin dll 1.3.2 on Win 2000 SP1
Previous Message Fred Yankowski 2001-07-19 15:26:15 Re: [ANNOUNCEMENT] Updated: cygrunsrv-0.94-1