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

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 AM Roland Müller <rolmur(at)gmail(dot)com> 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 <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,
>>>>
>>>>
>>>>