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'}
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 |