Thread: [BUGS] BUG #14677: BLOCKER: Postgres 9.4.12 repos only presenting packagesfor RHEL7

[BUGS] BUG #14677: BLOCKER: Postgres 9.4.12 repos only presenting packagesfor RHEL7

From
lsichello@illumina.com
Date:
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

Hi Lee,

On Mon, 2017-05-29 at 20:01 +0000, lsichello@illumina.com wrote:
> 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.

<snip>

:-( This happened today, while I was unifying build instances :( This affected
all RHEL 6 - x86_64 installations.

Fixed master repo by restoring from the backups. They will sync to
download.postgresql.org in next 10-15 mins.

Can you please let me know if you see more issues?

Apologies for the inconvenience.

Regards,
--
Devrim Gündüz
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR