public inbox for [email protected]  
help / color / mirror / Atom feed
pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
11+ messages / 6 participants
[nested] [flat]

* pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
@ 2025-05-15 09:19 Daulat <[email protected]>
  2025-05-15 09:29 ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Usman Khan <[email protected]>
  2025-05-22 09:08 ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. zaidagilist <[email protected]>
  0 siblings, 2 replies; 11+ messages in thread

From: Daulat @ 2025-05-15 09:19 UTC (permalink / raw)
  To: pgsql-admin <[email protected]>

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,


^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
  2025-05-15 09:19 pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
@ 2025-05-15 09:29 ` Usman Khan <[email protected]>
  2025-05-15 09:34   ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Khushboo Vashi <[email protected]>
  1 sibling, 1 reply; 11+ messages in thread

From: Usman Khan @ 2025-05-15 09:29 UTC (permalink / raw)
  To: Daulat <[email protected]>; pgadmin-hackers <[email protected]>

adding pgadmin-hackers and removing [email protected] for
better guidance.
Please forward all queries related to pgadmin to
[email protected]

On Thu, May 15, 2025 at 2:19 PM Daulat <[email protected]> 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,
>
>
>


^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
  2025-05-15 09:19 pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  2025-05-15 09:29 ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Usman Khan <[email protected]>
@ 2025-05-15 09:34   ` Khushboo Vashi <[email protected]>
  2025-05-15 09:46     ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Usman Khan <[email protected]>
  2025-05-15 09:47     ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  0 siblings, 2 replies; 11+ messages in thread

From: Khushboo Vashi @ 2025-05-15 09:34 UTC (permalink / raw)
  To: Usman Khan <[email protected]>; +Cc: Daulat <[email protected]>; pgadmin-hackers <[email protected]>

On Thu, May 15, 2025 at 2:59 PM Usman Khan <[email protected]> wrote:

> adding pgadmin-hackers and removing [email protected] for
> better guidance.
> Please forward all queries related to pgadmin to
> [email protected]
>
> On Thu, May 15, 2025 at 2:19 PM Daulat <[email protected]> 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/
>>
>>
The setup-web.sh file location is */usr/pgadmin4/bin, *you have
mentioned /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,
>>
>>
>>


^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
  2025-05-15 09:19 pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  2025-05-15 09:29 ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Usman Khan <[email protected]>
  2025-05-15 09:34   ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Khushboo Vashi <[email protected]>
@ 2025-05-15 09:46     ` Usman Khan <[email protected]>
  2025-05-15 09:57       ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  1 sibling, 1 reply; 11+ messages in thread

From: Usman Khan @ 2025-05-15 09:46 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: Daulat <[email protected]>; pgadmin-hackers <[email protected]>

Hi Daulat,
If you have installed it through apt package, why do you need to activate
the virtual environment? should not triggering the command alone

*/usr/pgadmin4/bin/setup-web.sh*

work for you?

On Thu, May 15, 2025 at 2:35 PM Khushboo Vashi <
[email protected]> wrote:

>
>
> On Thu, May 15, 2025 at 2:59 PM Usman Khan <[email protected]> wrote:
>
>> adding pgadmin-hackers and removing [email protected] for
>> better guidance.
>> Please forward all queries related to pgadmin to
>> [email protected]
>>
>> On Thu, May 15, 2025 at 2:19 PM Daulat <[email protected]> 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/
>>>
>>>
> The setup-web.sh file location is */usr/pgadmin4/bin, *you have
> mentioned /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,
>>>
>>>
>>>


^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
  2025-05-15 09:19 pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  2025-05-15 09:29 ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Usman Khan <[email protected]>
  2025-05-15 09:34   ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Khushboo Vashi <[email protected]>
  2025-05-15 09:46     ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Usman Khan <[email protected]>
@ 2025-05-15 09:57       ` Daulat <[email protected]>
  2025-05-15 10:18         ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Akshay Joshi <[email protected]>
  0 siblings, 1 reply; 11+ messages in thread

From: Daulat @ 2025-05-15 09:57 UTC (permalink / raw)
  To: Usman Khan <[email protected]>; +Cc: Khushboo Vashi <[email protected]>; pgadmin-hackers <[email protected]>

Yes Ushman, this is not working.

sudo /usr/pgadmin4/bin/setup-web.sh

Setting up pgAdmin 4 in web mode on a Debian based platform...
Creating configuration database...
*/usr/pgadmin4/bin/setup-web.sh: line 75: /usr/pgadmin4/venv/bin/python3:
No such file or directory*
Error setting up server mode. Please examine the output above.

On Thu, May 15, 2025 at 3:16 PM Usman Khan <[email protected]> wrote:

> Hi Daulat,
> If you have installed it through apt package, why do you need to activate
> the virtual environment? should not triggering the command alone
>
> */usr/pgadmin4/bin/setup-web.sh*
>
> work for you?
>
> On Thu, May 15, 2025 at 2:35 PM Khushboo Vashi <
> [email protected]> wrote:
>
>>
>>
>> On Thu, May 15, 2025 at 2:59 PM Usman Khan <[email protected]> wrote:
>>
>>> adding pgadmin-hackers and removing [email protected]
>>> for better guidance.
>>> Please forward all queries related to pgadmin to
>>> [email protected]
>>>
>>> On Thu, May 15, 2025 at 2:19 PM Daulat <[email protected]> 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/
>>>>
>>>>
>> The setup-web.sh file location is */usr/pgadmin4/bin, *you have
>> mentioned /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,
>>>>
>>>>
>>>>


^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
  2025-05-15 09:19 pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  2025-05-15 09:29 ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Usman Khan <[email protected]>
  2025-05-15 09:34   ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Khushboo Vashi <[email protected]>
  2025-05-15 09:46     ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Usman Khan <[email protected]>
  2025-05-15 09:57       ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
@ 2025-05-15 10:18         ` Akshay Joshi <[email protected]>
  0 siblings, 0 replies; 11+ messages in thread

From: Akshay Joshi @ 2025-05-15 10:18 UTC (permalink / raw)
  To: Daulat <[email protected]>; +Cc: Usman Khan <[email protected]>; Khushboo Vashi <[email protected]>; pgadmin-hackers <[email protected]>

FYI, pgAdmin 4 v9.2 is the last version to offer official support for
Ubuntu 20.04

On Thu, May 15, 2025 at 3:28 PM Daulat <[email protected]> wrote:

> Yes Ushman, this is not working.
>
> sudo /usr/pgadmin4/bin/setup-web.sh
>
> Setting up pgAdmin 4 in web mode on a Debian based platform...
> Creating configuration database...
> */usr/pgadmin4/bin/setup-web.sh: line 75: /usr/pgadmin4/venv/bin/python3:
> No such file or directory*
> Error setting up server mode. Please examine the output above.
>
> On Thu, May 15, 2025 at 3:16 PM Usman Khan <[email protected]> wrote:
>
>> Hi Daulat,
>> If you have installed it through apt package, why do you need to activate
>> the virtual environment? should not triggering the command alone
>>
>> */usr/pgadmin4/bin/setup-web.sh*
>>
>> work for you?
>>
>> On Thu, May 15, 2025 at 2:35 PM Khushboo Vashi <
>> [email protected]> wrote:
>>
>>>
>>>
>>> On Thu, May 15, 2025 at 2:59 PM Usman Khan <[email protected]> wrote:
>>>
>>>> adding pgadmin-hackers and removing [email protected]
>>>> for better guidance.
>>>> Please forward all queries related to pgadmin to
>>>> [email protected]
>>>>
>>>> On Thu, May 15, 2025 at 2:19 PM Daulat <[email protected]> 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/
>>>>>
>>>>>
>>> The setup-web.sh file location is */usr/pgadmin4/bin, *you have
>>> mentioned /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,
>>>>>
>>>>>
>>>>>


^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
  2025-05-15 09:19 pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  2025-05-15 09:29 ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Usman Khan <[email protected]>
  2025-05-15 09:34   ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Khushboo Vashi <[email protected]>
@ 2025-05-15 09:47     ` Daulat <[email protected]>
  1 sibling, 0 replies; 11+ messages in thread

From: Daulat @ 2025-05-15 09:47 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: Usman Khan <[email protected]>; pgadmin-hackers <[email protected]>

Right Khushboo,

The setup-web.sh file location is */usr/pgadmin4/bin, *you have
mentioned /usr/pgadmin4/web/.



On Thu, May 15, 2025 at 3:05 PM Khushboo Vashi <
[email protected]> wrote:

>
>
> On Thu, May 15, 2025 at 2:59 PM Usman Khan <[email protected]> wrote:
>
>> adding pgadmin-hackers and removing [email protected] for
>> better guidance.
>> Please forward all queries related to pgadmin to
>> [email protected]
>>
>> On Thu, May 15, 2025 at 2:19 PM Daulat <[email protected]> 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/
>>>
>>>
> The setup-web.sh file location is */usr/pgadmin4/bin, *you have
> mentioned /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,
>>>
>>>
>>>


^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
  2025-05-15 09:19 pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
@ 2025-05-22 09:08 ` zaidagilist <[email protected]>
  2025-05-22 12:25   ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  1 sibling, 1 reply; 11+ messages in thread

From: zaidagilist @ 2025-05-22 09:08 UTC (permalink / raw)
  To: Daulat <[email protected]>; +Cc: pgsql-admin <[email protected]>

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 <[email protected]> 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,
>
>
>


^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
  2025-05-15 09:19 pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  2025-05-22 09:08 ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. zaidagilist <[email protected]>
@ 2025-05-22 12:25   ` Daulat <[email protected]>
  2025-05-27 20:26     ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Roland Müller <[email protected]>
  0 siblings, 1 reply; 11+ messages in thread

From: Daulat @ 2025-05-22 12:25 UTC (permalink / raw)
  To: zaidagilist <[email protected]>; +Cc: pgsql-admin <[email protected]>

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 <[email protected]> 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 <[email protected]> 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,
>>
>>
>>


^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
  2025-05-15 09:19 pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  2025-05-22 09:08 ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. zaidagilist <[email protected]>
  2025-05-22 12:25   ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
@ 2025-05-27 20:26     ` Roland Müller <[email protected]>
  2025-05-27 21:17       ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Usman Khan <[email protected]>
  0 siblings, 1 reply; 11+ messages in thread

From: Roland Müller @ 2025-05-27 20:26 UTC (permalink / raw)
  To: Daulat <[email protected]>; +Cc: zaidagilist <[email protected]>; pgsql-admin <[email protected]>

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 <[email protected]>:

> 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 <[email protected]> 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 <[email protected]> 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,
>>>
>>>
>>>


^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
  2025-05-15 09:19 pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  2025-05-22 09:08 ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. zaidagilist <[email protected]>
  2025-05-22 12:25   ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
  2025-05-27 20:26     ` Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Roland Müller <[email protected]>
@ 2025-05-27 21:17       ` Usman Khan <[email protected]>
  0 siblings, 0 replies; 11+ messages in thread

From: Usman Khan @ 2025-05-27 21:17 UTC (permalink / raw)
  To: Roland Müller <[email protected]>; +Cc: Daulat <[email protected]>; zaidagilist <[email protected]>; pgsql-admin <[email protected]>

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 <[email protected]> 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 <[email protected]>:
>
>> 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 <[email protected]>
>> 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 <[email protected]> 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,
>>>>
>>>>
>>>>


^ permalink  raw  reply  [nested|flat] 11+ messages in thread


end of thread, other threads:[~2025-05-27 21:17 UTC | newest]

Thread overview: 11+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-05-15 09:19 pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system. Daulat <[email protected]>
2025-05-15 09:29 ` Usman Khan <[email protected]>
2025-05-15 09:34   ` Khushboo Vashi <[email protected]>
2025-05-15 09:46     ` Usman Khan <[email protected]>
2025-05-15 09:57       ` Daulat <[email protected]>
2025-05-15 10:18         ` Akshay Joshi <[email protected]>
2025-05-15 09:47     ` Daulat <[email protected]>
2025-05-22 09:08 ` zaidagilist <[email protected]>
2025-05-22 12:25   ` Daulat <[email protected]>
2025-05-27 20:26     ` Roland Müller <[email protected]>
2025-05-27 21:17       ` Usman Khan <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox