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

On Thu, Aug 28, 2008 at 3:00 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:

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.

Most probably your errors are caused by dependencies between the
packages; as someone else already suggested, try to write the command
as:

rpm -Uvh --test postgresql-8.2.9... postgresql-server...

etc. In that way all the dependencies should be addressed.

If that does not solve the problem, post the error message.

Regards
Marco
--
Marco Bizzarri
http://iliveinpisa.blogspot.com/

Thanks all. Turns out I didn't have any problems at all. I just ran
this command, all rpms together as Devrim Gunduz suggested -

--
rpm -Uvh postgresql-8.2.9-1PGDG.rhel4.i386.rpm
postgresql-contrib-8.2.9-1PGDG.rhel4.i386.rpm
postgresql-devel-8.2.9-1PGDG.rhel4.i386.rpm
postgresql-libs-8.2.9-1PGDG.rhel4.i386.rpm
postgresql-server-8.2.9-1PGDG.rhel4.i386.rpm
--

Database working in tiptop condition :)