Package Details: pgadmin4-desktop 9.8-1

Git Clone URL: https://aur.archlinux.org/pgadmin4-desktop.git (read-only, click to copy)
Package Base: pgadmin4-desktop
Description: The desktop user interface for pgAdmin. pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
Upstream URL: https://www.pgadmin.org/
Licenses: PostgreSQL
Provides: pgadmin4-desktop
Submitter: bko
Maintainer: alllexx88
Last Packager: alllexx88
Votes: 16
Popularity: 3.23
First Submitted: 2024-07-06 13:39 (UTC)
Last Updated: 2025-09-21 13:33 (UTC)

Latest Comments

1 2 3 Next › Last »

lzx3in commented on 2025-09-24 08:30 (UTC) (edited on 2025-09-24 08:31 (UTC) by lzx3in)

I've been working with the source build version provided by @maroider for a while, and it's quite good.

I'm glad to see that a new version has been released in the AUR, but I've encountered a previous issue again:

Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT

After checking, I found that /usr/pgadmin4/venv/bin/python3 is a soft link pointing to /usr/bin/python3.12, but my Python3 has been updated to version 3.13.

Clearly, under the current packaging strategy that reuses .deb files, we can never completely resolve this issue. It would be better to switch to using source builds from now on.

lzx3in commented on 2025-09-24 07:59 (UTC)

@whiteman808 The issue occurs because the sha256sums value in the latest PKGBUILD file is incorrect. You can fix this by updating the PKGBUILD with the correct checksum and then rebuilding the package using makepkg -si. The correct sha256sum can be obtained by running the command sha256sum filename.

whiteman808 commented on 2025-09-21 17:26 (UTC)

==> Making package: pgadmin4-desktop 9.8-1 (Sun Sep 21 19:23:49 2025)
==> Retrieving sources...
  -> Downloading pgadmin4-desktop-9.8-x86_64.deb...
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 84.2M  100 84.2M    0     0  1593k      0  0:00:54  0:00:54 --:--:-- 7963k
==> Validating source files with sha256sums...
    pgadmin4-desktop-9.8-x86_64.deb ... FAILED
==> ERROR: One or more files did not pass the validity check!
==> ERROR: Could not download sources.
error: failed to download sources for 'pgadmin4-desktop-9.8-1': failed to run: makechrootpkg -cu -r /var/lib/aurbuild/x86_64 -D /home/whiteman808/arch_paczuchy -d /var/cache/pacman/pkg/ -- -ofA --nosign

kshksdrt commented on 2025-08-30 20:19 (UTC)

Installing using pipx automatically installs it in a virtual environment for you. So basically just pipx install pgadmin4 instead of pip install pgadmin4. You might want to install pipx to do that.

maroider commented on 2025-08-15 21:37 (UTC)

I also had what appears to have been the same problem as @lzx3in, but the proposed fix by @friday13 didn't work for me. Maybe I did it wrong? Either way. I ended up making my own PKGBUILD that builds the application from source, rather than modifying a pre-built .deb archive. The PKGBUILD skips building some things I didn't need like documentation and an SBOM, but it works well enough for my needs.

I've attached the link just in case it's useful to anyone else.

https://github.com/maroider/arch-pkgs/tree/aecd4a058861a43d66a4941e5b2a1cfb932ed739/pgadmin4

friday13 commented on 2025-08-14 23:13 (UTC)

I encountered the same problem as @lzx3in. According to this official document, a virtual environment is required. It seems that the error is originating from this or that the virtual environment has been created in the wrong directory.

https://www.pgadmin.org/download/pgadmin-4-python/ example

$ sudo mkdir /var/lib/pgadmin
$ sudo mkdir /var/log/pgadmin
$ sudo chown $USER /var/lib/pgadmin
$ sudo chown $USER /var/log/pgadmin
$ python3 -m venv pgadmin4
$ source pgadmin4/bin/activate
(pgadmin4) $ pip install pgadmin4

lzx3in commented on 2025-08-01 07:54 (UTC) (edited on 2025-08-01 07:56 (UTC) by lzx3in)

Can this issue be resolved in the PKGBUILD or upstream?

The pgAdmin 4 server could not be contacted:

pgAdmin Runtime Environment

Python Path: "/usr/pgadmin4/venv/bin/python3" Runtime Config File: "/home/lzx/.config/pgadmin4/config.json" Webapp Path: "/usr/pgadmin4/web/pgAdmin4.py" pgAdmin Command: "/usr/pgadmin4/venv/bin/python3 -s /usr/pgadmin4/web/pgAdmin4.py" Environment: • ELECTRON_OZONE_PLATFORM_HINT: wayland

• HOME: /home/lzx

• LANG: en_US.UTF-8

• LOGNAME: lzx

• PATH: /home/lzx/.cargo/bin:/usr/local/sbin:/usr/local/bin:/usr/bin:/usr/lib/jvm/default/bin:/usr/bin/site_perl:/usr/bin/vendor_perl:/usr/bin/core_perl

• SHELL: /usr/bin/zsh

• USER: lzx

• XDG_RUNTIME_DIR: /run/user/1000

• DBUS_SESSION_BUS_ADDRESS: unix:path=/run/user/1000/bus

• DEBUGINFOD_URLS: https://debuginfod.archlinux.org

• DESKTOP_SESSION: plasma

• DISPLAY: :1

• GTK2_RC_FILES: /etc/gtk-2.0/gtkrc:/home/lzx/.gtkrc-2.0:/home/lzx/.config/gtkrc-2.0

• GTK_RC_FILES: /etc/gtk/gtkrc:/home/lzx/.gtkrc:/home/lzx/.config/gtkrc

• ICEAUTHORITY: /run/user/1000/iceauth_rVJEbY

• KDE_APPLICATIONS_AS_SCOPE: 1

• KDE_FULL_SESSION: true

• KDE_SESSION_UID: 1000

• KDE_SESSION_VERSION: 6

• MAIL: /var/spool/mail/lzx

• MOTD_SHOWN: pam

• OLDPWD: /home/lzx

• PAM_KWALLET5_LOGIN: /run/user/1000/kwallet5.socket

• PWD: /home/lzx

• QT_WAYLAND_RECONNECT: 1

• SESSION_MANAGER: local/home-desktop-arch-01:@/tmp/.ICE-unix/1277,unix/home-desktop-arch-01:/tmp/.ICE-unix/1277

• WAYLAND_DISPLAY: wayland-0

• XAUTHORITY: /run/user/1000/xauth_yevQQg

• XDG_CONFIG_DIRS: /home/lzx/.config/kdedefaults:/etc/xdg

• XDG_CURRENT_DESKTOP: KDE

• XDG_MENU_PREFIX: plasma-

• XDG_SEAT: seat0

• XDG_SEAT_PATH: /org/freedesktop/DisplayManager/Seat0

• XDG_SESSION_CLASS: user

• XDG_SESSION_DESKTOP: KDE

• XDG_SESSION_ID: 2

• XDG_SESSION_PATH: /org/freedesktop/DisplayManager/Session1

• XDG_SESSION_TYPE: wayland

• XDG_VTNR: 1

• MANAGERPID: 1081

• INVOCATION_ID: 6582ed9a45a2400cbf38a756b1bb405f

• JOURNAL_STREAM: 9:12726

• SYSTEMD_EXEC_PID: 1312

• MEMORY_PRESSURE_WATCH: /sys/fs/cgroup/user.slice/user-1000.slice/user@1000.service/session.slice/plasma-plasmashell.service/memory.pressure

• MEMORY_PRESSURE_WRITE: c29tZSAyMDAwMDAgMjAwMDAwMAA=

• CHROME_DESKTOP: pgadmin4.desktop

• ORIGINAL_XDG_CURRENT_DESKTOP: KDE

• ELECTRON_ENABLE_SECURITY_WARNINGS: false

• GDK_BACKEND: wayland

• NO_AT_BRIDGE: 1

• PGADMIN_INT_PORT: 39447

• PGADMIN_INT_KEY: 7b441ed4-5958-47ae-a5b2-a995e74b42a9

• PGADMIN_SERVER_MODE: OFF


Total spawn time to start the pgAdmin4 server: 0.005 Sec Failed to launch pgAdmin4. Error: Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT

chillie commented on 2025-07-30 12:39 (UTC)

can you update this to latest version? thanks.

soorajsp commented on 2025-05-27 13:45 (UTC)

While cleaning up install, this comes in the terminal.

==> Tidying install...
  -> Removing libtool files...
  -> Purging unwanted files...
  -> Removing static library files...
  -> Stripping unneeded symbols from binaries and libraries...
readelf: Warning: Gap in build notes detected from 0xbbda to 0x6120f