Postgres Pro
Downloads
Home   >   mailing lists

Thread: AW: Shutdown term

AW: Shutdown term

From
Zeugswetter Andreas SB
Date:
> > 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

Re: AW: Shutdown term

From
Bruce Momjian
Date:
[ 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,
Pennsylvania19026

Re: AW: Shutdown term

From
Thomas Swan
Date:
>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.

Re: AW: Shutdown term

From
Peter Eisentraut
Date:
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/

Re: AW: Shutdown term

From
Thomas Swan
Date:
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...