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 1uI4zJ-00FLYi-GH for pgsql-admin@arkaria.postgresql.org; Thu, 22 May 2025 12:25:29 +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 1uI4zI-001d5g-CX for pgsql-admin@arkaria.postgresql.org; Thu, 22 May 2025 12:25:28 +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 1uI4zH-001d5V-Tj for pgsql-admin@lists.postgresql.org; Thu, 22 May 2025 12:25:27 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uI4zF-000J2z-0r for pgsql-admin@lists.postgresql.org; Thu, 22 May 2025 12:25:26 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-6006cf5000aso1156791a12.0 for ; Thu, 22 May 2025 05:25:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1747916724; x=1748521524; 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=4vOGFbnQGNNqbR3PRI3P6mkORS9oRLduQoiy90CoUto=; b=m7D9lYwn0vSXsqHGU2ZXSBFcVTGti9kzHteu/RtvIu3qogMl5cWDCcyMfhTydOAppp HmZTxur/tkrLYfAsrRuEdcVDUO7ZWRWAKkTYnPKlcjzKbnWH/uKUhZ1wa9+vT2YEmCAI Eoq7O6U8R2JkdhbsyiZAc0PCGm0vG486OqkmIgUyTjWz1mGLSvn9NzkNqmDO9865p/Q1 tmOI81x/uFFUOa2LXqM49hPJYbVwXO6EsQcvVgIJMZJ47Geux3SyAnSGBiia4eFoCVri UORfLYJiOM+9lxr4bDuBJWu8sKErVzkVSXY4s+GqJYW+uWNWrhN9llMlO4yYhn25uF2Y oNBA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747916724; x=1748521524; 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=4vOGFbnQGNNqbR3PRI3P6mkORS9oRLduQoiy90CoUto=; b=qEkATGYYAK5n2RRRsc0zrOx/ODP25IT/oygavJrSn7gA8pczMKd/Z+CfKmzdDhZlst 7aCsEsAiMR9mA44S1HBiWKDyFWaHKt/OBvdNL1TBTPEp4rbp1hlsl243fUXNXoKVfX6I O9lG9zOoHh/4iFJRLtkftQ0lVZcG6hV6qFI2GmNM3VQJfbk1hN7XNNPVfcWLpKPeycEW eggkBMbng4ozlzuArwLRWKOlmYeHJesiqr9b31BAqDgEVxos5wiwNQzy/4X3Ftbim+TV Mi12PgYoqzz/StYwirg+/fEnkDvwUphRhM7rHMcCIKftKYUEuAQlsT5m97bop9ENJJfY qVGQ== X-Gm-Message-State: AOJu0Ywh9Qnt4Av6Z/zuYo5T4qCFAOaLYDVNuw9SiScWio13GM9Jg450 dYClQuTGoz4a8bPSXQY5jD9U3Xkgeez4ogYcZ4SQ5tfgWDvk2b1ELUAFadqra6g+XKOnwl86Ugf K0LdQ5jTKZ3Gq749u231cfnpYyY72jC+p0eG8ulI= X-Gm-Gg: ASbGnctVMao4hgV+Ph8AxdlkFREARCK8LohwEP7UTrCD2Jlg7HvZkKTv1lmav5haiC+ lsCob9SMnfOsawi1HBV6pK7d5NpMuc2UXmoMec9Ngesq645hUo8fZ+gSoxUZvx4ELQhMajAQUyf IBITMVc1I4F8kSVYJkalj/SvEW0P199ydR+A== X-Google-Smtp-Source: AGHT+IGWBfTcOVqWdANlemWwuoo7e6L1+Yn552CJzeM3sgUVKkHDrQhSBJ8uVwl6SnJFEYy8kXzLgGNipLF81zEt+Q0= X-Received: by 2002:a17:906:4590:b0:ad5:1bd7:d122 with SMTP id a640c23a62f3a-ad52d447cdcmr703657566b.2.1747916723674; Thu, 22 May 2025 05:25:23 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Daulat Date: Thu, 22 May 2025 17:55:12 +0530 X-Gm-Features: AX0GCFvG3qXKw5-89vUw3-KFfQ13-OUIP-o_M6aA5ebFAmHTo1y4qjvX5PyZNkg Message-ID: Subject: Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. To: zaidagilist Cc: pgsql-admin Content-Type: multipart/alternative; boundary="0000000000006967e70635b89306" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006967e70635b89306 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=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': 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 =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 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=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, Pyth= on > 3.10.12 is installed. > > Regards, > Zaid > > > > > > On Thu, May 15, 2025 at 2:19=E2=80=AFPM Daulat wro= te: > >> 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.py >> 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, >> >> >> --0000000000006967e70635b89306 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks = Zaid,

I will try the same steps on a new machine later.= =C2=A0
For now, I attempted to upgrade pgAdmin from version 6.7 t= o 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 t= he browser. I followed the steps listed below. Could you please advise on w= hat I might have missed?

-------------
<= div>Upgrade Steps:
-------------

sudo ap= t 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 s= h -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': Directo= ry not empty
dpkg: warning: unable to delete old directory '/= etc/ubuntu-advantage': Directory not empty

dpk= g: warning: unable to delete old directory '/var/lib/fwupd': Direct= ory not empty

sudo /usr/pgadmin4/bin/setup-web.sh<= /div>

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 en= abling the wsgi module and configuring the pgAdmin 4 application to mount a= t /pgadmin4. Do you wish to continue (y/n)? y
The Apache web serv= er is running and must be restarted for the pgAdmin 4 installation to compl= ete. 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]<= /div>
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]
pgadmi= n4/pgadmin4,now 9.2 all [installed]

=
On Thu, May 22, 2025 at 2:32=E2=80=AFPM zaidagilist <zaidagilist@gmail.com> wrote:
<= /div>
Hel= lo Daulat,

I just ran the pgAdmin4 setup on my Ubuntu VM and followe= d the steps mentioned at this link. The installation and setup worke= d fine on my end. In my environment, Python 3.10.12 is installed.

<= /div>
Regards,
Zaid





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


--0000000000006967e70635b89306--