Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. - Mailing list pgsql-admin
| From | Daulat |
|---|---|
| Subject | Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. |
| Date | |
| Msg-id | CALfOM6L6YOkG8E5rot478Z095sMMub2fRZwkbhr+Mn0S8XTfbQ@mail.gmail.com Whole thread Raw |
| In response to | Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. (zaidagilist <zaidagilist@gmail.com>) |
| List | pgsql-admin |
Thanks Zaid,
I will try the same steps on a new machine later.
For now, I attempted to upgrade pgAdmin from version 6.7 to 9.2 on a VM running Ubuntu 20.04 (Focal). Although the upgrade to version 9.2 was completed, pgAdmin still shows version 6.7 when accessed through the browser. I followed the steps listed below. Could you please advise on what I might have missed?
-------------
Upgrade Steps:
-------------
sudo apt update
sudo apt list pgadmin4
curl -fsS https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/packages-pgadmin-org.gpg
optional: sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list'
sudo apt upgrade pgadmin4
dpkg: warning: unable to delete old directory '/var/lib/ubuntu-advantage': Directory not empty
dpkg: warning: unable to delete old directory '/etc/ubuntu-advantage': Directory not empty
dpkg: warning: unable to delete old directory '/var/lib/fwupd': Directory not empty
sudo /usr/pgadmin4/bin/setup-web.sh
Setting up pgAdmin 4 in web mode on a Debian based platform...
Creating configuration database...
pgAdmin 4 - Application Initialisation
======================================
Creating storage and log directories...
We can now configure the Apache Web server for you. This involves enabling the wsgi module and configuring the pgAdmin 4 application to mount at /pgadmin4. Do you wish to continue (y/n)? y
The Apache web server is running and must be restarted for the pgAdmin 4 installation to complete. Continue (y/n)? y
Apache successfully restarted. You can now start using pgAdmin 4 in web mode at http://127.0.0.1/pgadmin4
Verification:
--------------
apt list --installed | grep pgadmin4
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
libpq-dev/pgadmin4,now 17.4-1.pgdg20.04+2 amd64 [installed]
libpq5/pgadmin4,now 17.4-1.pgdg20.04+2 amd64 [installed,automatic]
pgadmin4-desktop/pgadmin4,now 9.2 amd64 [installed,automatic]
pgadmin4-server/pgadmin4,now 9.2 amd64 [installed,automatic]
pgadmin4-web/pgadmin4,now 9.2 all [installed,automatic]
pgadmin4/pgadmin4,now 9.2 all [installed]
On Thu, May 22, 2025 at 2:32 PM zaidagilist <zaidagilist@gmail.com> wrote:
Hello Daulat,
I just ran the pgAdmin4 setup on my Ubuntu VM and followed the steps mentioned at this link. The installation and setup worked fine on my end. In my environment, Python 3.10.12 is installed.Regards,ZaidOn Thu, May 15, 2025 at 2:19 PM Daulat <daulat.dba@gmail.com> wrote:Hello Team,I am currently facing an issue while installing pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.Error:/usr/pgadmin4/venv/bin/python3: can't open file '/usr/pgadmin4/web/setup.py': [Errno 2] No such file or directoryls -l /usr/pgadmin4
total 24
drwxr-xr-x 4 root root 4096 May 15 09:01 bin
-rw-r--r-- 1 root root 11206 Apr 2 10:26 sbom-desktop.json
-rw-r--r-- 1 root root 474 Apr 2 10:26 sbom-web.json
drwxr-xr-x 6 root root 4096 May 15 08:58 venvSince the pgAdmin installation did not automatically create the required virtual environment, I manually set it up using python3.8 -m venv /usr/pgadmin4/venv, but the setup still fails due to a missing setup.py file in /usr/pgadmin4/web/sudo python3.8 -m venv /usr/pgadmin4/venv
source /usr/pgadmin4/venv/bin/activateI followed the following steps fromPlease advise.Thanks,
pgsql-admin by date: