To: pgsql-admin@lists.postgresql.org
From: S Bob <sbob@quadratum-braccas.com>
Subject: pglogical repo fails for amazon linux
Message-ID: <5095f7ce-a3e0-6fee-6cb6-28fb0d3e5c19@quadratum-braccas.com>
Date: Thu, 25 Feb 2021 16:28:09 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.7.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

All;


I've done the following on an amazon EC2 VM running amazon linux:


1) created the postgresql repo for V12:

# tee /etc/yum.repos.d/pgdg.repo<<EOF
[pgdg12]
name=PostgreSQL 12 for RHEL/CentOS 7 - x86_64
baseurl=https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64
enabled=1
gpgcheck=0
EOF


2) Ran the pglogical curl command:

# curl 
https://access.2ndquadrant.com/api/repository/dl/default/release/12/rpm 
| bash


3) attempted to install the pglogical package via yum:

# yum install postgresql12-pglogical


Steps 1 and 2 were successful, step 3 produces the output below, anyone 
know why? am I doing something wrong? These exact same steps work on a 
local Linux VM (Not amazon).


Thanks in advance


Step 3 output:

# yum install postgresql12-pglogical
Loaded plugins: extras_suggestions, langpacks, priorities, update-motd
https://dl.2ndquadrant.com/default/release/rpm/packages/amzn/2/x86_64/12/repodata/repomd.xml: 
[Errno 14] HTTPS Error 404 - Not Found
Trying other mirror.


  One of the configured repositories failed (2ndQuadrant packages (PG12) 
for 2 - x86_64),
  and yum doesn't have enough cached data to continue. At this point the 
only
  safe thing yum can do is fail. There are a few ways to work "fix" this:

      1. Contact the upstream for the repository and get them to fix the 
problem.

      2. Reconfigure the baseurl/etc. for the repository, to point to a 
working
         upstream. This is most often useful if you are using a newer
         distribution release than is supported by the repository (and the
         packages for the previous distribution release still work).

      3. Run the command with the repository temporarily disabled
             yum --disablerepo=2ndquadrant-dl-default-release-pg12 ...

      4. Disable the repository permanently, so yum won't use it by 
default. Yum
         will then just ignore the repository until you permanently 
enable it
         again or use --enablerepo for temporary usage:

             yum-config-manager --disable 
2ndquadrant-dl-default-release-pg12
         or
             subscription-manager repos 
--disable=2ndquadrant-dl-default-release-pg12

      5. Configure the failing repository to be skipped, if it is 
unavailable.
         Note that yum will try to contact the repo. when it runs most 
commands,
         so will have to try and fail each time (and thus. yum will be 
be much
         slower). If it is a very temporary problem though, this is 
often a nice
         compromise:

             yum-config-manager --save 
--setopt=2ndquadrant-dl-default-release-pg12.skip_if_unavailable=true

failure: repodata/repomd.xml from 2ndquadrant-dl-default-release-pg12: 
[Errno 256] No more mirrors to try.
https://dl.2ndquadrant.com/default/release/rpm/packages/amzn/2/x86_64/12/repodata/repomd.xml: 
[Errno 14] HTTPS Error 404 - Not Found