Re: Unable to install pgadmin 4 on Amazon Linux

Never mind. Disregard previous email. Running install on desktop only seemed to have worked. Unfortunately pgadmin fails to launch with the below issue. I think I'm just going to move on for now though. It's not meant to be :)

Thank you for the responses. Here is the launch error if you are interested.

[cid:2b6c6773-2565-42e4-a58f-4d3262528405]
________________________________
From: enderjsv Hurd <EnderJSV(at)hotmail(dot)com>
Sent: Tuesday, December 21, 2021 7:44 PM
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>; pgadmin-support(at)lists(dot)postgresql(dot)org <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Unable to install pgadmin 4 on Amazon Linux

Thank you Dave. That has allowed for some progress, but now the installation seems to halt at an unexpected point without much information. If I'm correct in my assumption there should be a folder at /usr/pgadmin4 when installation is successful but that does not seem to be the case.

Here is a screenshot. Any idea what this means?

[cid:cc424996-00e7-4e8b-b3f3-3447beca4ff3]

________________________________
From: Dave Page <dpage(at)pgadmin(dot)org>
Sent: Tuesday, December 21, 2021 9:20 AM
To: enderjsv Hurd <enderjsv(at)hotmail(dot)com>
Cc: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>; pgadmin-support(at)lists(dot)postgresql(dot)org <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Unable to install pgadmin 4 on Amazon Linux

Hi

On Mon, Dec 20, 2021 at 10:29 PM enderjsv Hurd <EnderJSV(at)hotmail(dot)com<mailto:EnderJSV(at)hotmail(dot)com>> wrote:
Hi there. Thank you for the response. The operating system is Amazon-Linux, a derivative of centos7. Is this not supported?

No it's not. We've had few, if any requests for it, and adding a new platform to the supported list is expensive; we have to pay for another CI/CD instance, and perform manual smoke testing on it, which takes time.

In most cases anything that installs on centos7 also works on Amazon-Linux. Is there some issue with the script that prevents it from pointing to the correct file? As I said I checked the repository and it appears a file is missing.

There's no file missing as such. The reason it doesn't work is that the repo configuration file sets the path to:

https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/redhat/rhel-$releasever-$basearch<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fftp.postgresql.org%2Fpub%2Fpgadmin%2Fpgadmin4%2Fyum%2Fredhat%2Frhel-%24releasever-%24basearch&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=Go1ngDq0rdGSkIyjiLFlHeSKSt4TuaDkuc8CB62c7EM%3D&reserved=0>

On your system, that is getting resolved to:

https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/redhat/rhel-2-x86_64<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fftp.postgresql.org%2Fpub%2Fpgadmin%2Fpgadmin4%2Fyum%2Fredhat%2Frhel-2-x86_64&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=i9tf7C770JGdLpSYgaR%2Fd%2B06WVhaUpr%2BK0Q0cROY3DY%3D&reserved=0>

And that path doesn't exist, because there is (and never has been) a v2 of RHEL. You can *possibly* make it work by editing /etc/yum.repos.d/pgadmin4.repo and changing the path in there to:

https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/redhat/rhel-7-$basearch<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fftp.postgresql.org%2Fpub%2Fpgadmin%2Fpgadmin4%2Fyum%2Fredhat%2Frhel-7-%24basearch&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=QjWpNSByXc3TQNNFHQPSeMsUpROPPgwyUNDmT6ryzOg%3D&reserved=0>

Note the change of $releasever to 7. Then run "yum clean all && yum update". That should at least point it to the RHEL/CentOS 7 repo. The problem you may have is that Amazon isn't as strict at maintaining backwards compatibility of packages as Redhat is, so you may find that one or more of the dependencies are now (or will become) incompatible - I've run into that before when they jumped from Varnish 1.x to 2.x in a minor update, which broke the config on a bunch of servers. Granted that was a long time ago now, but it put me off using Amazon Linux permanently.

I was able to find a stack overflow entry from three months ago with the same issue.

https://stackoverflow.com/questions/69108475/install-pgadmin-4-on-amazon-linux-2<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F69108475%2Finstall-pgadmin-4-on-amazon-linux-2&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=XMkgaNQwSCr7i%2BEDCcxEdapKTPd4JDfIsAt9wa8JTsc%3D&reserved=0>

However there was no solution listed.

Thanks again.
[https://cdn.sstatic.net/Sites/stackoverflow/Img/apple-touch-icon(at)2(dot)png?v=73d79a89bded]<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F69108475%2Finstall-pgadmin-4-on-amazon-linux-2&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=XMkgaNQwSCr7i%2BEDCcxEdapKTPd4JDfIsAt9wa8JTsc%3D&reserved=0>
postgresql - Install pgAdmin 4 on Amazon Linux 2 - Stack Overflow<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F69108475%2Finstall-pgadmin-4-on-amazon-linux-2&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=XMkgaNQwSCr7i%2BEDCcxEdapKTPd4JDfIsAt9wa8JTsc%3D&reserved=0>
I'm working on setting up PostgreSQL13 and pgAdmin4 on Amazon Linux Workspace. It seems that Amazon Linux workspace is using Amazon Linux 2. The installation of PostgreSQL went really quick, but for
stackoverflow.com<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fstackoverflow.com%2F&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=a4Wp8Po720lpsjK%2FtHlEFdi3qoqRmhQDNcaBQd3mSVE%3D&reserved=0>

________________________________
From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com<mailto:aditya(dot)toshniwal(at)enterprisedb(dot)com>>
Sent: Friday, December 17, 2021 4:00 AM
To: enderjsv Hurd <enderjsv(at)hotmail(dot)com<mailto:enderjsv(at)hotmail(dot)com>>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org<mailto:pgadmin-support(at)lists(dot)postgresql(dot)org> <pgadmin-support(at)lists(dot)postgresql(dot)org<mailto:pgadmin-support(at)lists(dot)postgresql(dot)org>>
Subject: Re: Unable to install pgadmin 4 on Amazon Linux

Hi,

As mentioned in https://www.pgadmin.org/download/pgadmin-4-rpm/<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.pgadmin.org%2Fdownload%2Fpgadmin-4-rpm%2F&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=IY5G4S1DzRrtr38Fn79ubC3QBb0ethkm5JdZj1AqCzQ%3D&reserved=0>, pgAdmin supports RHEL/CentOS 7 & 8 (x86_64).
Please check your RHEL version.

On Thu, Dec 16, 2021 at 11:22 PM enderjsv Hurd <enderjsv(at)hotmail(dot)com<mailto:enderjsv(at)hotmail(dot)com>> wrote:
Adding a screenshot. Sorry for the camera pic but for reasons I’m not going to go into right now it is difficult to send a screenshot.

[cid:17ddc3d4df64211b0811]

Sent from my iPhone

On Dec 16, 2021, at 9:48 AM, enderjsv Hurd <enderjsv(at)hotmail(dot)com<mailto:enderjsv(at)hotmail(dot)com>> wrote:

Hello. I’m trying to install pgadmin4 on a Linux workspace. The official site for instructions is here. https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.pgadmin.org%2Fdownload%2Fpgadmin-4-rpm%2F&amp;data=04%7C01%7C%7Cbaef5612fe604e21502408d9c0bc3475%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637752736836864916%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=KABab3fNQ%2FC5i7tGFuSdzEYRodvftroFUVwRvAkfDl4%3D&amp;reserved=0<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.pgadmin.org%2Fdownload%2Fpgadmin-4-rpm%2F&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=IY5G4S1DzRrtr38Fn79ubC3QBb0ethkm5JdZj1AqCzQ%3D&reserved=0>

However, I encounter this issue when I attempt to install.

Failure: repodata/repomd.xml from pgAdmin4: [Errno 256] No more mirrors to try.
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fftp.postgresql.org%2Fpub%2Fpgadmin%2Fpgadmin4%2Fyum%2Fredhat%2Frhel-2-x86_64%2Frepodata%2Frepomd.xml&amp;data=04%7C01%7C%7Cbaef5612fe604e21502408d9c0bc3475%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637752736836864916%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=f87ijRZ21WmdbC%2FeTpevBsiBaL7bIMwDk4kkRwKPoD4%3D&amp;reserved=0<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fftp.postgresql.org%2Fpub%2Fpgadmin%2Fpgadmin4%2Fyum%2Fredhat%2Frhel-2-x86_64%2Frepodata%2Frepomd.xml&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=wH2UtI%2F5ZWaonrwH9JLVV6l7ubGiskDPRlf1PC4S4SE%3D&reserved=0>: [Errno 14] HTTPS 404 - Not Found

Upon checking it does appear that file is missing from the repo. Would anyone know how to solve this issue?

Thanks.

FYI this entire email was typed out from scratch on my phone. Hopefully I didn’t make any typing mistakes.

Sent from my iPhone

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fedbpostgres.com%2F&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=sgARWMzg6JwLLjVq8rANCvx7rWWuAQDw%2BYf6Y83dXec%3D&reserved=0>
"Don't Complain about Heat, Plant a TREE"

--
Dave Page
Blog: https://pgsnake.blogspot.com<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpgsnake.blogspot.com%2F&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=3DMYabweLSr6OEUEdm7C%2BncMcGaVHUiKtJsPahXyyj4%3D&reserved=0>
Twitter: @pgsnake

EDB: https://www.enterprisedb.com<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.enterprisedb.com%2F&data=04%7C01%7C%7C02a4962089dc4d8ceb2108d9c46338cd%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637756752709744156%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=dMUHRrMxtRT5%2Fi35jxBanXTXvQLbjhEyY3UzMjDtI%2Bk%3D&reserved=0>