Thread: pgadmin-4.30 upgrade from 4.27

When starting pgadmin4 in a python venv I get a warning that I am starting
version 4.27 and that 4.30 is available.

However, I have updated that venv to 4.30:

[root@vhost01 ~ (master)]# source /opt/python_venv/3.7/pgadmin4/bin/activate
(pgadmin4) [root@vhost01 ~ (master)]# pip install
https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.28/pip/pgadmin4-4.28-py3-none-any.whl
Collecting pgadmin4==4.28
  Downloading
https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.28/pip/pgadmin4-4.28-py3-none-any.whl
(89.9 MB)

|████████████████████████████████|
89.9 MB 1.7 MB/s
Requirement already satisfied: ldap3>=2.5.1 in
/opt/python_venv/3.7/pgadmin4/lib/python3.7/site-packages (from pgadmin4==4.28)
(2.8.1)
Requirement already satisfied: Werkzeug>=0.15.0 in
/opt/python_venv/3.7/pgadmin4/lib/python3.7/site-packages (from pgadmin4==4.28)
(1.0.1)
. . .
Requirement already satisfied: dnspython>=1.15.0 in
/usr/local/lib/python3.7/site-packages (from
email-validator>=1.0.5->Flask-Security-Too>=3.0.0->pgadmin4==4.30) (1.16.0)
Requirement already satisfied: pynacl>=1.0.1 in
/usr/local/lib/python3.7/site-packages (from
paramiko>=1.15.2->sshtunnel>=0.1.5->pgadmin4==4.30) (1.4.0)
Installing collected packages: pgadmin4
  Attempting uninstall: pgadmin4
    Found existing installation: pgadmin4 4.27
    Uninstalling pgadmin4-4.27:
      Successfully uninstalled pgadmin4-4.27
Successfully installed pgadmin4-4.30

(pgadmin4) [root@vhost01 ~ (master)]# python
/opt/python_venv/3.7/pgadmin4/lib/python3.7/site-packages/pgadmin4/setup.py
. . .
pgAdmin 4 - Application Initialisation
======================================

(pgadmin4) [root@vhost01 ~ (master)]# /opt/python_venv/3.7/pgadmin4/bin/pgadmin4&
Starting pgAdmin 4. Please navigate to http://127.0.0.1:5050 in your browser.

So what am I missing here?

-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
   Unencrypted messages have no legal claim to privacy
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3

On Fri, February 19, 2021 04:33, Dave Page wrote:
> Hi
>
> On Thu, Feb 18, 2021 at 7:34 PM James B. Byrne <byrnejb@harte-lyne.ca>
> wrote:
>
>> When starting pgadmin4 in a python venv I get a warning that I am starting
>> version 4.27 and that 4.30 is available.
>>
>> However, I have updated that venv to 4.30:
>>
. . .
>> Successfully installed pgadmin4-4.30
>>
>> (pgadmin4) [root@vhost01 ~ (master)]# python
>> /opt/python_venv/3.7/pgadmin4/lib/python3.7/site-packages/pgadmin4/setup.py
>> . . .
>> pgAdmin 4 - Application Initialisation
>> ======================================
>>
>> (pgadmin4) [root@vhost01 ~ (master)]#
>> /opt/python_venv/3.7/pgadmin4/bin/pgadmin4&
>> Starting pgAdmin 4. Please navigate to http://127.0.0.1:5050 in your
>> browser.
>>
>> So what am I missing here?
>>
>
> The text above shows you updating to 4.28 in the beginning, but then claims
> it installed 4.30. Did you copy/paste the wrong output for the first
> section perhaps?

I had previously updated to 4.28 using the same procedure. The application
continued to report that it was 4.27 and warn that a new version was available.
 I skipped 4.29 because I never could get 4.28 to take.  I decided to try again
with 4.30 and ask for help.  What I posted here I likely copied from the wrong
set of notes.

>
> The easiest way to check what code is actually installed is to look in the
> config.py file (as well as config_local.py and config_distro.py if
> present), eg.
>
> dpage@hal:~/git/pgadmin4$ grep "APP_REVISION = "
> /Users/dpage/.virtualenvs/pgatest/lib/python3.8/site-packages/pgadmin4/config*.py
> /Users/dpage/.virtualenvs/pgatest/lib/python3.8/site-packages/pgadmin4/config.py:APP_REVISION
> = 30
>
> (adjust the path appropriately for your venv of course).
>

# grep "APP_REVISION = "
/opt/python_venv/3.7/pgadmin4/lib/python3.7/site-packages/pgadmin4/config.py
APP_REVISION = 30

I got a similar result (APP_REVISION = 28) after installing 4.28.  Nonetheless,
when I connect to http://localhost:5050 the splash pages says it is loading
4.27 and the outdated version warning appears.

       You are currently running version 4.27 of pgAdmin 4,
       however the current version is 4.30.

Thanks.

-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
   Unencrypted messages have no legal claim to privacy
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3

On Fri, February 19, 2021 09:10, Dave Page wrote:
> Hi
>

>
> A couple of possibilities spring to mind:
>
> 1) Python hasn't noticed the update, and is using the older bytecode. Try
> searching for and removing any __pycache__ directories under
> /opt/python_venv/3.7/pgadmin4/lib/python3.7/site-packages/pgadmin4.
>
> 2) Either pgAdmin hasn't been restarted, or you're not running the copy you
> think you are. Take a look at the process list (ps -ef or similar), and
> check what is actually running.

The host that pgadmin4 is running on went through a OS upgrade this week which
involved several reboots.  I am confident that pgadmin4 did not not continue to
run.

[root@vhost01 ~ (master)]# source /opt/python_venv/3.7/pgadmin4/bin/activate &&
/opt/python_venv/3.7/pgadmin4/bin/pgadmin4& # access at http://localhost:5050/
PW pgadmin4
[1] 85118
[root@vhost01 ~ (master)]# Starting pgAdmin 4. Please navigate to
http://127.0.0.1:5050 in your browser.
 * Serving Flask app "pgadmin" (lazy loading)
 * Environment: production
   WARNING: Do not use the development server in a production environment.
   Use a production WSGI server instead.
 * Debug mode: off


The problem has been resolved.  How, I do not know.  But this morning after
starting the pgadmin4 service I was presented with a different log on screen
with the warning message.  This warning has now disappeared.

It is not possible for pgadmin4 to have survived reboots.  And I have done
nothing else to this system respecting pgadmin4 since the update to 4.30. The
warning I copied above appeared when I connected to localhost:5050 this morning
and was copied directly from that web page.

It does not much matter now.  So long as the update works.  But I am sorely
confused as to how this happened.

Thank you for your help.



-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
   Unencrypted messages have no legal claim to privacy
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3