Re: PostgreSQL 7.3.2 running as NT service under Windows XP

Frank,

On Wed, May 28, 2003 at 06:26:59PM -0400, Frank Seesink wrote:
> Jason Tishler wrote:
> >I'm concerned that the Cygwin DLL is actually sending a SIGTERM to
> >the postmaster even though cygrunsrv is going to send a SIGINT too.
> >Does the postmaster log indicate a "smart shutdown" or "fast
> >shutdown" when the pid file is not deleted?
>
> I did the following:
>
> [snip]
>
> The following is the contents of /var/log/postmaster.log:
> ____________________________________________________________
> [snip]
> LOG: smart shutdown request
> LOG: shutting down
> LOG: fast shutdown request
> [snip]
> ____________________________________________________________
>
> From the above, it appears that PostgreSQL first receives a "smart
> shutdown request", followed by a "fast shutdown request". Are we
> getting closer? :-)

Yes! I can reproduce the problem under 2000 too. But, for some reason,
my database still shuts down cleanly.

Anyway, I tried to solve this in cygrunsrv but I was unsuccessful (which
is obvious in hindsight). I will work with the Cygwin developers to try
to solve this in the Cygwin DLL. I will report back when I have status.

> >I would call the above "quick and dirty". I wasn't clear but I
> >assumed the following:
> >
> > 1. It would only be invoked via net start which will prevent
> > multiple instances.
>
> Actually, I understand what you mean, but technically, no this is not
> true. If I do a 'net start postmaster' from the command line when a
> copy is already running, this script will delete postmaster.pid and
> fire up a 2nd copy.

I just tried my hack and it worked as advertised:

$ echo (</proc/registry/HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/postmaster/Parameters/AppPath)
/usr/local/bin/postmaster.sh
$ cat /usr/local/bin/postmaster.sh
#!/bin/sh
rm -f /usr/share/postgresql/data/postmaster.pid
/usr/bin/postmaster $*

$ net start | fgrep postmaster
postmaster
$ net start postmaster
The requested service has already been started.

More help is available by typing NET HELPMSG 2182.

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