Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.

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 <daulat(dot)dba(at)gmail(dot)com>:

> 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(at)gmail(dot)com> wrote:
>
>> Hello Daulat,
>>
>> I just ran the pgAdmin4 setup on my Ubuntu VM and followed the steps
>> mentioned at this link <https://www.pgadmin.org/download/pgadmin-4-apt/>.
>> The installation and setup worked fine on my end. In my environment, Python
>> 3.10.12 is installed.
>>
>> Regards,
>> Zaid
>>
>>
>>
>>
>>
>> On Thu, May 15, 2025 at 2:19 PM Daulat <daulat(dot)dba(at)gmail(dot)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 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,
>>>
>>>
>>>