Arch Linux User Repository

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

can you update this to latest version? thanks.

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

helloooo could we please update to new major version 9

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

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

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

@joebie,@bko : After failing to start pgadmin4 from start menu, I tried to start manually like,'export PGADMIN_SERVER_MODE=OFF && /usr/pgadmin4/bin/pgadmin4 &'. After stuck at starting for a few minutes, I get following error message, Total spawn time to start the pgAdmin4 server: 0.007 Sec Traceback (most recent call last):

File "/usr/pgadmin4/web/pgAdmin4.py", line 38, in <module> import config File "/usr/pgadmin4/web/config.py", line 33, in <module> from pgadmin.utils import env, IS_WIN, fs_short_path File "/usr/pgadmin4/web/pgadmin/init.py", line 24, in <module> from flask import Flask, abort, request, current_app, session, url_for ModuleNotFoundError: No module named 'flask'

Before this, in a fresh install, I observed following.

1 in /usr/pgadmin4/venv/bin/, python3 is pointing to /usr/bin/python3.12, whereas installed version is python 3.13.

When it is so, starting pgadmin4 will not lead to it's splash screen. Just the elephant.

2 Also, in /usr/pgadmin4/venv/pyvenv.cfg, line starting with command was,

command = /usr/bin/python3 -m venv home/jenkins/*/usr/pgadmin4/venv.

After correcting 1) and 2), I get the pgadmin4 splash screen.And the error message I mentioned at the beginning.

3 I installed python flask module using pamac. But that does not solve the error. Is there any python version issue ?

@joebie I've tried PGADMIN_SERVER_MODE=OFF for and still get the same error with pgadmin4-desktop, meanwhile server package is broken IMO as /usr/pgadmin4/venv/bin/python3 is a symlink to /usr/pgadmin4/venv/bin/python3.12 which is a symlink to /usr/pgadmin4/venv/bin/python3, will point it out in pgadmin4-server repo.

@realgecko if I remember correctly I had the same problem and needed to manually start the server. Before doing that make sure you do export PGADMIN_SERVER_MODE=OFF otherwise the server will attempt to use directories outside of your home. (/usr/pgadmin4/venv/bin/python3 -s /usr/pgadmin4/web/pgAdmin4.py)

If you intend to run it system-wide look here https://www.pgadmin.org/docs/pgadmin4/development/server_deployment.html