Re: PostgreSQL 7.3.2 running as NT service under Windows XP

Frank,

Sorry for the sluggish response time...

On Sat, May 24, 2003 at 12:07:10AM +0200, Frank Seesink wrote:
> Jason Tishler wrote:
> > Most likely yes.

> Now the big $64K question: Why? :-)

Looking at the following Cygwin DLL code:

static BOOL WINAPI
ctrl_c_handler (DWORD type)
{
if (type == CTRL_LOGOFF_EVENT)
return TRUE;

/* Return FALSE to prevent an "End task" dialog box from appearing
for each Cygwin process window that's open when the computer
is shut down or console window is closed. */
***>if (type == CTRL_SHUTDOWN_EVENT)
***> {
***> sig_send (NULL, SIGTERM);
***> return FALSE;
***> }
if (type == CTRL_CLOSE_EVENT)
{
sig_send (NULL, SIGHUP);
return FALSE;
}
...
}

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?

> > Why not wrap postmaster in a shell script,
> > /usr/local/bin/postmaster.sh?
> >
> > #!/bin/sh
> > rm -f /usr/share/postgresql/data/postmaster.pid
> > /usr/bin/postmaster $*
> >
> > And then install postmaster.sh as the "service".
>
> Uh...I think this would fall under the category of "BAD Idea",
> wouldn't it? I mean, the whole point of postmaster.pid is to prevent
> MULTIPLE copies of postmaster from firing up against the same data
> set. All I want to do is make sure no such file exists on startup,
> and ONLY on startup. The above defeats the purpose by deleting it
> regardless.

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.
2. The script was a starting point *not* the the final version.
One could add something like the following check:

pg_ctl -D /usr/share/postgresql/data status
if [ $? -eq 0 ]
then
exit 1
fi
...

> > I can only recommend checking the log file. Even without the
> > timestamps, you should be able to figure out if PostgreSQL shut and
> > started up cleanly. You can always start with a fresh log file to
> > facilitate the analysis.
>
> I've done that. Still not much use. PostgreSQL isn't very verbose in
> its logging.

Did you add "-d 5" to the postmaster options? Maybe this will give you
a better idea of how far postmaster is getting in its shutdown process.
Another option is the hack postmaster to log with timestamps...

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