Can somone improve the wording?

	The system is shutting down.

when the backend receives a SIGTERM.  Seems we need some wording that
can apply to db shutdown and individual backend termination by
administrators.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 13 Mar 2001 14:15:03 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Shutdown term
Bruce Momjian writes:

> Can somone improve the wording?
>
> 	The system is shutting down.
>
> when the backend receives a SIGTERM.  Seems we need some wording that
> can apply to db shutdown and individual backend termination by
> administrators.

	The connection was terminated.

And make the postmaster print out

	The system is shutting down.

before it sends out the SIGTERM's.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Tue, 13 Mar 2001 20:33:50 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: Shutdown term
Peter Eisentraut <peter_e@gmx.net> writes:
> 	The connection was terminated.
> And make the postmaster print out
> 	The system is shutting down.
> before it sends out the SIGTERM's.

Unfortunately the postmaster is in no position to send any message to
the individual clients.

Maybe we should forget the idea of having a single message to cover
both cases, and instead provide some flag in shared memory that the
postmaster can set before it sends out SIGTERMs.  Then the backends
would actually know why they got a SIGTERM and could emit
more-appropriate messages.

			regards, tom lane

Tue, 13 Mar 2001 15:06:49 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Shutdown term 
> Peter Eisentraut <peter_e@gmx.net> writes:
> > 	The connection was terminated.
> > And make the postmaster print out
> > 	The system is shutting down.
> > before it sends out the SIGTERM's.
> 
> Unfortunately the postmaster is in no position to send any message to
> the individual clients.
> 
> Maybe we should forget the idea of having a single message to cover
> both cases, and instead provide some flag in shared memory that the
> postmaster can set before it sends out SIGTERMs.  Then the backends
> would actually know why they got a SIGTERM and could emit
> more-appropriate messages.

Seems like overkill to me.  We could have the postmaster use SIGQUIT for
db shutdown and leave SIGKILL for admin shutdown of individual backends.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 13 Mar 2001 15:31:36 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Shutdown term
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Seems like overkill to me.  We could have the postmaster use SIGQUIT for
> db shutdown and leave SIGKILL for admin shutdown of individual backends.

Wrong... at least not with the current definitions of those signals!

			regards, tom lane

Tue, 13 Mar 2001 15:34:26 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Shutdown term 
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Seems like overkill to me.  We could have the postmaster use SIGQUIT for
> > db shutdown and leave SIGKILL for admin shutdown of individual backends.
> 
> Wrong... at least not with the current definitions of those signals!

I see you just changed them today:

        pqsignal(SIGTERM, die);         /* cancel current query and exit */
!       pqsignal(SIGQUIT, quickdie); /* hard crash time */
!       pqsignal(SIGALRM, HandleDeadLock); /* check for deadlock after timeout *

How about:

	The database is shutting down.

and not mention server.  The current 'system' has to be changed to
'database server' anyway.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 13 Mar 2001 20:54:42 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Shutdown term