Re: Upgrade, Install, RPM

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.