Re: Re: Feature request - have postgresql log warning when new sub-release comes out.

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: Feature request - have postgresql log warning when new sub-release comes out.
Date: 2007-04-26 19:50:24
Message-ID: 46310280.2010301@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcelo de Moraes Serpa 2007-04-26 20:07:21 Compiling PostgreSQL 8.2 on Windows using msvc2k5
Previous Message Steve Crawford 2007-04-26 19:49:27 Re: [GENERAL] PostgreSQL Performance Tuning

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2007-04-26 21:09:28 Re: Simple query, 10 million records...MySQL ten times faster
Previous Message Steve Crawford 2007-04-26 19:49:27 Re: [GENERAL] PostgreSQL Performance Tuning