Re: PostgreSQL support on Redhat Advance Server 2.1
Hi Tom,
You wrote "Unfortunately Red Hat's backwards-compatibility policy forbids
dropping
new major PG releases into old RHEL branches". So that means I cannot
upgrade to Postgresql 8.x on a RedHat9 server? Currently I am using
Postgresql 7.3 but was planning on upgrading before I put the database
into production.
Thanks,
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** ***
Date: Tue, 28 Mar 2006 16:33:53 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: "Jim C. Nasby" <jnasby@pervasive.com>, Leon Pu
<leon_xf_pu@yahoo.com.cn>,
Devrim GUNDUZ <devrim@commandprompt.com>,
"Joshua D. Drake" <jd@commandprompt.com>,
pgsql general <pgsql-general@postgresql.org>
Subject: Re: PostgreSQL support on Redhat Advance Server 2.1
Message-ID: <5629.1143581633@sss.pgh.pa.us>
Scott Marlowe <smarlowe@g2switchworks.com> writes:
On Tue, 2006-03-28 at 13:14, Jim C. Nasby wrote:
Tom has mentioned in the past that he's been backpatching stuff to 7.3
as part of his job, so I would assume that RH will support any 7.3
version.
But only for supported OSes. I'm pretty sure 2.1 is past due on that
count.
The real problem is that PG 7.1 is effectively unsupportable: there are
too many fundamentally unfixable bugs in it, such as transaction ID
wraparound, type-unsafeness in I/O routines, yadda yadda. These things
can't be dealt with without introducing significant incompatibilities,
which means you may as well just update to some newer version instead.
Unfortunately Red Hat's backwards-compatibility policy forbids dropping
new major PG releases into old RHEL branches, so AS2.1 is stuck with
7.1. The best I can do in the way of support is to wave a big cluestick
at anyone foolish enough to try to use Postgres on that platform: get a
newer version, or expect to regret it. I'm not bothering to back-patch
bug fixes, in view of the huge unfixable bugs.
RHEL3 (with PG 7.3) is at least something you could plausibly use
Postgres on without expecting to lose data, so 7.3 is still getting
fixes for major bugs.
regards, tom lane
On Tue, 2006-04-04 at 11:38, MargaretGillon@chromalloy.com wrote:
Hi Tom,
You wrote "Unfortunately Red Hat's backwards-compatibility policy
forbids dropping
new major PG releases into old RHEL branches". So that means I cannot
upgrade to Postgresql 8.x on a RedHat9 server? Currently I am using
Postgresql 7.3 but was planning on upgrading before I put the database
into production.
No, YOU can upgrade. But RedHat won't be releasing RPMs for the
process. And it might be that getting postgresql to compile from source
to do this might not work either.
You wrote "Unfortunately Red Hat's backwards-compatibility policy
forbids dropping
new major PG releases into old RHEL branches". So that means I cannot
upgrade to Postgresql 8.x on a RedHat9 server? Currently I am using
Postgresql 7.3 but was planning on upgrading before I put the database
into production.
Hi Margaret,
Tom means that Redhat won't provide a update for Postgresql, that does
not mean you can't install it yourself.
I run RedHat EL 4.3(Postgresql is at 7.4.x on EL 4.3) at work and I run
8.1 on it, I just installed it myself.
Later,
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin
Your best bet for Postgresql Administration
On Apr 4, 2006, at 12:45 PM, Tony Caduto wrote:
You wrote "Unfortunately Red Hat's backwards-compatibility policy
forbids dropping
new major PG releases into old RHEL branches". So that means I cannot
upgrade to Postgresql 8.x on a RedHat9 server? Currently I am using
Postgresql 7.3 but was planning on upgrading before I put the
database
into production.Hi Margaret,
Tom means that Redhat won't provide a update for Postgresql, that does
not mean you can't install it yourself.I run RedHat EL 4.3(Postgresql is at 7.4.x on EL 4.3) at work and I
run
8.1 on it, I just installed it myself.
Just realize that RedHat won't provide any support for 8.x on
RHAS2.1. Pervasive would be happy to, though. :)
Incidentally, someone from Red Hat talked to me at Linuxworld about
setting up some kind of partnership. Turns out he didn't know who Tom
Lane was or where he worked. :)
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461