Обсуждение: 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