PostgreSQL support on Redhat Advance Server 2.1

Hi,

On Fri, 2006-03-24 at 07:52 -0800, Leon Pu wrote:

I found the newest PostgreSQL binary download on Redhat Advance Server
2.1 is version 7.4.7.

http://www.postgresql.org/ftp/binary/OLD/v7.4.7/rpms/redhat/rhel-es-2.1/

But I want to install newer PostgreSQL in Redhat Advance Server 2.1, at
least version 8.0.4.

Any possibility to install 8.0.4 or newer PostgreSQL?

None of the RPM package builders have a box running RHEL 2.1, and we
abandoned support for that. In my buildfarm I have a sata disk that RHEL
2.1 cannot recognize:(

Anyway, if you want, I can send you the instructions about how to build
RPMs on your platform.

Regards,

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/

--- Devrim GUNDUZ <devrim@commandprompt.com> wrote:

Hi,

On Fri, 2006-03-24 at 07:52 -0800, Leon Pu wrote:

I found the newest PostgreSQL binary download on Redhat Advance

Server

2.1 is version 7.4.7.

http://www.postgresql.org/ftp/binary/OLD/v7.4.7/rpms/redhat/rhel-es-2.1/

But I want to install newer PostgreSQL in Redhat Advance Server

2.1, at

least version 8.0.4.

Any possibility to install 8.0.4 or newer PostgreSQL?

None of the RPM package builders have a box running RHEL 2.1, and we
abandoned support for that. In my buildfarm I have a sata disk that
RHEL
2.1 cannot recognize:(

Anyway, if you want, I can send you the instructions about how to
build
RPMs on your platform.

Hi Devrim,

is there any article or annoucement about abandon support on REEL2.1
which I can refer to?

Please send me the instructions to build RPMs on RHEL 2.1.

Anyway, is there any potential problem to install unofficial downloaded
PostgreSQL?

Thanks a lot for your reply.

Best regards,
Leon

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Hi Devrim,

is there any article or annoucement about abandon support on REEL2.1
which I can refer to?

Please send me the instructions to build RPMs on RHEL 2.1.

Anyway, is there any potential problem to install unofficial downloaded
PostgreSQL?

No there is not. I actually suggest, considering your ancient version of
RedHat that you install from source.

Sincerely,

Joshua D. Drake

"Joshua D. Drake" <jd@commandprompt.com> writes:

No there is not. I actually suggest, considering your ancient version of
RedHat that you install from source.

Better yet, install a more modern Red Hat release ;-)

AS2.1 is very far into the "legacy" part of its support cycle.  You
shouldn't even be thinking of installing new applications on top of it
--- the only reason to be running it at all is "this server works and
we don't want to fix what's not broken".  You won't get any support from
Red Hat for running PG 8.anything on AS2.1, so why would you choose that
combination of releases?

regards, tom lane

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

"Joshua D. Drake" <jd@commandprompt.com> writes:

No there is not. I actually suggest, considering your ancient

version of

RedHat that you install from source.

Better yet, install a more modern Red Hat release ;-)

AS2.1 is very far into the "legacy" part of its support cycle.  You
shouldn't even be thinking of installing new applications on top of
it
--- the only reason to be running it at all is "this server works and
we don't want to fix what's not broken".  You won't get any support
from
Red Hat for running PG 8.anything on AS2.1, so why would you choose
that
combination of releases?

Hi Tom,

you are right, it's unresonable to run PostgreSQL 8.x on RHEL 2.1.

Since there are no support between both PostgreSQL and RHEL side for
PostgreSQL 8.x and RHEL 2.1, and I cannot upgrade the operating system.
I think I have to use PostgreSQL 7.4.7.

Best regards,
Leon

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

On Fri, Mar 24, 2006 at 11:54:29PM -0800, Leon Pu wrote:

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

"Joshua D. Drake" <jd@commandprompt.com> writes:

No there is not. I actually suggest, considering your ancient

version of

RedHat that you install from source.

Better yet, install a more modern Red Hat release ;-)

AS2.1 is very far into the "legacy" part of its support cycle.  You
shouldn't even be thinking of installing new applications on top of
it
--- the only reason to be running it at all is "this server works and
we don't want to fix what's not broken".  You won't get any support
from
Red Hat for running PG 8.anything on AS2.1, so why would you choose
that
combination of releases?

Hi Tom,

you are right, it's unresonable to run PostgreSQL 8.x on RHEL 2.1.

Since there are no support between both PostgreSQL and RHEL side for
PostgreSQL 8.x and RHEL 2.1, and I cannot upgrade the operating system.
I think I have to use PostgreSQL 7.4.7.

Well, you might be able to buy support for 8.1 on RHEL 2 from someone
other than Red Hat, if support is your primary concern. In any case, you
do not want to be using 7.4.7, since there's data corruption bugs that
have been fixed since then. I'd hope that RH would support at least the
most recent version of 7.4, since presumably that's part of what they
pay Tom for... Just understand that 7.4 is approaching end-of-life.
(Presumably so is RHEL2...)
--
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

Hi,

On Mon, 2006-03-27 at 06:03 -0600, Jim C. Nasby wrote:

I'd hope that RH would support at least the
most recent version of 7.4, since presumably that's part of what they
pay Tom for... Just understand that 7.4 is approaching end-of-life.
(Presumably so is RHEL2...)

RH won't support a newer (or older) major version of PostgreSQL which is
not included in RHEL 2.1. This is Red Hat's policy -- they do not update
to new major release in a distribution. I mean, (AFAIR) RHEL 2.1 ships
with PostgreSQL 7.3 and they won't support a newer major version.

However, I agree with you, if the support is the primary concern, there
are some support options around.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/

On Mon, Mar 27, 2006 at 03:16:29PM +0300, Devrim GUNDUZ wrote:

Hi,

On Mon, 2006-03-27 at 06:03 -0600, Jim C. Nasby wrote:

I'd hope that RH would support at least the
most recent version of 7.4, since presumably that's part of what they
pay Tom for... Just understand that 7.4 is approaching end-of-life.
(Presumably so is RHEL2...)

RH won't support a newer (or older) major version of PostgreSQL which is
not included in RHEL 2.1. This is Red Hat's policy -- they do not update
to new major release in a distribution. I mean, (AFAIR) RHEL 2.1 ships
with PostgreSQL 7.3 and they won't support a newer major version.

However, I agree with you, if the support is the primary concern, there
are some support options around.

Oh, I missed that this was actually a 7.3 database. That seriously
limits your options, though at least 7.3 is still supported via Tom/Red
Hat.
--
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

--- "Jim C. Nasby" <jnasby@pervasive.com> wrote:

On Mon, Mar 27, 2006 at 03:16:29PM +0300, Devrim GUNDUZ wrote:

Hi,

On Mon, 2006-03-27 at 06:03 -0600, Jim C. Nasby wrote:

I'd hope that RH would support at least the
most recent version of 7.4, since presumably that's part of what

they

pay Tom for... Just understand that 7.4 is approaching

end-of-life.

(Presumably so is RHEL2...)

RH won't support a newer (or older) major version of PostgreSQL

which is

not included in RHEL 2.1. This is Red Hat's policy -- they do not

update

to new major release in a distribution. I mean, (AFAIR) RHEL 2.1

ships

with PostgreSQL 7.3 and they won't support a newer major version.

However, I agree with you, if the support is the primary concern,

there

are some support options around.

Oh, I missed that this was actually a 7.3 database. That seriously
limits your options, though at least 7.3 is still supported via
Tom/Red
Hat.

Hi Jim,

do you mean PostgreSQL 7.3 is supported by RedHat on Advanced Server
2.1?

I only found PostgreSQL 7.1.3's rpms for RedHat Advanced Server 2.1, no
newer version anymore.

Anyway, since I cannot upgrade the operating system, could anybody give
me recommendation for which PostgreSQL version is more stable on 2.1?

Best regards,
Leon

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

On Mon, Mar 27, 2006 at 10:03:27AM -0800, Leon Pu wrote:

do you mean PostgreSQL 7.3 is supported by RedHat on Advanced Server
2.1?

I only found PostgreSQL 7.1.3's rpms for RedHat Advanced Server 2.1, no
newer version anymore.

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.

Anyway, since I cannot upgrade the operating system, could anybody give
me recommendation for which PostgreSQL version is more stable on 2.1?

You always want to be running the latest point release. There's a number
of data corruption bugs that have been fixed since 7.3.0.
--
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

On Tue, 2006-03-28 at 13:14, Jim C. Nasby wrote:

On Mon, Mar 27, 2006 at 10:03:27AM -0800, Leon Pu wrote:

do you mean PostgreSQL 7.3 is supported by RedHat on Advanced Server
2.1?

I only found PostgreSQL 7.1.3's rpms for RedHat Advanced Server 2.1, no
newer version anymore.

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.

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