> > Peter Eisentraut <peter_e@gmx.net> writes:
> > > 	The connection was terminated.

	The connection has been terminated.      ??

> > > And make the postmaster print out
> > > 	The system is shutting down.
> > > before it sends out the SIGTERM's.

I like above. Imho it is sufficient if postmaster writes the "The system is shutting down."
to the log. Clients get the other message. That is how I interpreted Peter's message also.

Andreas

Wed, 14 Mar 2001 09:08:50 +0100
Zeugswetter Andreas SB  <ZeugswetterA@wien.spardat.at>
AW: Shutdown term
[ Charset ISO-8859-1 unsupported, converting... ]
> > > Peter Eisentraut <peter_e@gmx.net> writes:
> > > > 	The connection was terminated.
> 
> 	The connection has been terminated.      ??
> 
> > > > And make the postmaster print out
> > > > 	The system is shutting down.
> > > > before it sends out the SIGTERM's.
> 
> I like above. Imho it is sufficient if postmaster writes the "The system is shutting down."
> to the log. Clients get the other message. That is how I interpreted Peter's message also.

OK, I phoned Tom and we agreed on this wording:

	This connection has been terminated by the administrator

Comments?

-- 
  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

Wed, 14 Mar 2001 10:13:52 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: AW: Shutdown term

>OK, I phoned Tom and we agreed on this wording:
>
>         This connection has been terminated by the administrator
>
>Comments?

This connection has been terminated by an administrator
(there may be more than one...) :)

Other than that it's informative enough.

OTOH, I had a small thought on this.

If you had a messaging scheme to print to clients when a signal was 
received, is there the possibility of more informative messages perhaps 
that could be sent by the pg_ctl program through the postmaster (or 
backends) on shutdowns?   This would allow for some decent scripting.  For 
example, the database is shutdown without the system going down or the 
whole system is going down for maintenance or scheduled reboot.

It may seem stupid but I was thinking the reason could be an argument to 
the pg_ctl program with a default of (Database Shutdown).

pg_ctl stop --message="System going down for a reboot"
or
pg_ctl stop -msg "System upgrade. System will be available again at 5:00am"

The client would receive
The connection has been terminated
[System Shutdown|Database Shutdown|Unknown Reason|"some string as an argument"]

Also, it allows for more informative messages.
         Scheduled downtime (System will be online again at {whenever})
         Idle Timeout
         You are using too much CPU...
         You are using too little CPU...

These message can be set by the scripts for "run level" changes and the like.




Wed, 14 Mar 2001 10:44:00 -0600
Thomas Swan <tswan-lst@ics.olemiss.edu>
Re: AW: Shutdown term
Thomas Swan writes:

> It may seem stupid but I was thinking the reason could be an argument to
> the pg_ctl program with a default of (Database Shutdown).
>
> pg_ctl stop --message="System going down for a reboot"
> or
> pg_ctl stop -msg "System upgrade. System will be available again at 5:00am"

I foresee a PQmotd(PGconn *) function ... ;-)

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


Wed, 14 Mar 2001 18:13:32 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: AW: Shutdown term
At 3/14/2001 11:13 AM, Peter Eisentraut wrote:
>Thomas Swan writes:
>
> > It may seem stupid but I was thinking the reason could be an argument to
> > the pg_ctl program with a default of (Database Shutdown).
> >
> > pg_ctl stop --message="System going down for a reboot"
> > or
> > pg_ctl stop -msg "System upgrade. System will be available again at 5:00am"
>
>I foresee a PQmotd(PGconn *) function ... ;-)

Well, I also thought you could use the same method to do a warning.

pg_ctl --message="Database going offline in 5 minutes"

or something along those lines...


Wed, 14 Mar 2001 12:30:59 -0600
Thomas Swan <tswan@ics.olemiss.edu>
Re: AW: Shutdown term