[BUGS] BUG #14677: BLOCKER: Postgres 9.4.12 repos only presenting packagesfor RHEL7 - Mailing list pgsql-bugs

From lsichello@illumina.com
Subject [BUGS] BUG #14677: BLOCKER: Postgres 9.4.12 repos only presenting packagesfor RHEL7
Date
Msg-id 20170529200153.4276.43335@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14677: BLOCKER: Postgres 9.4.12 repos onlypresenting packages for RHEL7  (Devrim Gündüz <devrim@gunduz.org>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14677
Logged by:          Lee Sichello
Email address:      lsichello@illumina.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@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@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@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@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'}


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [BUGS] BUG #14635: Query is executed slower on hot standby slavedatabase then on master database
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14635: Query is executed slower on hot standby slave database then on master database