Thread: 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.
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
Attachment
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 :)