[GENERAL] Postgresql RPM upgrade (8.2.3 -> 8.2.9)

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

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.

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.

My question: I do not have to change my CONF files and data and the
upgrade should work with the above? The Wiki does not address this in
the upgrade section.

Thanks.

--
Sent via pgsql-general mailing list (pgsql-general-at-postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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...ation-PGDG.pdf

and

http://www.westnet.com/~gsmith/gregs...esql/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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEABECAAYFAki2FTcACgkQtl86P3SPfQ5skACgosz6oiBK5x m7yzuyztjidadT
QFEAn2F7SCV309gKnSWzj28V3IfxcGeZ
=obUV
-----END PGP SIGNATURE-----

On Thu, Aug 28, 2008 at 3:00 AM, Phoenix Kiula 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/

--
Sent via pgsql-general mailing list (pgsql-general-at-postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general-at-postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general