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

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Roland Müller <[email protected]>
To: Daulat <[email protected]>
Cc: zaidagilist <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
Date: Tue, 27 May 2025 23:26:23 +0300
Message-ID: <CA+8p0G34DqgjS2z-eZjRXfOecExDus2TTRGvA0J7E_isFYC4Gg@mail.gmail.com> (raw)
In-Reply-To: <CALfOM6L6YOkG8E5rot478Z095sMMub2fRZwkbhr+Mn0S8XTfbQ@mail.gmail.com>
References: <CALfOM6J3BrYp-DZGi29pwJXz8bO7BbRbp9cJbm-hkoeDBbXd9w@mail.gmail.com>
	<CAFS1Kf4QxC23sUe1u1-MRt8ByBM_nVbvvnAx269az4cSGKJXkQ@mail.gmail.com>
	<CALfOM6L6YOkG8E5rot478Z095sMMub2fRZwkbhr+Mn0S8XTfbQ@mail.gmail.com>

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,
>>>
>>>
>>>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: pgAdmin 4 in web mode on an Ubuntu 20.04 (Focal) system.
  In-Reply-To: <CA+8p0G34DqgjS2z-eZjRXfOecExDus2TTRGvA0J7E_isFYC4Gg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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