PostgreSQL Discussion - PostgreSQL support on Redhat Advance Server 2.1

Author

PostgreSQL support on Redhat Advance Server 2.1

Leon Pu

2006-03-24, 11:33 am

Hi all,

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

http://www.postgresql.org/ftp/binar...at/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?

Best regards,
Leon

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Devrim GUNDUZ

2006-03-24, 11:33 am

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/binar...at/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/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Leon Pu

2006-03-25, 3:27 am

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

> Hi,
>
> On Fri, 2006-03-24 at 07:52 -0800, Leon Pu wrote:
>
> Server
>
http://www.postgresql.org/ftp/binar...at/rhel-es-2.1/
> 2.1, at
>
> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Joshua D. Drake

2006-03-25, 3:27 am

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Tom Lane

2006-03-25, 3:27 am

"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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Leon Pu

2006-03-25, 3:27 am

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

> "Joshua D. Drake" <jd@commandprompt.com> writes:
> version of
>
> 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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Jim C. Nasby

2006-03-27, 7:37 am

On Fri, Mar 24, 2006 at 11:54:29PM -0800, Leon Pu wrote:
> --- Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>
> 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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Devrim GUNDUZ

2006-03-27, 7:37 am

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/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Jim C. Nasby

2006-03-27, 7:37 am

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Leon Pu

2006-03-27, 1:32 pm

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

> On Mon, Mar 27, 2006 at 03:16:29PM +0300, Devrim GUNDUZ wrote:
> they
> end-of-life.
> which is
> update
> ships
> there
>
> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Jim C. Nasby

2006-03-28, 8:26 pm

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Scott Marlowe

2006-03-28, 8:26 pm

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Tom Lane

2006-03-28, 8:26 pm

Scott Marlowe < smarlowe@g2switchwor
ks.com> writes:
> On Tue, 2006-03-28 at 13:14, Jim C. Nasby wrote:
[color=darkred]
> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

MargaretGillon@chromalloy.com

2006-04-04, 1:28 pm

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@g2switchwor
ks.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@g2switchwor
ks.com> writes:
> On Tue, 2006-03-28 at 13:14, Jim C. Nasby wrote:
[color=darkred]
> 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

Scott Marlowe

2006-04-04, 1:28 pm

On Tue, 2006-04-04 at 11:38, MargaretGillon@chrom
alloy.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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Tony Caduto

2006-04-04, 1:28 pm

> 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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Jim Nasby

2006-04-07, 3:36 am

On Apr 4, 2006, at 12:45 PM, Tony Caduto wrote:
>
> 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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links