postgresql-libs on PPA servers

Discussion in 'Plesk Automation Suggestions and Feedback' started by Dave W, May 19, 2015.

  1. Dave W

    Dave W Kilo Poster

    Messages:
    67
    Hi all,

    Noticed while doing some updates that there are differing versions of postgres libs installed on different nodes (would have been created at different times)

    snode 1:
    yum list installed|grep postgres
    postgresql-libs.x86_64 9.0.13-5.2.el6 @pa-central-repo​


    snode2:
    yum list installed|grep postgres
    postgresql.x86_64 8.4.20-2.el6_6 @updates
    postgresql-devel.x86_64 8.4.20-2.el6_6 @updates
    postgresql-libs.i686 8.4.20-2.el6_6 @updates
    postgresql-libs.x86_64 8.4.20-2.el6_6 @updates

    When I do a yum update on snode2 I get conflict errors.

    yum update
    Loaded plugins: fastestmirror, priorities
    Setting up Update Process
    Loading mirror speeds from cached hostfile
    * base: ftp.heanet.ie
    * extras: ftp.heanet.ie
    * updates: ftp.heanet.ie
    Resolving Dependencies
    --> Running transaction check
    ---> Package postgresql.x86_64 0:8.4.20-2.el6_6 will be updated
    --> Processing Dependency: postgresql(x86-64) = 8.4.20-2.el6_6 for package: postgresql-devel-8.4.20-2.el6_6.x86_64
    ---> Package postgresql.x86_64 0:9.0.13-5.2.el6 will be an update
    ---> Package postgresql-libs.x86_64 0:8.4.20-2.el6_6 will be updated
    --> Processing Dependency: postgresql-libs(x86-64) = 8.4.20-2.el6_6 for package: postgresql-devel-8.4.20-2.el6_6.x86_64
    ---> Package postgresql-libs.x86_64 0:9.0.13-5.2.el6 will be an update
    --> Finished Dependency Resolution
    Error: Package: postgresql-devel-8.4.20-2.el6_6.x86_64 (@updates)
    Requires: postgresql(x86-64) = 8.4.20-2.el6_6
    Removing: postgresql-8.4.20-2.el6_6.x86_64 (@updates)
    postgresql(x86-64) = 8.4.20-2.el6_6
    Updated By: postgresql-9.0.13-5.2.el6.x86_64 (pa-central-repo)
    postgresql(x86-64) = 9.0.13-5.2.el6
    Available: postgresql-8.4.20-1.el6_5.x86_64 (base)
    postgresql(x86-64) = 8.4.20-1.el6_5
    Error: Package: postgresql-devel-8.4.20-2.el6_6.x86_64 (@updates)
    Requires: postgresql-libs(x86-64) = 8.4.20-2.el6_6
    Removing: postgresql-libs-8.4.20-2.el6_6.x86_64 (@updates)
    postgresql-libs(x86-64) = 8.4.20-2.el6_6
    Updated By: postgresql-libs-9.0.13-5.2.el6.x86_64 (pa-central-repo)
    postgresql-libs(x86-64) = 9.0.13-5.2.el6
    Available: postgresql-libs-8.4.20-1.el6_5.x86_64 (base)
    postgresql-libs(x86-64) = 8.4.20-1.el6_5
    You could try using --skip-broken to work around the problem
    You could try running: rpm -Va --nofiles --nodigest​


    Can I just remove the i686 packages?
     
  2. Starl1ght

    Starl1ght Just a cat

    Messages:
    81
    Yum shouldn't have pa-central-repo repository on Service node, AFAIK.
     
    Last edited: May 26, 2015
  3. Dave W

    Dave W Kilo Poster

    Messages:
    67
    Hi Denis,

    Yeah the 'pa-central-repo' is on all our nodes. This issue only happens on some of the SNs. Those with postgresql-libs.i686 8.4.20-2.el6_6 installed. Just wondering if it should be, as its not installed in the majority of other SNs.

    Dave
     
  4. Starl1ght

    Starl1ght Just a cat

    Messages:
    81
    Try to disable pa-central-repo on one node and try again. PA-central-repo should be only on MN.
     
  5. Dave W

    Dave W Kilo Poster

    Messages:
    67
    Hi Denis, Sorry...took a while to get back to you, moved to Melbourne in the mean time.

    I removed the pa-central-repo repo from yum.repos.d and yum removed pa-central-repo, this also removed rdbmspp.i686, then did a yum update and all seems clean now.

    [root@xxxxxxxx ~]# yum list installed |grep postgres
    postgresql.x86_64 8.4.20-3.el6_6 @updates
    postgresql-devel.x86_64 8.4.20-3.el6_6 @updates
    postgresql-libs.x86_64 8.4.20-3.el6_6 @updates

    What is the purpose of pa-central-repo?
     
  6. Starl1ght

    Starl1ght Just a cat

    Messages:
    81
    This is a bit obscure... Main idea - we have local repo at PPA Management node, from which are updates\stuff installed between major upgrades (11.1->11.5, 11.5->11.6) on Management node only.
     
  7. Dave W

    Dave W Kilo Poster

    Messages:
    67
    ok so its safe to remove the pa-central-repo from yum.repos.d on nodes?

    While it was there I was getting the postgres version issues.
     
  8. Starl1ght

    Starl1ght Just a cat

    Messages:
    81
    Yep, it's safe
     
  9. Dave W

    Dave W Kilo Poster

    Messages:
    67
    Thanks Denis.
     

Share This Page