Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uK1g4-00BqST-Dt for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 21:17:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uK1g2-00B8qM-Tg for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 21:17:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uK1g2-00B8lk-9s for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 21:17:38 +0000 Received: from mail-pg1-x52e.google.com ([2607:f8b0:4864:20::52e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uK1g0-000GLu-0R for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 21:17:37 +0000 Received: by mail-pg1-x52e.google.com with SMTP id 41be03b00d2f7-b26f01c638fso3092814a12.1 for ; Tue, 27 May 2025 14:17:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748380655; x=1748985455; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=k2LrtHin2kF1ZnL07TzEO6svim3whopXcgDDHh9ojDo=; b=UgpQgtfuWlGXD3m6qg+BdUZpP58gpPbmrhXf8+61gcInUx7uT2jvvxRFzGdvW2+OJb s2Ae0N71EpohLHYkEO4WGBfC9CSjvQg4H/gmTHqvzd7uAvwrba/4tILCSD5AWgUR4ScJ 3Ma6RCx4LdEG7yYy4ZtjsgQL0GcpVJg2CjXpRivmevhl8gvRpTIOmFCTP4U/NZQxX9sK qhNf1xaDHPOyTJy2AXYGGInMAZSnvluV2xDgAgpN/kTglT87TTJdx9jgkB9GxOKMsTrb 7IAdGAgKziNx3pdX8NH2ERbCl9PC0qwiKs/jFlQz39WmucK9PCsiIobVTfq93z0mGJyG +YOA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748380655; x=1748985455; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=k2LrtHin2kF1ZnL07TzEO6svim3whopXcgDDHh9ojDo=; b=vdY0b3TKO32T2X+6ExqRWiTW65UFClyC9aD5c5nyWP5EpZqKQXwq4YBCBiyocRpTpx wbETdUn3snhM+JygLxg6co+B1jlmuBYXgh9PNDyVhNtBO5rXNstNBkhsZ/Dq+RqwX86N tAuRFmkkU5DY9X97htXOToxzfcWmS2gn/1r7AmU3W2rR2yAlSxTXhBDcLhAK7UXc3XjP RSn1an921U3rOitqjrvF+wOot4cM1wXw3uogPw0W6CeVgqG6Soj+BLtO9ZWO97Cu7i5L v7zOQSHiyAgf2Q7nqQcOUDkuJvVAcJn13ZNyRu8yJqj/IL+7PyWQcJCuQOmrSGZLJWfi CHvw== X-Forwarded-Encrypted: i=1; AJvYcCUbW+e7vW3IzRgWn4Oa2L6YkYzDVgW3macjNYCLRofzK4wrzsf747otDjIcKM1hVrdnOYuqLaMv9fhNQg==@lists.postgresql.org X-Gm-Message-State: AOJu0YynvWXaFARqL0mIOp65iZ9lEL70Aa2xH8P3u7aWHTpRjXHsisZA yRXWUs8VEnT28TpETV/Ddfg+09QS/bWg8N+zCGxgR4mfsgK8D2SZgYiVofvA2Bj0VB/PICGyuIr mnW1Y+TVBUTFMxyvm6fJtXuGf1MY5G6Y= X-Gm-Gg: ASbGnct+SbYCkdWCDwAC1/vl5Xpu8ijkzHaYRtKBTOtBSARUOOjVsizT4Tz0XRD0AQf P2aen2TNdLglfwai6Fl9mQmiSW3w3abU0A9abigS89U7IV817Daaq25E6ULi6x/DhbkIwxxFzS2 /lz3yLBWEMYv6fV6wm3vMfjTuTOXOiVqGe9zaMh1OCZA4LYg6UoNdQWhTw/umBRUQ= X-Google-Smtp-Source: AGHT+IG7j19X5E2Ao5F9XQtaxTKIrJT7WQoCd39C7qt+h2anBRRWVLXAwl9blWfpVr9fSmQyZec5+JHPDyN201OSISU= X-Received: by 2002:a17:90b:1dca:b0:311:c939:c859 with SMTP id 98e67ed59e1d1-311c939c93fmr3407790a91.30.1748380654610; Tue, 27 May 2025 14:17:34 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Usman Khan Date: Wed, 28 May 2025 02:17:22 +0500 X-Gm-Features: AX0GCFsMac5LfjNpvr-_-9ChQR-jftOvXW9Q6yyFMdRRsIDjvvyrg9VWYTqo9iQ Message-ID: Subject: Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. To: =?UTF-8?Q?Roland_M=C3=BCller?= Cc: Daulat , zaidagilist , pgsql-admin Content-Type: multipart/alternative; boundary="000000000000d9ae8006362497b0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d9ae8006362497b0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thanks Yes, pgAdmin 4 is supported till version 9.2 on ubuntu 20.04. Its supported platforms and versions detail(for debain & ubuntu) can be found on following link https://www.pgadmin.org/download/pgadmin-4-apt On Wed, May 28, 2025 at 1:26=E2=80=AFAM Roland M=C3=BCller wrote: > Slightly OT, but only slightly: > Standard security maintenance Ubuntu 20.04 will end in May 2025 thus in > some days (https://ubuntu.com/about/release-cycle). Unless you do not > have any special reason it is advised to upgrade to a newer release of > Ubuntu. > > In my Ubuntu PC running 22.04 I installed using apt and have version 9.3. > that installed without any issue apt. > > $ apt list --installed pgadmin\* > pgadmin4-desktop/pgadmin4,now 9.3 amd64 [installed] > pgadmin4-server/pgadmin4,now 9.3 amd64 [installed,automatic] > > BR, > Roland > > Am Do., 22. Mai 2025 um 15:25 Uhr schrieb Daulat : > >> 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 w= hat >> 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=3D/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': Director= y >> 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 >> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >> >> 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 mo= unt >> 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=E2=80=AFPM zaidagilist >> 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, Py= thon >>> 3.10.12 is installed. >>> >>> Regards, >>> Zaid >>> >>> >>> >>> >>> >>> On Thu, May 15, 2025 at 2:19=E2=80=AFPM Daulat w= rote: >>> >>>> 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 directory >>>> >>>> ls -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 venv >>>> >>>> Since 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.p= y >>>> file in /usr/pgadmin4/web/ >>>> >>>> sudo python3.8 -m venv /usr/pgadmin4/venv >>>> source /usr/pgadmin4/venv/bin/activate >>>> >>>> I followed the following steps from >>>> https://www.pgadmin.org/download/pgadmin-4-apt/ >>>> >>>> Please advise. >>>> >>>> Thanks, >>>> >>>> >>>> --000000000000d9ae8006362497b0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks
Yes, pgAdmin 4 is supported till ver= sion 9.2 on ubuntu 20.04. Its supported platforms and versions detail(for d= ebain & ubuntu) can be found on following link







On We= d, May 28, 2025 at 1:26=E2=80=AFAM Roland M=C3=BCller <rolmur@gmail.com> wrote:
S= lightly OT, but only slightly:
Standard security maintenance Ubuntu 20= .04 will end in May 2025 thus in some days (https://ubuntu.com/about/release-cycl= e). Unless you do not have any special reason it is advised to upgrade = to a newer release of Ubuntu.

In my Ubuntu PC running 22= .04 I installed using apt and have version 9.3. that installed without any = issue apt.

$ apt list --installed pgadmin\*
pga= dmin4-desktop/pgadmin4,now 9.3 amd64 [installed]
pgadmin4-server/pgadmin= 4,now 9.3 amd64 [installed,automatic]

BR,
Roland

Am Do., 22. Mai 2025 um 15:25=C2=A0Uhr schrieb Daulat <= ;daulat.dba@gmail= .com>:
Thanks Za= id,

I will try the same steps on a new machine later.=C2= =A0
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 u= pdate
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

o= ptional: sudo sh -c 'echo "deb [signed-by=3D/usr/share/keyrings/pa= ckages-pgadmin-org.gpg] https://ftp.postgresql.org/pub/pgadmin= /pgadmin4/apt/focal pgadmin4 main" > /etc/apt/sources.list.d/pg= admin4.list'

sudo apt upgrade pgadmin4

dpkg: warning: unable to delete old directory '/var/l= ib/ubuntu-advantage': Directory not empty
dpkg: warning: unab= le to delete old directory '/etc/ubuntu-advantage': Directory not e= mpty

dpkg: warning: unable to delete old directory= '/var/lib/fwupd': Directory not empty

sud= o /usr/pgadmin4/bin/setup-web.sh

Setting up pgAdmi= n 4 in web mode on a Debian based platform...
Creating configurat= ion database...
pgAdmin 4 - Application Initialisation
= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Creating s= torage 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 th= e pgAdmin 4 installation to complete. Continue (y/n)? y
Apache su= ccessfully restarted. You can now start using pgAdmin 4 in web mode at http://127.0.0.1/pgadmi= n4


Verification:
--------------

apt list --installed | grep = pgadmin4

WARNING: apt does not have a stable CLI i= nterface. Use with caution in scripts.

libpq-dev/p= gadmin4,now 17.4-1.pgdg20.04+2 amd64 [installed]
libpq5/pgadmin4,= now 17.4-1.pgdg20.04+2 amd64 [installed,automatic]
pgadmin4-deskt= op/pgadmin4,now 9.2 amd64 [installed,automatic]
pgadmin4-server/p= gadmin4,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=E2=80= =AFPM zaidagilist <zaidagilist@gmail.com> wrote:
Hello Daulat,

I just ran= the pgAdmin4 setup on my Ubuntu VM and followed the steps mentioned at thi= s link. The installation and setup worked fine on my end. In my envi= ronment, Python 3.10.12 is installed.

Regards,
Zaid





On Thu, May 15, 2025 at 2:19=E2=80=AFPM Daul= at <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:=C2=A0

/usr/pgadmi= n4/venv/bin/python3: can't open file '/usr/pgadmin4/web/setup.py= 9;: [Errno 2] No such file or directory

ls -l /usr/pgadmi= n4
total 24
drwxr-xr-x 4 root root =C2=A04096 May 15 09:01 bin
-rw= -r--r-- 1 root root 11206 Apr =C2=A02 10:26 sbom-desktop.json
-rw-r--r--= 1 root root =C2=A0 474 Apr =C2=A02 10:26 sbom-web.json
drwxr-xr-x 6 roo= t root =C2=A04096 May 15 08:58 venv

Since the = pgAdmin installation did not automatically create the required virtual envi= ronment, I manually set it up using python3.8 -m venv /usr/pgadmin4/venv, b= ut the setup still fails due to a missing setup.py file in /usr/pgadmin4/we= b/

sudo python3.8 -m venv /usr/pgadmin4/venv
so= urce /usr/pgadmin4/venv/bin/activate

I followed th= e following steps=C2=A0from=C2=A0

Please advise.
<= br>
Thanks,


--000000000000d9ae8006362497b0--