Skip site navigation (1) Skip section navigation (2)

Re: Postgresql RPM upgrade (8.2.3 -> 8.2.9)

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgresql RPM upgrade (8.2.3 -> 8.2.9)
Date: 2008-08-28 03:02:17
Message-ID: 1219892537.3792.226.camel@laptop.gunduz.org (view raw or flat)
Thread:
Lists: pgsql-general
Hi,

On Thu, 2008-08-28 at 09:00 +0800, Phoenix Kiula wrote:
> I hope this is a simple question. I checked the PG wiki but didn't
> find an answer:
> http://wiki.postgresql.org/wiki/RPM_Installation

That document may not be up2date. I'll check. Until then, 

http://pgfoundry.org/docman/view.php/1000048/1338/PostgreSQL-RPM-Installation-PGDG.pdf

and

http://www.westnet.com/~gsmith/gregsmith/content/postgresql/pgrpm.htm

may help you.

> I have my 8.2.3 RPMs installed. I would like to upgrade to 8.2.9.
> Because this is a minor version upgrade (within 8.2) I understand that
> I should be able to upgrade the rpm *without* dump/restore step.

Well, you still need to check release notes. There has been *very few*
exceptions for that. But in principle, answer is no.

> Now, is it correct that i don't have to stop my server and I can just
> execute these commands:
> 
> rpm -Uvh --test postgresql-libs-8.2.9-1PGDG.rhel4.i386.rpm
> rpm -Uvh --test postgresql-8.2.9-1PGDG.rhel4.i386.rpm
> rpm -Uvh --test postgresql-contrib-8.2.9-1PGDG.rhel4.i386.rpm
> rpm -Uvh --test postgresql-devel-8.2.9-1PGDG.rhel4.i386.rpm
> rpm -Uvh --test postgresql-server-8.2.9-1PGDG.rhel4.i386.rpm
> 
> And all will be okay? (I would run these without the "--test") Right
> now, these tests give errors.

What errors?

Also, I think you should update all packages at once, like:

rpm -Uvh postgresql-server-8.2.9-1PGDG.rhel4.i386.rpm
postgresql-8.2.9-1PGDG.rhel4.i386.rpm  ...

Regards,
-- 
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                   http://www.gunduz.org

In response to

pgsql-general by date

Next:From: Marco BizzarriDate: 2008-08-28 04:11:19
Subject: Re: Postgresql RPM upgrade (8.2.3 -> 8.2.9)
Previous:From: Richard HuxtonDate: 2008-08-28 01:26:53
Subject: Re: Restoring a database from a file system snapshot

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group