Re: Humor me: Postgresql vs. MySql (esp. licensing) - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Humor me: Postgresql vs. MySql (esp. licensing)
Date
Msg-id 200311211542.hALFgGC21387@candle.pha.pa.us
Whole thread Raw
In response to Re: Humor me: Postgresql vs. MySql (esp. licensing)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Humor me: Postgresql vs. MySql (esp. licensing)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Alex Satrapa <alex@lintelsys.com.au> writes:
> > On Mac OS X (desktop version, at least) there are no shutdown scripts.
> > All running applications are simply sent the "TERM" signal, then later
> > sent the "KILL" signal. Luckily enough, PostgreSQL seems to respond to
> > TERM by shutting down gracefully.
>
> No "luckily" about it: that's been the standard shutdown procedure for
> Unix systems since approximately forever, and the signal responses of
> the Postgres backend were consciously chosen to behave well with it.
>
> > Totally off topic, but this lack of shutdown scripts, along with a lack
> > of proper package management are the two most painful faults in Mac OS X.
>
> I dunno whether OS X is lacking in shutdown scripts or not --- but PG
> is built to shut down cleanly on any moderately-standard Unix system,
> whether you have a shutdown script for it or not.  OS X is certainly
> standard enough for this.

The one problem with the signal approach is how long does the system
wait before giving up on the app shutdown?  Seems that should be
something controllable by the admin, but without shutdown scripts, it
isn't.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: linking postgre to AD
Next
From: Robert Treat
Date:
Subject: Re: Postgresql vs. MySql - need feature matrix for