BUG #14677: BLOCKER: Postgres 9.4.12 repos only presenting packages for RHEL7

From: lsichello(at)illumina(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14677: BLOCKER: Postgres 9.4.12 repos only presenting packages for RHEL7
Date: 2017-05-29 20:01:53
Message-ID: 20170529200153.4276.43335@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14677
Logged by: Lee Sichello
Email address: lsichello(at)illumina(dot)com
PostgreSQL version: 9.4.3
Operating system: CentOS 6.9
Description:

Hello,

My team has run into an issue today where the usual route we follow to
install postgres 9.4.3 onto CentOS 6.9 is blocked. We are doing the
following:

Install PGDG RPM file:
[root(at)server]# yum install
https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-5-x86_64/pgdg-centos94-9.4-3.noarch.rpm

List the available postgres packages:
[root(at)demo pgsql-repo-installers]# yum list postgres*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.mirror.ca.planethoster.net
* extras: muug.ca
* updates: muug.ca
Available Packages
postgresql.i686
8.4.20-7.el6
base
postgresql.x86_64
8.4.20-7.el6
base
postgresql-contrib.x86_64
8.4.20-7.el6
base
postgresql-devel.i686
8.4.20-7.el6
base
postgresql-devel.x86_64
8.4.20-7.el6
base
postgresql-docs.x86_64
8.4.20-7.el6
base
postgresql-jdbc.noarch
42.1.1-1.rhel7
pgdg94
postgresql-jdbc-javadoc.noarch
42.1.1-1.rhel7
pgdg94
postgresql-libs.i686
8.4.20-7.el6
base
postgresql-libs.x86_64
8.4.20-7.el6
base
postgresql-odbc.x86_64
08.04.0200-1.el6
base
postgresql-plperl.x86_64
8.4.20-7.el6
base
postgresql-plpython.x86_64
8.4.20-7.el6
base
postgresql-pltcl.x86_64
8.4.20-7.el6
base
postgresql-server.x86_64
8.4.20-7.el6
base
postgresql-test.x86_64
8.4.20-7.el6
base
postgresql-unit94.x86_64
2.0-1.rhel7
pgdg94
postgresql-unit94-debuginfo.x86_64
2.0-1.rhel7
pgdg94
postgresql94.x86_64
9.4.12-1PGDG.rhel7
pgdg94
postgresql94-contrib.x86_64
9.4.12-1PGDG.rhel7
pgdg94
postgresql94-debuginfo.x86_64
9.4.12-1PGDG.rhel7
pgdg94
postgresql94-devel.x86_64
9.4.12-1PGDG.rhel7
pgdg94
postgresql94-docs.x86_64
9.4.12-1PGDG.rhel7
pgdg94
postgresql94-jdbc.noarch
9.4.1207-2.rhel7
pgdg94
postgresql94-jdbc-javadoc.noarch
9.4.1207-2.rhel7
pgdg94
postgresql94-libs.x86_64
9.4.12-1PGDG.rhel7
pgdg94
postgresql94-odbc.x86_64
09.06.0300-1PGDG.rhel7
pgdg94
postgresql94-odbc-debuginfo.x86_64
09.03.0400-1PGDG.rhel7
pgdg94
postgresql94-plperl.x86_64
9.4.12-1PGDG.rhel7
pgdg94
postgresql94-plpython.x86_64
9.4.12-1PGDG.rhel7
pgdg94
postgresql94-pltcl.x86_64
9.4.12-1PGDG.rhel7
pgdg94
postgresql94-server.x86_64
9.4.12-1PGDG.rhel7
pgdg94
postgresql94-tcl.x86_64
2.1.1-1.rhel7
pgdg94
postgresql94-tcl-debuginfo.x86_64
2.1.1-1.rhel7
pgdg94
postgresql94-test.x86_64
9.4.12-1PGDG.rhel7
pgdg94

Notice that only 9.4.12 packages are available for RHEL7 . We expect to see
packages available here for RHEL6 . The contents of the repo file installed
are:

[root(at)demo pgsql-repo-installers]# cat
/etc/yum.repos.d/pgdg-94-centos.repo
[pgdg94]
name=PostgreSQL 9.4 $releasever - $basearch
baseurl=https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-$releasever-$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-94

[pgdg94-source]
name=PostgreSQL 9.4 $releasever - $basearch - Source
failovermethod=priority
baseurl=https://download.postgresql.org/pub/repos/yum/srpms/9.4/redhat/rhel-$releasever-$basearch
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-94

And the variables used by the repo file are correctly set:

[root(at)demo pgsql-repo-installers]# python -c 'import yum, pprint; yb =
yum.YumBase(); pprint.pprint(yb.conf.yumvar, width=1)'
Loaded plugins: fastestmirror
{'arch': 'ia32e',
'basearch': 'x86_64',
'infra': 'stock',
'releasever': '6',
'uuid': '97af2b61-6adf-4ffa-a313-2825ec117068'}

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-05-29 20:07:09 Re: BUG #14635: Query is executed slower on hot standby slave database then on master database
Previous Message Jeff Janes 2017-05-29 19:31:07 Re: BUG #14635: Query is executed slower on hot standby slave database then on master database