Обсуждение: Upgrade, Install, RPM
- I have PostgreSQL 7.4.19 on CentOS 4.7 with no databases I need to keep. - PG was installed with CentOS in /var/lib/pgsql. - I am the only local user but I have Apache running on the same machine and plan to have web pages extracting data fromthe database. I'm considering upgrading PostgreSQL and have questions/am interested in opinions. - Is version 8.3 compatible with CentOS 4 as it appears to be. (I have all requirements listed in paragraph 15.2 of the manual.) - I like using RPMs to facilitate security updates (via yum) but the highest RPM version I found (on a quick search) is 8.2.3.It appears 8.3 improvements are largely performance improvements for high-volume transaction-processing situations,right? - If I install from source, is there any reason not to install it in /usr/local/pgsql? Any reason not to install it in /var/lib/pgsql(or var/lib/pgslq8)? Thanks for indulging, Bruce
Bruce, Have you checked out the new PostgreSQL yum repository. It has 8.3 and for CentOS 4 too. http://yum.pgsqlrpms.org/ Its probably the best source for the latest and greatest RPMs. They even have RPM for better version of 8.4. Hope that helps, Regina -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Bruce Hyatt Sent: Wednesday, November 12, 2008 8:55 PM To: pgsql-novice@postgresql.org Subject: [NOVICE] Upgrade, Install, RPM - I have PostgreSQL 7.4.19 on CentOS 4.7 with no databases I need to keep. - PG was installed with CentOS in /var/lib/pgsql. - I am the only local user but I have Apache running on the same machine and plan to have web pages extracting data from the database. I'm considering upgrading PostgreSQL and have questions/am interested in opinions. - Is version 8.3 compatible with CentOS 4 as it appears to be. (I have all requirements listed in paragraph 15.2 of the manual.) - I like using RPMs to facilitate security updates (via yum) but the highest RPM version I found (on a quick search) is 8.2.3. It appears 8.3 improvements are largely performance improvements for high-volume transaction-processing situations, right? - If I install from source, is there any reason not to install it in /usr/local/pgsql? Any reason not to install it in /var/lib/pgsql (or var/lib/pgslq8)? Thanks for indulging, Bruce -- Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
> They even have RPM for better version of 8.4. Hmm I meant beta version of 8.4. You would only use that in dev not in production of course :) Hope that helps, Regina ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
Hi, On Wed, 2008-11-12 at 17:54 -0800, Bruce Hyatt wrote: > - Is version 8.3 compatible with CentOS 4 as it appears to be. (I have > all requirements listed in paragraph 15.2 of the manual.) Yes, you can run 8.3 on CentOS 4. see http://yum.pgsqlrpms.org > - I like using RPMs to facilitate security updates (via yum) but the > highest RPM version I found (on a quick search) is 8.2.3. It appears > 8.3 improvements are largely performance improvements for high-volume > transaction-processing situations, right? See the link above. Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org
Вложения
--- On Thu, 11/13/08, Obe, Regina <robe.dnd@cityofboston.gov> wrote: > Bruce, > > Have you checked out the new PostgreSQL yum repository. It > has 8.3 and > for CentOS 4 too. > > http://yum.pgsqlrpms.org/ > > Its probably the best source for the latest and greatest > RPMs. They > even have RPM for better version of 8.4. > > Hope that helps, Yes, it did! Thanks to you and Devrim GÜNDÜZ. I wonder why it didn't show up when I googled "postgresql rpm." Bruce Hyatt
--- On Thu, 11/13/08, Devrim GÜNDÜZ <devrim@gunduz.org> wrote: > Hi, > > On Wed, 2008-11-12 at 17:54 -0800, Bruce Hyatt wrote: > > > - Is version 8.3 compatible with CentOS 4 as it > appears to be. (I have > > all requirements listed in paragraph 15.2 of the > manual.) > > Yes, you can run 8.3 on CentOS 4. see > http://yum.pgsqlrpms.org > > > - I like using RPMs to facilitate security updates > (via yum) but the > > highest RPM version I found (on a quick search) is > 8.2.3. It appears > > 8.3 improvements are largely performance improvements > for high-volume > > transaction-processing situations, right? > > See the link above. > I started following the major upgrade instructions found in the RPM installation instructions at the site mentioned above.I stopped the server and then ran the /bin/rpm -e command which returned "package /bin/rpm -qa|grep postgresql^ isnot installed." /bin/rpm -q postgresql shows that postgresql is indeed installed. It seems to be a problem with the placement of the single-quotesbut I can't find any other examples of passing strings to rpm in my reference book to help figure it out. Thanks, Bruce
> I stopped the server and then ran the /bin/rpm -e command which returned > "package /bin/rpm -qa|grep postgresql^ is not installed." I'm sorry. Never mind. I can remove the packages individually. Bruce