pglogical repo fails for amazon linux

From: S Bob <sbob(at)quadratum-braccas(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pglogical repo fails for amazon linux
Date: 2021-02-25 23:28:09
Message-ID: 5095f7ce-a3e0-6fee-6cb6-28fb0d3e5c19@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Dan Smith 2021-02-26 06:13:17 Re: Aurora PostgreSQL Support
Previous Message Celia McInnis 2021-02-25 22:06:20 Trouble after crashing postgresql