Package Details: pgadmin4-desktop 9.4-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: mateushonorato
Last Packager: mateushonorato
Votes: 14
Popularity: 2.18
First Submitted: 2024-07-06 13:39 (UTC)
Last Updated: 2025-06-22 00:35 (UTC)

Latest Comments

1 2 Next › Last »

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

erikd234 commented on 2025-04-27 03:19 (UTC)

helloooo could we please update to new major version 9

sashank commented on 2025-04-06 13:49 (UTC)

@PBhat, They have the download archive here: https://pgadmin-archive.postgresql.org/

I figure you can use this PKGBUILD script as a guide to set up the specific version that's compatible with your version of postgreSQL.

PBhat commented on 2025-03-04 08:09 (UTC)

@MaximGun, You are right. But alas, with your help I can run pgadmin4, but this version of pgadmin4 cannot connect to postgres 8 / postgres 9 versions ! It expects replication_nodes, which are not available on PG8 / PG9.

MaximGun commented on 2025-02-21 14:12 (UTC) (edited on 2025-02-21 14:13 (UTC) by MaximGun)

Installing AUR package python312 will allow pgadmin to run successfully. It can be installed alongside the core python package.