From: S Bob <sbob@quadratum-braccas.com>
To: pgsql-admin@lists.postgresql.org
Subject: pglogical repo fails for amazon linux
Date: Thu, 25 Feb 2021 16:28:09 -0700
Message-ID: <5095f7ce-a3e0-6fee-6cb6-28fb0d3e5c19@quadratum-braccas.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sbob@quadratum-braccas.com, pgsql-admin@lists.postgresql.org
Subject: Re: pglogical repo fails for amazon linux
In-Reply-To: <5095f7ce-a3e0-6fee-6cb6-28fb0d3e5c19@quadratum-braccas.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox