upgrade postgres to 8.4.8, centos 5.3

On Tue, Sep 20, 2011 at 8:30 AM, MirrorX <mirrorx@gmail.com> wrote:

hello all,
i have a centos 5.3 which has postgres 8.4.4 installed from the repos. I
want to upgrade to 8.4.8 but when i try to install the .bin file of 8.4.8
then it's a new installation and when i try to run yum check-update nothing
new is there. any ideas? tnx in advance

You need packages from the same place etc not a .bin file. Look for
packages that have PGDG in the middle and .rpm on the end.

thx for your answer.

do u mean something like that? -> yum list | grep *PGDG*rpm
or i shouldn't search in the yum repos?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/upgrade-postgres-to-8-4-8-centos-5-3-tp4822762p4822823.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

If it's in the repo, just do

yum update

and it should get updated.

On Tue, Sep 20, 2011 at 8:49 AM, MirrorX <mirrorx@gmail.com> wrote:

thx for your answer.

do u mean something like that? -> yum list | grep *PGDG*rpm
or i shouldn't search in the yum repos?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/upgrade-postgres-to-8-4-8-centos-5-3-tp4822762p4822823.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

--
To understand recursion, one must first understand recursion.

On Tue, 2011-09-20 at 07:49 -0700, MirrorX wrote:

do u mean something like that? -> yum list | grep *PGDG*rpm
or i shouldn't search in the yum repos?

What is the output of:

cat /etc/yum.repos.d/pgdg*|grep baseurl

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

i searched on the net and didnt find this rpm. anyway the output is the
following ->

baseurl=http://yum.pgsqlrpms.org/8.4/redhat/rhel-$releasever-$basearch
baseurl=http://yum.pgsqlrpms.org/srpms/8.4/redhat/rhel-$releasever-$basearch
baseurl=http://yum.pgsqlrpms.org/8.4/redhat/rhel-$releasever-$basearch
baseurl=http://yum.pgsqlrpms.org/srpms/8.4/redhat/rhel-$releasever-$basearch

--
View this message in context: http://postgresql.1045698.n5.nabble.com/upgrade-postgres-to-8-4-8-centos-5-3-tp4822762p4825495.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

On Wed, 2011-09-21 at 00:59 -0700, MirrorX wrote:

i searched on the net and didnt find this rpm. anyway the output is
the
following ->

baseurl=http://yum.pgsqlrpms.org/8.4/redhat/rhel-$releasever-$basearch

Ok, that is the old repo. So, do this as root:

rpm -Uvh http://yum.pgrpms.org/reporpms/8.4/pgdg-centos-8.4-2.noarch.rpm

That will update the repo URL. Now you can run

yum update postgresql*

to update postgresql packages.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

thx a lot for your help. it worked great :)

--
View this message in context: http://postgresql.1045698.n5.nabble.com/upgrade-postgres-to-8-4-8-centos-5-3-tp4822762p4841782.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.