Re: Postgresql RPM upgrade (8.2.3 -> 8.2.9)

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