[SOLVED] Postgresql 9.4 issue on RHEL 7

bluforce · 04-29-2019, 02:43 PM

We are having issues installing postgresql 9.4 on RHEL 7 (3.10.0-957.1.3.el7.x86_64).

Since we are behind a proxy, we had to download the rpm (pgdg-redhat94-9.4-3.noarch.rpm) and install. However, when we install postgresql (yum install postgresql94), we see an error.

It looks like something is up with the repo:

Code:

yum update
Loaded plugins: langpacks, product-id, rhnplugin, search-disabled-repos, subscription-manager
This system is receiving updates from RHN Classic or Red Hat Satellite.
https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-%24releasever-x86_64/repodata/repomd.xml: [Errno 14] HTTPS Error 404 - Not Found
Trying other mirror.
To address this issue please refer to the below knowledge base article

https://access.redhat.com/articles/1320623

If above article doesn't help to resolve this issue please open a ticket with Red Hat Support.

One of the configured repositories failed (PostgreSQL 9.4 $releasever - 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=pgdg94 ...

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 pgdg94
or
subscription-manager repos --disable=pgdg94

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=pgdg94.skip_if_unavailable=true

failure: repodata/repomd.xml from pgdg94: [Errno 256] No more mirrors to try.
https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-$releasever-x86_64/repodata/repomd.xml: [Errno 14] HTTPS Error 404 - Not Found

If I goto this URL in a browser, I get a 404 error.
https://download.postgresql.org/pub/...ata/repomd.xml

Should I try modifying something in my yum.repos, or is this something on the postgresql-repo side?
Thanks

MensaWater · 04-29-2019, 03:20 PM

yum is designed to work with repositories to download needed dependencies. You've already said you can't do that so instead you'd need to use rpm to install the download packages. You'd have to find the entire set from Postgres' site (they have RPMs for most things) and download them.

In the directory you download them you run "rpm -ivh <file1.rpm> <file2.rpm> etc...".

Note that any dependencies needed would likewise have to be downloaded. Also it is possible you'd have some cross-dependencies that would cause you to need to temporarily uninstall older packages then download and reinstall as part of your rpm command line. I recently ran into this while doing various Postgres 11.02 packages on RHEL6 & RHEL7.

You can, by the way, get the RPMs for Postgres 11.02 from Postgres' own site. It looks to me like the Postgres available from RedHat is 9.2 so maybe you did download 9.4 from Postgres' site? Any reason why you don't want to get later version if so?

bluforce · 04-29-2019, 03:32 PM

Thank you for your reply. Our developers wanted ver 9.4 so thats why we're downloading that version. We did just find out why this was happening. In the /etc/yum.repos.d/pgdg-94-redhat.repo file, we had to replace all occurrences of "$releasever" with "7".