Date: Wed, 25 Apr 2007 22:52:49 -0400
From: Bill Moran <wmoran@potentialtech.com>
To: Ron Mayer <rm_pg@cheapcomplexdevices.com>
Cc: Carlos Moreno <moreno_pg@mochima.com>, pgsql-general@postgresql.org
Subject: Re: Feature request - have postgresql log warning  when
	new sub-release comes out.
Message-Id: <20070425225249.7ccdfa87.wmoran@potentialtech.com>
In-Reply-To: <462FDBA1.4020800@cheapcomplexdevices.com>
References: <75312DFA648AF74D8A236E5269BFBE4B04292F00@ncrx3.ncr.int.ec.gc.ca>
	<462E2537.2020706@archonet.com>
	<75312DFA648AF74D8A236E5269BFBE4B04292F02@ncrx3.ncr.int.ec.gc.ca>
	<6365.1177438176@sss.pgh.pa.us> <462E7317.2070707@mochima.com>
	<462FDBA1.4020800@cheapcomplexdevices.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

Ron Mayer <rm_pg@cheapcomplexdevices.com> wrote:
>
> Carlos Moreno wrote:
> > Tom Lane wrote:
> >> Well, if you can't update major versions that's understandable; that's
> >> why we're still maintaining the old branches.  But there is no excuse
> >> for not running a reasonably recent sub-release within your branch.
> > 
> > Slammer..bug in Microsucks SQL Server....fix...had been available
> 
> Feature request.
> 
> How about if PostgreSQL periodically check for updates on the
> internet and log WARNINGs as soon as it sees it's not running
> the newest minor version for a branch.   Ideally, it could
> be set so the time-of-day's configurable to avoid setting off
> pagers in the middle of the night.
> 
> I might not lurk on the mailinglists enough to notice every
> dot release; but I sure would notice if pagers went off with
> warnings in the log files from production servers.
> 
> Is that a possible TODO?

If you switch to FreeBSD, you can easily have this done automatically
with existing tools.

...

Actually, I've a feeling that it would be trivial to do with just
about any existing packaging system ...

-- 
Bill Moran
http://www.potentialtech.com