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 1uK0sl-00BWgx-3S for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 20:26:43 +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 1uK0sh-00ArXy-PO for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 20:26:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uK0sh-00ArXp-Ck for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 20:26:39 +0000 Received: from mail-vk1-xa31.google.com ([2607:f8b0:4864:20::a31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uK0se-000QcA-1G for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 20:26:39 +0000 Received: by mail-vk1-xa31.google.com with SMTP id 71dfb90a1353d-52413efd0d3so1259714e0c.2 for ; Tue, 27 May 2025 13:26:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748377595; x=1748982395; 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=mqzpXyPdCqOKeuzitfoZTn6XyBB4IclcdeoXvehPp2o=; b=ZM7dWxS3YZEK4VtE9cwul3a7NLQjwHAQQDHfVFSQUHjiHAunxcMUTnYesmVMu04Kfm jCoVfuguAgHMo4D+uHR9Y07P21wN5kIFwWLTptDPPDRJy3q94CR7v2cROBcNDM12aoJJ d8m90j9yIEvMTZksDFrLQW7L/8RckhLS1U0/wSXdH+ocH9zV9iA/wO2x6hbrpwlZKBgZ n6//WjcTI2vZGOs5oMeKxIxGCPTOhRlGk4sSPdAkOlMYuKebyBaNvBiLKvxjP9mTA9SJ iW7xAvAcoFCGPMtTYPsD3oy671aODqcSH2R6osCkh9MLBu65xC+YimvCMaqX+3Aewk2z ZKXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748377595; x=1748982395; 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=mqzpXyPdCqOKeuzitfoZTn6XyBB4IclcdeoXvehPp2o=; b=UKTYWjCpW/TZ0hXJtpqkYQtY7RznGmxkC+TP2ISNDKjnZjcNJ4gc8tTE/G8VRAvSrn V95DtXmQbwG4NCisRvqkja6MlsLA78RRXylSVQ2UHjV31q4rTVjF7Pqqf/jvJOaITM7h V0ocNdZ0QVKVBpWZL24tVSSqeAI67mrgys9EwvI0A3bXM33zEEND8gA1IsSkVkegIP53 5jWdvj3WjI7iTTf+2z2Gur4GFHxcLAgddzfs7UylRZ/lDqtPt+78v35a5l//pmIC6toE pC4z394VfzbNYDyrOu46yb3VUCWR1ZkNSGqYa30hSlHYoxx5AK9Ar5IpA+5f7jAJRClE 1ptw== X-Forwarded-Encrypted: i=1; AJvYcCVZ7G/V/gPalBnAqYCncVSRJNJCVvctB41UVG4DwXqnfRXyc+oiDkBU4CCQuEFWFqSbQye3rboDuMMucw==@lists.postgresql.org X-Gm-Message-State: AOJu0Yy91Z5YB9cjzsGXhg97p9X6IaL8R/PhQ/Y+5JZJqXfKUG8KUb06 iqfkdhueApMiNGZbLjJSUUbdtTgE+mL0GofcDpBkwzS98fdYtpycCsqbT9HGSCxWkf2EfOxnM4y ncdvlrN56t0X1O32+0z89mRD2bI+qkhU= X-Gm-Gg: ASbGncsdD0Scy7gUDEU9NYa5oFB7VfloNcmzlop8lW1U5fSEholOSZ5E5p5PXjPn6ET nWnS+65XC8u/R+J0yTBZgJ59CdH9CuC7m0WcQTESKPm+9Zh0GvzppimAhkJsoMVx4qH2pZds4So sjLgxZQoZeZh3GAcgS5nqeIOpFQZMwm56Uxw== X-Google-Smtp-Source: AGHT+IFkYBxINKmBXdQcz5lQIwRNrKRzvjp0CQENZLA9ISAAegJNLdLBBEg6uYazOJptq5sBsKlcjqXHPCcGscRGGGU= X-Received: by 2002:a05:6122:1822:b0:526:7f3:16e0 with SMTP id 71dfb90a1353d-52f2c4aff40mr9143237e0c.1.1748377594989; Tue, 27 May 2025 13:26:34 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: =?UTF-8?Q?Roland_M=C3=BCller?= Date: Tue, 27 May 2025 23:26:23 +0300 X-Gm-Features: AX0GCFsaxvduPxTLVSCWDSIyAyI-Gg4yNhQfb1D7FvL3ZuMzW69Vom1hUcETL4E Message-ID: Subject: Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. To: Daulat Cc: zaidagilist , pgsql-admin Content-Type: multipart/alternative; boundary="0000000000007b92ac063623e1a4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007b92ac063623e1a4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 wh= at > 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 enablin= g > 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, Pyt= hon >> 3.10.12 is installed. >> >> Regards, >> Zaid >> >> >> >> >> >> On Thu, May 15, 2025 at 2:19=E2=80=AFPM Daulat wr= ote: >> >>> Hello Team, >>> >>> I am currently facing an issue while installing pgAdmin 4 in web mode o= n >>> 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 require= d >>> 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, >>> >>> >>> --0000000000007b92ac063623e1a4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Slightly OT, but only slightly:Standard security maintenance Ubuntu 20.04 will end in May 2025 thus in so= me 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 m= y Ubuntu PC running 22.04 I installed using apt and have version 9.3. that = installed without any issue apt.

$ apt list --inst= alled pgadmin\*
pgadmin4-desktop/pgadmin4,now 9.3 amd64 [installed]
p= gadmin4-server/pgadmin4,now 9.3 amd64 [installed,automatic]

BR,
Roland

Am Do., 22. M= ai 2025 um 15:25=C2=A0Uhr schrieb Daulat <daulat.dba@gmail.com>:
=
Thanks Zaid,

I will try the same steps = on a new machine later.=C2=A0
For now, I attempted to upgrade pgA= dmin 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.pu= b | sudo gpg --dearmor -o /usr/share/keyrings/packages-pgadmin-org.gpg<= /div>

optional: sudo sh -c 'echo "deb [signed-b= y=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 ap= t 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-advan= tage': Directory not empty

dpkg: warning: unab= le 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 n= ow 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 a= nd must be restarted for the pgAdmin 4 installation to complete. Continue (= y/n)? y
Apache successfully restarted. You can now start using pg= Admin 4 in web mode at http://127.0.0.1/pgadmin4


<= /div>
Verification:
--------------

a= pt list --installed | grep pgadmin4

WARNING: apt d= oes 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,automati= c]
pgadmin4-desktop/pgadmin4,now 9.2 amd64 [installed,automatic]<= /div>
pgadmin4-server/pgadmin4,now 9.2 amd64 [installed,automatic]
pgadmin4-web/pgadmin4,now 9.2 all [installed,automatic]
pga= dmin4/pgadmin4,now 9.2 all [installed]
<= br>
On Thu,= May 22, 2025 at 2:32=E2=80=AFPM zaidagilist <zaidagilist@gmail.com> wrote:
Hell= o 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,
Zaid





On Thu, May 15, 2= 025 at 2:19=E2=80=AFPM Daulat <daulat.dba@gmail.com> wrote:
Hello Team,
<= br>
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,


--0000000000007b92ac063623e1a4--