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> 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

On your system, that is getting resolved to:

https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/redhat/rhel-2-x86_64

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

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
>
> However there was no solution listed.
>
> Thanks again.
>
> <https://stackoverflow.com/questions/69108475/install-pgadmin-4-on-amazon-linux-2>
> postgresql - Install pgAdmin 4 on Amazon Linux 2 - Stack Overflow
> <https://stackoverflow.com/questions/69108475/install-pgadmin-4-on-amazon-linux-2>
> 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
>
>
> ------------------------------
> *From:* Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
> *Sent:* Friday, December 17, 2021 4:00 AM
> *To:* enderjsv Hurd <enderjsv(at)hotmail(dot)com>
> *Cc:* 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,
>
> 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%7C815e8ccc247f4fc14c4d08d9c111d08d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637753104538817256%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=gWGHfYrL79InZnT%2BeKwDWWY17EWhfZcHYrF7wLFANs8%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>
> 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.
>
>
>
> Sent from my iPhone
>
> On Dec 16, 2021, at 9:48 AM, enderjsv Hurd <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%7C815e8ccc247f4fc14c4d08d9c111d08d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637753104538817256%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=gWGHfYrL79InZnT%2BeKwDWWY17EWhfZcHYrF7wLFANs8%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%7C815e8ccc247f4fc14c4d08d9c111d08d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637753104538974079%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=dCGVBmJ0rVTkegKrFvuySmQSbnlIZRpZR1dg55dAWBY%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%7C815e8ccc247f4fc14c4d08d9c111d08d%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637753104538974079%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=siNjVo%2BtykX%2FEHTG5oTosmatyx9qH%2BxfhT670v8yNEQ%3D&reserved=0>
> "Don't Complain about Heat, Plant a TREE"
>

--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com