Thread: using pgdg repo

using pgdg repo

From
Richard Ray
Date:
I have installed pgdg-centos-8.3-5.noarch.rpm
Using that repo I installed
compat-postgresql-libs-4-1PGDG.rhel5
postgresql-server-8.3.5-2PGDG.rhel5
postgresql-contrib-8.3.5-2PGDG.rhel5
postgresql-docs-8.3.5-2PGDG.rhel5
postgresql-libs-8.3.5-2PGDG.rhel5
postgresql-8.3.5-2PGDG.rhel5
postgresql-pltcl-8.3.5-2PGDG.rhel5
postgresql-jdbc-8.3.604-1PGDG.rhel5

Now I want to update to PostgreSQL 8.3.6 which i believe is available in
the pgdg repo

# yum update postgresql
Loading "fastestmirror" plugin
Loading mirror speeds from cached hostfile
  * pgdg83: yum.pgsqlrpms.org
  * rpmforge: apt.sw.be
  * base: mirror.skiplink.com
  * updates: repo.genomics.upenn.edu
  * addons: mirror.newnanutilities.org
  * extras: ftp.usf.edu
Excluding Packages in global exclude list
Finished
Setting up Update Process
Could not find update match for postgresql
No Packages marked for Update

What is the prescribed method to perform this update?
If this is not the proper list for this question please point me to a
better resource.

Thanks
Richard


Re: using pgdg repo

From
Jakov Sosic
Date:
On Fri, 6 Mar 2009 09:16:04 -0600 (CST)
Richard Ray <rray@mstc.state.ms.us> wrote:

> # yum update postgresql

Have you tried:

# yum update postgresql*

Also, if that doesn't work, try this:

# yum update

and see the list of packages ready to be upgraded.

And if even that doesn't work, do the following:

# yum clean all
# yum update

"clean all" will remove all the cache, including downloaded rpm packages
in /var/cache/yum dir.




--
|    Jakov Sosic    |    ICQ: 28410271    |   PGP: 0x965CAE2D   |
=================================================================
| start fighting cancer -> http://www.worldcommunitygrid.org/   |

Re: using pgdg repo

From
Richard Ray
Date:
On Fri, 6 Mar 2009, Jakov Sosic wrote:

> On Fri, 6 Mar 2009 09:16:04 -0600 (CST)
> Richard Ray <rray@mstc.state.ms.us> wrote:
>
>> # yum update postgresql
>
> Have you tried:
>
> # yum update postgresql*

# yum update postgresql*
Loading "fastestmirror" plugin
Loading mirror speeds from cached hostfile
  * pgdg83: yum.pgsqlrpms.org
  * rpmforge: apt.sw.be
  * base: sunsite.utk.edu
  * updates: mirror.skiplink.com
  * addons: mirror.fdcservers.net
  * extras: sunsite.utk.edu
pgdg83                    100% |=========================| 1.9 kB    00:00
rpmforge                  100% |=========================| 1.1 kB    00:00
base                      100% |=========================| 1.1 kB    00:00
updates                   100% |=========================|  951 B    00:00
addons                    100% |=========================|  951 B    00:00
extras                    100% |=========================| 1.1 kB    00:00
Excluding Packages in global exclude list
Finished
Setting up Update Process
Could not find update match for postgresql*
No Packages marked for Update

>
> Also, if that doesn't work, try this:
>
> # yum update

# yum update
Loading "fastestmirror" plugin
Loading mirror speeds from cached hostfile
  * pgdg83: yum.pgsqlrpms.org
  * rpmforge: fr2.rpmfind.net
  * base: sunsite.utk.edu
  * updates: mirror.skiplink.com
  * addons: mirror.fdcservers.net
  * extras: sunsite.utk.edu
Excluding Packages in global exclude list
Finished
Setting up Update Process
No Packages marked for Update

>
> and see the list of packages ready to be upgraded.
>
> And if even that doesn't work, do the following:
>
> # yum clean all
> # yum update

# yum clean all
Loading "fastestmirror" plugin
Cleaning up Everything
Cleaning up list of fastest mirrors
# yum --exclude=libevent update
Loading "fastestmirror" plugin
Determining fastest mirrors
  * pgdg83: yum.pgsqlrpms.org
  * rpmforge: apt.sw.be
  * base: sunsite.utk.edu
  * updates: mirror.skiplink.com
  * addons: mirror.sanctuaryhost.com
  * extras: sunsite.utk.edu
pgdg83                    100% |=========================| 1.9 kB    00:00
primary.sqlite.bz2        100% |=========================| 181 kB    00:00
rpmforge                  100% |=========================| 1.1 kB    00:00
primary.xml.gz            100% |=========================| 2.9 MB    00:03
rpmforge  : ################################################## 8117/8117
base                      100% |=========================| 1.1 kB    00:00
primary.xml.gz            100% |=========================| 1.1 MB    00:00
base      : ################################################## 3223/3223
updates                   100% |=========================|  951 B    00:00
primary.xml.gz            100% |=========================| 434 kB    00:00
updates   : ################################################## 959/959
addons                    100% |=========================|  951 B    00:00
primary.xml.gz            100% |=========================|  157 B    00:00
extras                    100% |=========================| 1.1 kB    00:00
primary.xml.gz            100% |=========================|  97 kB    00:00
extras    : ################################################## 263/263
Excluding Packages in global exclude list
Finished
Setting up Update Process
No Packages marked for Update


>
> "clean all" will remove all the cache, including downloaded rpm packages
> in /var/cache/yum dir.
>
>
>
>
> --
> |    Jakov Sosic    |    ICQ: 28410271    |   PGP: 0x965CAE2D   |
> =================================================================
> | start fighting cancer -> http://www.worldcommunitygrid.org/   |
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

Re: using pgdg repo

From
Jakov Sosic
Date:
On Fri, 6 Mar 2009 15:59:08 -0600 (CST)
Richard Ray <rray@mstc.state.ms.us> wrote:

<cut>

Maybe priorities are broken? Maybe some other repo than pgdg3 has
higher priority for postgresql, and yum then won't upgrade postgresql
because it already has newer version than for example base/updates?

try leaving only pgdg83.repo in /etc/yum.repos.d/ and moving all others
somewhere temporary, and then add back one repo at a time, and you'll
notice when stuff breaks.


I have one cluster which wants to upgrade from 8.3.4 to 8.3.6, but I am
not allowed to do it because of possible downtime/problems... And it
bugs me almost a few months now, so I don't know what your problem can
be, but the repos seem fine :(




--
|    Jakov Sosic    |    ICQ: 28410271    |   PGP: 0x965CAE2D   |
=================================================================
| start fighting cancer -> http://www.worldcommunitygrid.org/   |

Re: using pgdg repo

From
Scott Marlowe
Date:
On Fri, Mar 6, 2009 at 2:59 PM, Richard Ray <rray@mstc.state.ms.us> wrote:
> Excluding Packages in global exclude list
> Finished

So, postgresql is for sure NOT in your exclude list(s)?

Re: using pgdg repo

From
Richard Ray
Date:


On Fri, 6 Mar 2009, Jakov Sosic wrote:

> On Fri, 6 Mar 2009 15:59:08 -0600 (CST)
> Richard Ray <rray@mstc.state.ms.us> wrote:
>
> <cut>
>
> Maybe priorities are broken? Maybe some other repo than pgdg3 has
> higher priority for postgresql, and yum then won't upgrade postgresql
> because it already has newer version than for example base/updates?
>
> try leaving only pgdg83.repo in /etc/yum.repos.d/ and moving all others
> somewhere temporary, and then add back one repo at a time, and you'll
> notice when stuff breaks.
>
>
> I have one cluster which wants to upgrade from 8.3.4 to 8.3.6, but I am
> not allowed to do it because of possible downtime/problems... And it
> bugs me almost a few months now, so I don't know what your problem can
> be, but the repos seem fine :(

That was the problem
Priorities were killing me

Many Thanks


>
>
>
>
> --
> |    Jakov Sosic    |    ICQ: 28410271    |   PGP: 0x965CAE2D   |
> =================================================================
> | start fighting cancer -> http://www.worldcommunitygrid.org/   |
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

Re: using pgdg repo

From
Jakov Sosic
Date:
On Fri, 6 Mar 2009 16:25:56 -0600 (CST)
Richard Ray <rray@mstc.state.ms.us> wrote:

> That was the problem
> Priorities were killing me

No problem!
Glad to be able to return the favors to community.


--
|    Jakov Sosic    |    ICQ: 28410271    |   PGP: 0x965CAE2D   |
=================================================================
| start fighting cancer -> http://www.worldcommunitygrid.org/   |