DEV Community

Pacharapol Withayasakpunt
Pacharapol Withayasakpunt

Posted on

3 2

pgAdmin4-5.1 for Arch distros (decompiled from deb)

The link to *.pkg.tar.zst is here.

This is a temporary (?) solution to my rant. And the tarball with make + make install does not work. (And installing from pip is not as beautiful as Ubuntu.)

pgadmin4 in AUR is outdated.

$ yay -Ss pgadmin4
community/pgadmin4 4.30-1 (30.7 MiB 118.4 MiB) (Installed)
    Comprehensive design and management interface for PostgreSQL
Enter fullscreen mode Exit fullscreen mode

I am not running latest supported Ubuntu or Debian right now, so I used Docker.

FROM debian:bullseye-slim
RUN apt-get update
RUN apt-get install -y curl gnupg2 lsb-release
RUN curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | apt-key add
RUN echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt-get update
RUN apt-get install -o dir::cache::archives="/" -d -y pgadmin4
ENTRYPOINT [ "/bin/bash", "-c", "cp pgadmin4*.deb /out/" ]
Enter fullscreen mode Exit fullscreen mode

Then,

docker build -t pgadmin4-get .
docker run -v $(pwd)/out:/out pgadmin4-get
Enter fullscreen mode Exit fullscreen mode

Then, use debtap

debtap pgadmin4-server_5.1_amd64.deb
debtap pgadmin4-desktop_5.1_amd64.deb
debtap pgadmin4-web_5.1_all.deb
Enter fullscreen mode Exit fullscreen mode

However, for the last two files, we need to edit dependencies to avoid circular deps (which there is already an option in debtap).

Don't blame me for decompiling this on Manjaro Linux, though. Otherwise, do it on real Arch yourself...

Image of Timescale

Timescale – the developer's data platform for modern apps, built on PostgreSQL

Timescale Cloud is PostgreSQL optimized for speed, scale, and performance. Over 3 million IoT, AI, crypto, and dev tool apps are powered by Timescale. Try it free today! No credit card required.

Try free

Top comments (1)

Collapse
 
patarapolw profile image
Pacharapol Withayasakpunt

The release page is still alive. I have just added pgadmin4-5.7.

GitHub logo patarapolw / postgres

Essential Postgres commands

Image of Timescale

Timescale – the developer's data platform for modern apps, built on PostgreSQL

Timescale Cloud is PostgreSQL optimized for speed, scale, and performance. Over 3 million IoT, AI, crypto, and dev tool apps are powered by Timescale. Try it free today! No credit card required.

Try free

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay