Thread: upgrade postgres to 8.4.8, centos 5.3

upgrade postgres to 8.4.8, centos 5.3

From
MirrorX
Date:
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

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

Re: upgrade postgres to 8.4.8, centos 5.3

From
Scott Marlowe
Date:
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.

Re: upgrade postgres to 8.4.8, centos 5.3

From
MirrorX
Date:
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.

Re: upgrade postgres to 8.4.8, centos 5.3

From
Scott Marlowe
Date:
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.

Re: upgrade postgres to 8.4.8, centos 5.3

From
Devrim GÜNDÜZ
Date:
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

Attachment

Re: upgrade postgres to 8.4.8, centos 5.3

From
MirrorX
Date:
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.

Re: upgrade postgres to 8.4.8, centos 5.3

From
Devrim GÜNDÜZ
Date:
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

Attachment

Re: upgrade postgres to 8.4.8, centos 5.3

From
MirrorX
Date:
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.