Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
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 [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
> 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
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
On Tue, 2006-04-04 at 11:38, [EMAIL PROTECTED] 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] 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 <[EMAIL PROTECTED]> To: Scott Marlowe <[EMAIL PROTECTED]> Cc: "Jim C. Nasby" <[EMAIL PROTECTED]>, Leon Pu <[EMAIL PROTECTED]>, Devrim GUNDUZ <[EMAIL PROTECTED]>, "Joshua D. Drake" <[EMAIL PROTECTED]>, pgsql general Subject: Re: PostgreSQL support on Redhat Advance Server 2.1 Message-ID: <[EMAIL PROTECTED]> Scott Marlowe <[EMAIL PROTECTED]> 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
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
Scott Marlowe <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
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. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
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 [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
--- "Jim C. Nasby" <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
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 [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 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
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
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
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
On Fri, Mar 24, 2006 at 11:54:29PM -0800, Leon Pu wrote: > --- Tom Lane <[EMAIL PROTECTED]> wrote: > > > "Joshua D. Drake" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] Pervasive Software http://pervasive.comwork: 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
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
--- Tom Lane <[EMAIL PROTECTED]> wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
"Joshua D. Drake" <[EMAIL PROTECTED]> 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
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
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
Re: [GENERAL] PostgreSQL support on Redhat Advance Server 2.1
--- Devrim GUNDUZ <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] 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/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings