Thread: postgres on redhat 7.0
I am upgrading from RH 6.0 to RH 7.0. Dos anybody know where I can find the rpms for Postgres to work on RH7.0. Thanks, === arijit _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
os390 ibmos wrote: > I am upgrading from RH 6.0 to RH 7.0. > Dos anybody know where I can find the rpms for Postgres > to work on RH7.0. On the RH 7.0 CD's. I don't yet have a build box running RH 7.0 (my 7.0 box is this notebook, and its running a version of RH 7 that doesn't exist -- waiting on a set of CD's to get the official RH 7 set to build on). Of course, you will want to do a full dump before upgrading..... Particularly so if you are going from RH 6.0 (which shipped with PostgreSQL 6.4.2) to RH 7.0 (7.0.2). Hopefully you have already upgraded to 7.0.2 on RH 6.0..... -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
I'd assume the Redhat site. At the top they have a link named download. Clcik that and type postgresql. Click Search. It comes back with the RPMs. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "os390 ibmos" <os390@hotmail.com> To: <pgsql-general@postgresql.org> Sent: Monday, October 30, 2000 11:25 AM Subject: [GENERAL] postgres on redhat 7.0 > I am upgrading from RH 6.0 to RH 7.0. > > Dos anybody know where I can find the rpms for Postgres > to work on RH7.0. > > Thanks, > === > arijit > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com.
RPMs for postgresql 7.0.2 (the current version) are included on the RH7 CD. > -----Original Message----- > From: os390 ibmos [SMTP:os390@hotmail.com] > Sent: Monday, October 30, 2000 10:25 AM > To: pgsql-general@postgresql.org > Subject: [GENERAL] postgres on redhat 7.0 > > I am upgrading from RH 6.0 to RH 7.0. > > Dos anybody know where I can find the rpms for Postgres > to work on RH7.0. > > Thanks, > === > arijit > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com.
"os390 ibmos" <os390@hotmail.com> writes: > I am upgrading from RH 6.0 to RH 7.0. > > Dos anybody know where I can find the rpms for Postgres Postgresql is included in Red Hat Linux 7. -- Trond Eivind Glomsrød Red Hat, Inc.
But it don't help if you downloaded the OS. ;) Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Matthew" <matt@ctlno.com> To: "'os390 ibmos'" <os390@hotmail.com>; <pgsql-general@postgresql.org> Sent: Monday, October 30, 2000 1:50 PM Subject: RE: [GENERAL] postgres on redhat 7.0 > RPMs for postgresql 7.0.2 (the current version) are included on the RH7 CD. > > > -----Original Message----- > > From: os390 ibmos [SMTP:os390@hotmail.com] > > Sent: Monday, October 30, 2000 10:25 AM > > To: pgsql-general@postgresql.org > > Subject: [GENERAL] postgres on redhat 7.0 > > > > I am upgrading from RH 6.0 to RH 7.0. > > > > Dos anybody know where I can find the rpms for Postgres > > to work on RH7.0. > > > > Thanks, > > === > > arijit > > _________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > > > Share information about yourself, create your own public profile at > > http://profiles.msn.com.
"Adam Lang" <aalang@rutgersinsurance.com> writes: > But it don't help if you downloaded the OS. ;) You can of course find it on the ftp site as well, in the RPMS directory. -- Trond Eivind Glomsrød Red Hat, Inc.
Adam Lang wrote: > > But it don't help if you downloaded the OS. ;) If you downloaded the RedHat CD ISO images, OR the ftp dirs, you got the postgresql RPM's, unless you specifically excluded them. And you can certainly get them from RedHat's ftp site, as busy as it is. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
Yeah I know. I mentioned the redhat website when I first replied to the post. Which leads me to a question. Why do so many people ask the list where the most current RPMS for Redhat are located? Not trying to start trouble, but doesn't it seem obvious to check the Redhat site? Just wierd that so many people ask where to find them... Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Lamar Owen" <lamar.owen@wgcr.org> To: "Adam Lang" <aalang@rutgersinsurance.com> Cc: <pgsql-general@postgresql.org> Sent: Tuesday, October 31, 2000 10:54 AM Subject: Re: [GENERAL] postgres on redhat 7.0 > Adam Lang wrote: > > > > But it don't help if you downloaded the OS. ;) > > If you downloaded the RedHat CD ISO images, OR the ftp dirs, you got the > postgresql RPM's, unless you specifically excluded them. > > And you can certainly get them from RedHat's ftp site, as busy as it is. > -- > Lamar Owen > WGCR Internet Radio > 1 Peter 4:11
Adam Lang wrote: > Which leads me to a question. Why do so many people ask the list where the > most current RPMS for Redhat are located? Not trying to start trouble, but > doesn't it seem obvious to check the Redhat site? Just wierd that so many > people ask where to find them... Well, we maintain RPM's ourselves (or should I say, I maintain RPM's myself) -- but due to the lack of a RedHat 7 machine for me to build on (at this time) the best place to get RedHat 7 RPM's is with RedHat 7. I just announced the newest set -- there will be more announcements later this week or early next week as I build binaries on other architectures (I'm even working on building Hercules so I can build/rebuild for S/390 on my Intel box -- Hercules is an ESA/390 emulator -- slow as Christmas, but will run Linux/390 well enough to build/rebuild RPM's. My goal is posting working S/390 binaries on ftp.postgresql.org -- the coolness factor alone is worth the work) and other distributions (such as TurboLinux, Caldera eServer, and SuSE -- although SuSE has a 7.0.2 RPMset of their own that is substantially different from ours, even though it is based on ours). Unless someone want to offer me a shell and build privileges on a Linux/390 VM on their real S/390 :-). In fact, I'm requesting that people running something other than RedHat 6.2 on Intel try to --rebuild the src.rpm I just posted so that I can get binaries for multiple architectures. If you need to patch the spec file or whatever else to get it to run, send the patches my way so we can make it just a simple --rebuild for most folks. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
I was the original poster. Really my confusion stemmed from the fact that upgrading from RH6.0 to RH7.0, 7.0 complained (during boot) that my Postgress verision was outdated I need to upgrade. This threw me off. In general I am pretty pissed at RH attitude to system upgrade, if I were working in a Production environment, I would either hire them and not try anything myself, which kinda contradicts the whole Linux philosophy. > >Yeah I know. I mentioned the redhat website when I first replied to the >post. > >Which leads me to a question. Why do so many people ask the list where the >most current RPMS for Redhat are located? Not trying to start trouble, but >doesn't it seem obvious to check the Redhat site? Just wierd that so many >people ask where to find them... > >Adam Lang >Systems Engineer >Rutgers Casualty Insurance Company >----- Original Message ----- >From: "Lamar Owen" <lamar.owen@wgcr.org> >To: "Adam Lang" <aalang@rutgersinsurance.com> >Cc: <pgsql-general@postgresql.org> >Sent: Tuesday, October 31, 2000 10:54 AM >Subject: Re: [GENERAL] postgres on redhat 7.0 > > > > Adam Lang wrote: > > > > > > But it don't help if you downloaded the OS. ;) > > > > If you downloaded the RedHat CD ISO images, OR the ftp dirs, you got the > > postgresql RPM's, unless you specifically excluded them. > > > > And you can certainly get them from RedHat's ftp site, as busy as it is. > > -- > > Lamar Owen > > WGCR Internet Radio > > 1 Peter 4:11 > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
Sorry, only have an As/400 here, and I doubt think they'll let me play with it that much... :) Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Lamar Owen" <lamar.owen@wgcr.org> To: "Adam Lang" <aalang@rutgersinsurance.com> Cc: <pgsql-general@postgresql.org> Sent: Tuesday, October 31, 2000 4:28 PM Subject: Re: [GENERAL] postgres on redhat 7.0 > Adam Lang wrote: > > Which leads me to a question. Why do so many people ask the list where the > > most current RPMS for Redhat are located? Not trying to start trouble, but > > doesn't it seem obvious to check the Redhat site? Just wierd that so many > > people ask where to find them... > > Well, we maintain RPM's ourselves (or should I say, I maintain RPM's > myself) -- but due to the lack of a RedHat 7 machine for me to build on > (at this time) the best place to get RedHat 7 RPM's is with RedHat 7. > > I just announced the newest set -- there will be more announcements > later this week or early next week as I build binaries on other > architectures (I'm even working on building Hercules so I can > build/rebuild for S/390 on my Intel box -- Hercules is an ESA/390 > emulator -- slow as Christmas, but will run Linux/390 well enough to > build/rebuild RPM's. My goal is posting working S/390 binaries on > ftp.postgresql.org -- the coolness factor alone is worth the work) and > other distributions (such as TurboLinux, Caldera eServer, and SuSE -- > although SuSE has a 7.0.2 RPMset of their own that is substantially > different from ours, even though it is based on ours). > > Unless someone want to offer me a shell and build privileges on a > Linux/390 VM on their real S/390 :-). > > In fact, I'm requesting that people running something other than RedHat > 6.2 on Intel try to --rebuild the src.rpm I just posted so that I can > get binaries for multiple architectures. If you need to patch the spec > file or whatever else to get it to run, send the patches my way so we > can make it just a simple --rebuild for most folks. > -- > Lamar Owen > WGCR Internet Radio > 1 Peter 4:11
> I was the original poster. Really my confusion stemmed > from the fact that upgrading from RH6.0 to RH7.0, 7.0 > complained (during boot) that my Postgress verision was outdated > I need to upgrade. This threw me off. Yeah, the init script that they provide checks what's in PG_VERSION, and tells you to upgrade. The bad side is that it may have already overwritten your old binaries, etc., making it difficult to do a dump. You'd have to reinstall the old one, do the dump, then upgrade PostgreSQL, and then reinsert. Hopefully, their upgrade system was smart enough to not blindly overwrite your old PostgreSQL installation. If it did blindy overwrite it, then it's a very poorly written "upgrade", even Microsoft does better than that in a lot of situations. It would give further validation to my refusal to ever use RedHat's upgrade procedure. This isn't to say that RedHat is the devil. Just that like all *nix varieties, it has it's own behavioural deficiencies that need to be recognized and worked around. If there was a *nix that didn't have deficiencies, then all of the other varieties would quickly go away. > In general I am pretty pissed at RH attitude to system > upgrade, if I were working in a Production environment, > I would either hire them and not try anything myself, > which kinda contradicts the whole Linux philosophy. Well, it certainly doesn't contradict the RedHat philosophy of "Give them the product for free, then charge for support." ; )
Exactly my point. My next Linux server that I build is going to be SUSE, atleast some guys are not in a hurry to go public. >From: "Steve Wolfe" <steve@iboats.com> > Well, it certainly doesn't contradict the RedHat philosophy of "Give >them >the product for free, then charge for support." ; ) > > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.
"Steve Wolfe" <steve@iboats.com> writes: > > I was the original poster. Really my confusion stemmed > > from the fact that upgrading from RH6.0 to RH7.0, 7.0 > > complained (during boot) that my Postgress verision was outdated > > I need to upgrade. This threw me off. > > Yeah, the init script that they provide checks what's in PG_VERSION, and > tells you to upgrade. The bad side is that it may have already overwritten > your old binaries, etc., making it difficult to do a dump. These are actually backed up during the installation, thanks to Lamar's changes. -- Trond Eivind Glomsrød Red Hat, Inc.
> Exactly my point. My next Linux server that I build is going > to be SUSE, atleast some guys are not in a hurry to go public. > Trond's response indicates that all may not be as bad as we first thought. Good work, Lamar. steve
>In general I am pretty pissed at RH attitude to system >upgrade, if I were working in a Production environment, >I would either hire them and not try anything myself, >which kinda contradicts the whole Linux philosophy. Can this kind of stuff get put on a Red Hat mailing list, rather than sent here? Thanks! Rob Nelson rdnelson@co.centre.pa.us
It also relates back to a post I made many moons ago. I don't upgrade any OS (outside of minor patches). If it is a new OS version, backup and then clean install. Just too many variables to contend with to trust a type of upgrade script. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Steve Wolfe" <steve@iboats.com> To: <pgsql-general@postgresql.org> Sent: Tuesday, October 31, 2000 5:03 PM Subject: Re: [GENERAL] postgres on redhat 7.0 > > I was the original poster. Really my confusion stemmed > > from the fact that upgrading from RH6.0 to RH7.0, 7.0 > > complained (during boot) that my Postgress verision was outdated > > I need to upgrade. This threw me off. > > Yeah, the init script that they provide checks what's in PG_VERSION, and > tells you to upgrade. The bad side is that it may have already overwritten > your old binaries, etc., making it difficult to do a dump. You'd have to > reinstall the old one, do the dump, then upgrade PostgreSQL, and then > reinsert. > > Hopefully, their upgrade system was smart enough to not blindly overwrite > your old PostgreSQL installation. If it did blindy overwrite it, then it's > a very poorly written "upgrade", even Microsoft does better than that in a > lot of situations. It would give further validation to my refusal to ever > use RedHat's upgrade procedure. > > This isn't to say that RedHat is the devil. Just that like all *nix > varieties, it has it's own behavioural deficiencies that need to be > recognized and worked around. If there was a *nix that didn't have > deficiencies, then all of the other varieties would quickly go away. > > > In general I am pretty pissed at RH attitude to system > > upgrade, if I were working in a Production environment, > > I would either hire them and not try anything myself, > > which kinda contradicts the whole Linux philosophy. > > Well, it certainly doesn't contradict the RedHat philosophy of "Give them > the product for free, then charge for support." ; ) >
I wouldn't say ditch out on Redhat because of Postgres upgrades. As was mentioned on the list before, there is no current silver bullet upgrade for postgres. Dump, install new version, import old data. I would assume then that means SUSE would be no better on that regard either. Also, any bad experiences I have had with Redhat are not with Redhat themselves, per se. Mainly with RPMs. They really just don't mix well with applications you compile... OK, and maybe the occasional wierd directory structure that goes on, but other than that, I still choose them over other distributions. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "os390 ibmos" <os390@hotmail.com> To: <pgsql-general@postgresql.org> Sent: Tuesday, October 31, 2000 5:14 PM Subject: Re: [GENERAL] postgres on redhat 7.0 > > Exactly my point. My next Linux server that I build is going > to be SUSE, atleast some guys are not in a hurry to go public. > > >From: "Steve Wolfe" <steve@iboats.com> > > > > Well, it certainly doesn't contradict the RedHat philosophy of "Give > >them > >the product for free, then charge for support." ; ) > > > > > > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com.
"Robert D. Nelson" wrote: > > >In general I am pretty pissed at RH attitude to system > >upgrade, if I were working in a Production environment, > >I would either hire them and not try anything myself, > >which kinda contradicts the whole Linux philosophy. > Can this kind of stuff get put on a Red Hat mailing list, rather than sent > here? Thanks! pgsql-ports for PostgreSQL related stuff. I will announce soon some exciting news related to the RPM's, as well as a dedicated 'postgresqlrpms' mailing list, and the RPM spec files, patches, etc, under a public CVS server. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
os390 ibmos wrote: > Exactly my point. My next Linux server that I build is going > to be SUSE, atleast some guys are not in a hurry to go public. The SuSE RPM's are derived from the RedHat ones, according to their own changelog from SuSE 7.0's postgres-7.0.2-53.src.rpm: * Fri Jun 09 2000 - max@suse.de - New version: 7.0.2. - Re-made the whole package based on the original PostgreSQL RPM. - There is still a little work needed for clean updates from PostgreSQL 6.x to 7.0.x - Heavy testing needed before SuSE Linux 7.0. Further discussion on RPM pros and cons should go to pgsql-ports. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
[bcc to general, cc: (and followups) to pgsql-ports.] Steve Wolfe wrote: > > > Exactly my point. My next Linux server that I build is going > > to be SUSE, atleast some guys are not in a hurry to go public. > Trond's response indicates that all may not be as bad as we first > thought. Good work, Lamar. You're welcome. Please see the file README.rpm, which is referenced in the bootup message (or at least it should be) on what to do next. On RedHat 7 README.rpm is in /usr/share/doc, on RedHat 6 it is in /usr/doc. It has been a long road towards getting smooth RPM upgrades -- and we're not there yet, unfortunately, although Trond's rh-pgdump script helps loads. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11