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]> 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:29 Usman Khan <[email protected]> parent: Daulat <[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:34 Khushboo Vashi <[email protected]> parent: Usman Khan <[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:46 Usman Khan <[email protected]> parent: Khushboo Vashi <[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:47 Daulat <[email protected]> parent: Khushboo Vashi <[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:57 Daulat <[email protected]> parent: Usman Khan <[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 10:18 Akshay Joshi <[email protected]> parent: Daulat <[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-22 09:08 zaidagilist <[email protected]> parent: 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-22 12:25 Daulat <[email protected]> parent: zaidagilist <[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-27 20:26 Roland Müller <[email protected]> parent: Daulat <[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-27 21:17 Usman Khan <[email protected]> parent: Roland Müller <[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