pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedFeature request - have postgresql log warning when new sub-release comes out.
11+ messages / 7 participants
[nested] [flat]
* Feature request - have postgresql log warning when new sub-release comes out.
@ 2007-04-25 22:52 Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-04-25 23:32 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Joshua D. Drake <jd@commandprompt.com>
2007-04-26 02:52 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Bill Moran <wmoran@potentialtech.com>
2007-04-26 19:02 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Leonel <lnunez@gmail.com>
0 siblings, 3 replies; 11+ messages in thread
From: Ron Mayer @ 2007-04-25 22:52 UTC (permalink / raw)
To: Carlos Moreno <moreno_pg@mochima.com>
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?
(The thread started on the performance mailing lists but
I moved it to general since it drifted off topic).
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Feature request - have postgresql log warning when new sub-release comes out.
2007-04-25 22:52 Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
@ 2007-04-25 23:32 ` Joshua D. Drake <jd@commandprompt.com>
2007-04-26 18:38 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
2 siblings, 1 reply; 11+ messages in thread
From: Joshua D. Drake @ 2007-04-25 23:32 UTC (permalink / raw)
To: Ron Mayer <rm_pg@cheapcomplexdevices.com>; +Cc: Carlos Moreno <moreno_pg@mochima.com>; pgsql-general@postgresql.org
Ron Mayer 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.
uhmmm gah, errm no... ehhhh why? :)
I could see a contrib module that was an agent that did that but not as
part of actual core.
Joshua D. Drake
>
> 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?
>
>
>
> (The thread started on the performance mailing lists but
> I moved it to general since it drifted off topic).
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Feature request - have postgresql log warning when new sub-release comes out.
2007-04-25 22:52 Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-04-25 23:32 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Joshua D. Drake <jd@commandprompt.com>
@ 2007-04-26 18:38 ` Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-04-26 19:50 ` Re: Re: Feature request - have postgresql log warning when new sub-release comes out. Ron Johnson <ron.l.johnson@cox.net>
0 siblings, 1 reply; 11+ messages in thread
From: Ron Mayer @ 2007-04-26 18:38 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>
Joshua D. Drake wrote:
> Ron Mayer wrote:
>> 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. ...
>
> uhmmm gah, errm no... ehhhh why? :)
Mostly because it seems like a near FAQ here that someone
posts questions about people running very old postgresqls
where the answers are "that was fixed in the latest minor version".
Regarding people saying that their OS package manager
can do this for them - I note that the people who have
this problem the worst seem to be the people running
older postgresqls, and your OS vendor may not be keeping
the major version number of their postgresql the same
as yours. For example, apt-cache search here isn't showing
me 8.0 (though it does show 7.4, 8.1, and 8.2).
> I could see a contrib module that was an agent that did that but not as
> part of actual core.
I was thinking it would protect the more ignorant users
who didn't even know about contrib. I imagine anyone
who did know enough to install a contrib module would
also know how to write such a script without it.
No big deal, though - if others don't think there's a need, then
I'm not going to push for it.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Re: Feature request - have postgresql log warning when new sub-release comes out.
2007-04-25 22:52 Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-04-25 23:32 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Joshua D. Drake <jd@commandprompt.com>
2007-04-26 18:38 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
@ 2007-04-26 19:50 ` Ron Johnson <ron.l.johnson@cox.net>
0 siblings, 0 replies; 11+ messages in thread
From: Ron Johnson @ 2007-04-26 19:50 UTC (permalink / raw)
To: pgsql-general@postgresql.org
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 04/26/07 13:38, Ron Mayer wrote:
> Joshua D. Drake wrote:
>> Ron Mayer wrote:
>>> 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. ...
>> uhmmm gah, errm no... ehhhh why? :)
>
> Mostly because it seems like a near FAQ here that someone posts
> questions about people running very old postgresqls where the
> answers are "that was fixed in the latest minor version".
>
> Regarding people saying that their OS package manager can do this
> for them - I note that the people who have this problem the worst
> seem to be the people running older postgresqls, and your OS
> vendor may not be keeping the major version number of their
> postgresql the same as yours. For example, apt-cache search
> here isn't showing me 8.0 (though it does show 7.4, 8.1, and
> 8.2).
For example: Debian. It's Stable releases only get *security*
patches, nothing related to features or performance.
>> I could see a contrib module that was an agent that did that
>> but not as part of actual core.
>
> I was thinking it would protect the more ignorant users who
> didn't even know about contrib. I imagine anyone who did know
> enough to install a contrib module would also know how to write
> such a script without it.
>
> No big deal, though - if others don't think there's a need, then
> I'm not going to push for it.
A *tiny* Perl/Python script to parse
http://www.postgresql.org/versions.xml is all you need. Putting it
in cron and emailing when "someone" a version changes seems useful.
Ok, it's official: you're elected to implement it!
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFGMQJ/S9HxQb37XmcRAgUEAKDWKzM8scO7Mc8uB26iqIo8WnJGmwCg6e4w
vRuaSXH0sMhtnNZbYsuDKmc=
=wGYf
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Feature request - have postgresql log warning when new sub-release comes out.
2007-04-25 22:52 Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
@ 2007-04-26 02:52 ` Bill Moran <wmoran@potentialtech.com>
2007-04-26 13:29 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Ron Johnson <ron.l.johnson@cox.net>
2007-04-26 15:10 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Joshua D. Drake <jd@commandprompt.com>
2 siblings, 2 replies; 11+ messages in thread
From: Bill Moran @ 2007-04-26 02:52 UTC (permalink / raw)
To: Ron Mayer <rm_pg@cheapcomplexdevices.com>; +Cc: Carlos Moreno <moreno_pg@mochima.com>; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Feature request - have postgresql log warning when new sub-release comes out.
2007-04-25 22:52 Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-04-26 02:52 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Bill Moran <wmoran@potentialtech.com>
@ 2007-04-26 13:29 ` Ron Johnson <ron.l.johnson@cox.net>
1 sibling, 0 replies; 11+ messages in thread
From: Ron Johnson @ 2007-04-26 13:29 UTC (permalink / raw)
To: pgsql-general@postgresql.org
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 04/25/07 21:52, Bill Moran wrote:
[snip]
>
> 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 ...
Or Debian, the Universal Operating System.
And if you don't want to move up to a good OS, you could always
parse http://www.postgresql.org/versions.xml for the exact
information you need.
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFGMKk1S9HxQb37XmcRAjZAAKCsgXoDofYQJGixA1vV0/IUr0tPjACeJeWR
ZbLeGYpEwiwEZ7Q1ELrqOuU=
=SM1D
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Feature request - have postgresql log warning when new sub-release comes out.
2007-04-25 22:52 Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-04-26 02:52 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Bill Moran <wmoran@potentialtech.com>
@ 2007-04-26 15:10 ` Joshua D. Drake <jd@commandprompt.com>
2007-04-26 16:55 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Leif B. Kristensen <leif@solumslekt.org>
1 sibling, 1 reply; 11+ messages in thread
From: Joshua D. Drake @ 2007-04-26 15:10 UTC (permalink / raw)
To: Bill Moran <wmoran@potentialtech.com>; +Cc: Ron Mayer <rm_pg@cheapcomplexdevices.com>; Carlos Moreno <moreno_pg@mochima.com>; pgsql-general@postgresql.org
>
> Actually, I've a feeling that it would be trivial to do with just
> about any existing packaging system ...
Yes pretty much every version of Linux, and FreeBSD, heck even Solaris
if you are willing to run 8.1.
J
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Feature request - have postgresql log warning when new sub-release comes out.
2007-04-25 22:52 Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-04-26 02:52 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Bill Moran <wmoran@potentialtech.com>
2007-04-26 15:10 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Joshua D. Drake <jd@commandprompt.com>
@ 2007-04-26 16:55 ` Leif B. Kristensen <leif@solumslekt.org>
2007-04-26 18:12 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Jon Sime <jsime@mediamatters.org>
0 siblings, 1 reply; 11+ messages in thread
From: Leif B. Kristensen @ 2007-04-26 16:55 UTC (permalink / raw)
To: pgsql-general@postgresql.org
On Thursday 26. April 2007 17:10, Joshua D. Drake wrote:
>> Actually, I've a feeling that it would be trivial to do with just
>> about any existing packaging system ...
>
>Yes pretty much every version of Linux, and FreeBSD, heck even Solaris
>if you are willing to run 8.1.
Gentoo is still on version 8.1.8, though, and even that is soft-masked
(stable is at 8.0.12). Seems like a problem with getting 8.2.x to build
on this platform:
<http://forums.gentoo.org/viewtopic-t-534835-highlight-postgresql.html;
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Feature request - have postgresql log warning when new sub-release comes out.
2007-04-25 22:52 Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-04-26 02:52 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Bill Moran <wmoran@potentialtech.com>
2007-04-26 15:10 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Joshua D. Drake <jd@commandprompt.com>
2007-04-26 16:55 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Leif B. Kristensen <leif@solumslekt.org>
@ 2007-04-26 18:12 ` Jon Sime <jsime@mediamatters.org>
2007-05-03 15:18 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Leif B. Kristensen <leif@solumslekt.org>
0 siblings, 1 reply; 11+ messages in thread
From: Jon Sime @ 2007-04-26 18:12 UTC (permalink / raw)
To: pgsql-general@postgresql.org
Leif B. Kristensen wrote:
> On Thursday 26. April 2007 17:10, Joshua D. Drake wrote:
>>> Actually, I've a feeling that it would be trivial to do with just
>>> about any existing packaging system ...
>> Yes pretty much every version of Linux, and FreeBSD, heck even Solaris
>> if you are willing to run 8.1.
>
> Gentoo is still on version 8.1.8, though, and even that is soft-masked
> (stable is at 8.0.12). Seems like a problem with getting 8.2.x to build
> on this platform:
>
> <http://forums.gentoo.org/viewtopic-t-534835-highlight-postgresql.html;
I run 8.2.x on a Gentoo/x86_64 development box (just did the upgrade to
8.2.4 yesterday) using the postgresql-experimental overlay (via layman)
and have run into no problems. Everything has compiled,
installed/upgraded and been run with no hiccups along the way, nor any
hacky workarounds.
The 8.2 series isn't in the main portage tree yet because, as I
understand it (and I could certainly be mistaken), the contributors
maintaining the ebuilds are reworking the slotting setup as well as
cleaning up the distinctions between server/library/client-only installs.
Granted, I'm not advising a mission-critical server that happens to be
running Gentoo use a portage overlay explicitly marked "experimental"
for its RDBMS package management -- just pointing out that there is a
pretty straight-forward way to get the 8.2 series through portage if
you're willing to use an overlay for it.
-Jon
--
Senior Systems Developer
Media Matters for America
http://mediamatters.org/
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Feature request - have postgresql log warning when new sub-release comes out.
2007-04-25 22:52 Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-04-26 02:52 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Bill Moran <wmoran@potentialtech.com>
2007-04-26 15:10 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Joshua D. Drake <jd@commandprompt.com>
2007-04-26 16:55 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Leif B. Kristensen <leif@solumslekt.org>
2007-04-26 18:12 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Jon Sime <jsime@mediamatters.org>
@ 2007-05-03 15:18 ` Leif B. Kristensen <leif@solumslekt.org>
0 siblings, 0 replies; 11+ messages in thread
From: Leif B. Kristensen @ 2007-05-03 15:18 UTC (permalink / raw)
To: pgsql-general@postgresql.org
On Thursday 26. April 2007 20:12, Jon Sime wrote:
>I run 8.2.x on a Gentoo/x86_64 development box (just did the upgrade
> to 8.2.4 yesterday) using the postgresql-experimental overlay (via
> layman) and have run into no problems. Everything has compiled,
>installed/upgraded and been run with no hiccups along the way, nor any
>hacky workarounds.
Postgresql-8.2.4 went soft-masked today. I've upgraded and my own local
web application is working just fine, but dependencies for several
other libs and apps are broken, and I'm in the process of running
revdep-rebuild and rebuilding 14 packages right now.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Feature request - have postgresql log warning when new sub-release comes out.
2007-04-25 22:52 Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
@ 2007-04-26 19:02 ` Leonel <lnunez@gmail.com>
2 siblings, 0 replies; 11+ messages in thread
From: Leonel @ 2007-04-26 19:02 UTC (permalink / raw)
To: Ron Mayer <rm_pg@cheapcomplexdevices.com>; +Cc: Carlos Moreno <moreno_pg@mochima.com>; pgsql-general@postgresql.org
On 4/25/07, 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?
>
>
>
> (The thread started on the performance mailing lists but
> I moved it to general since it drifted off topic).
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
what about the distros that do backporting for the bug fixes ?
those would be saying you are with a outdated PostgreSQL version
--
Leonel
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2007-05-03 15:18 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-25 22:52 Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-04-25 23:32 ` Joshua D. Drake <jd@commandprompt.com>
2007-04-26 18:38 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-04-26 19:50 ` Re: Re: Feature request - have postgresql log warning when new sub-release comes out. Ron Johnson <ron.l.johnson@cox.net>
2007-04-26 02:52 ` Bill Moran <wmoran@potentialtech.com>
2007-04-26 13:29 ` Ron Johnson <ron.l.johnson@cox.net>
2007-04-26 15:10 ` Joshua D. Drake <jd@commandprompt.com>
2007-04-26 16:55 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Leif B. Kristensen <leif@solumslekt.org>
2007-04-26 18:12 ` Jon Sime <jsime@mediamatters.org>
2007-05-03 15:18 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Leif B. Kristensen <leif@solumslekt.org>
2007-04-26 19:02 ` Re: Feature request - have postgresql log warning when new sub-release comes out. Leonel <lnunez@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox