Re: pgAdmin 4 v5.0 released

[Richard Brockie]

Thanks for the smooth upgrade to the new pgadmin4 implementation with v5.

I have one extremely minor quibble - my master password is stored in a
password manager which would autocomplete using a browser plugin. Now I
have to find the password manually and copy it into the password field!
Best wishes,
R.


On Thu, Feb 25, 2021 at 4:57 AM Akshay Joshi 
wrote:

> The pgAdmin Development Team are pleased to announce pgAdmin 4 version
> 5.0. This release of pgAdmin 4 includes 31 bug fixes and new features. For
> more details please see the release notes
> .
>
> Notable changes in this release include:
>
> Features:
>
>-
>
>New Desktop Runtime (Using NWjs):
>
> The Desktop Runtime is now based on NWjs which integrates a browser and
> the Python server creating a standalone application. By implementing it
> using NWjs we get rid of the separate server application and the
> independent browser. We also get rid of QT and C++ runtime logic.
>
> There are two minor known issues with this feature (6255
>  and 6258
> ), both of which are due to
> bugs in NWjs itself; Users on macOS should use the application menu to exit
> pgAdmin, rather than quitting from the Dock icon to avoid the first issue.
> The second issue may cause Windows users to see a red square instead of the
> normal application icon in some circumstances.
>
>-
>
>Logical Replication support:
>
> Logical replication uses a publish and subscribe model with one or more
> subscribers subscribing to one or more publications on a publisher node. We
> have added support for logical replication by introducing new treeview
> nodes and dialogues with which users can easily create/alter/delete
> publications and subscriptions. Support is also included in the Schema Diff
> tool.
>
>-
>
>Quick Search functionality:
>
> Added a quick search option in the Help menu to search menu items and help
> articles. Type at least three characters to display all the matching
> possibilities under Menu items and the relevant documents under Help
> articles.
>
>-
>
>Make Statistics, Dependencies, Dependants tabs closable. Users can add
>them back using the 'Add panel' option on the context menu for the tab
>strip.
>-
>
>When running in Docker/Kubernetes, ensure logs are not stored in the
>container, and only sent to the console.
>
> Bugs/Housekeeping:
>
>-
>
>Use cheroot as the default production server for pgAdmin4
>-
>
>Updated Javascript dependencies to the latest versions
>-
>
>Fixed an issue where the focus is not properly set on the filter text
>editor after closing the error dialog.
>-
>
>Fixed an issue where the dependencies tab shows multiple owners for
>the objects having shared dependencies.
>-
>
>Fixed an issue where the Zoom to fit button in the ERD Tool only works
>if the diagram is larger than the canvas.
>-
>
>Fixed an issue where the user was unable to change the background
>color for a server.
>-
>
>Fixed an issue where external utility jobs (backup, maintenance etc.)
>are failing when the log level is set to DEBUG.
>-
>
>Ensure DEB/RPM packages depend on the same version of each other.
>-
>
>Fixed an autocomplete issue where it is not showing any suggestions if
>the schema name contains escape characters.
>
> Builds for Windows and macOS are available now, along with a Python Wheel,
> Docker Container, RPM, DEB Package, and source code tarball from:
>
> https://www.pgadmin.org/download/
>
> --
> Akshay Joshi
> pgAdmin Project
>
>

-- 
R.

Richard Brockie

Real-time bicycle race management - www.ontheday.net

Re: pgAdmin 4 v5.0 released

[Darren Duncan]

On 2021-02-25 8:11 a.m., Dave Page wrote:
So, we need to think about how long we'll support Windows 7. Sooner or later we 
will have to update Python... :-(


Python still gets support with bug/security fixes for the last several major 
versions, so I would say as long as Python 3.8 keeps getting new bug/security 
fixes then it is perfectly ok to keep using it.  You won't be getting new 
features but you will be staying secure. -- Darren Duncan

Re: pgAdmin 4 v5.0 released

[Dave Page]

On Thu, Feb 25, 2021 at 3:30 PM Dave Page  wrote:

>
>
> On Thu, Feb 25, 2021 at 3:13 PM Dave Page  wrote:
>
>>
>>
>> On Thu, Feb 25, 2021 at 2:46 PM Dave Caughey  wrote:
>>
>>> Here's what happens when I run the command on the terminal.
>>>
>>> [image: image.png]
>>>
>>> But... pgAdmin v4.30 runs fine.
>>>
>>
>> So I believe the issue is that Python 3.9 has dropped support for Windows
>> 7 and earlier, something which I for one didn't realise until I started
>> looking into this (see https://www.python.org/downloads/windows/).
>>
>> I've kicked off a build using Python 3.8 for testing. That claims to
>> support back to Vista. I'll send a link once it's done.
>>
>
> Here's the Python 3.8 based test build. Note that I haven't tested it at
> all - I just kicked off the normal build process but told it to use 3.8
> instead of 3.9.
>
>
> https://developer.pgadmin.org/builds/2021-02-25python38-1/pgadmin4-5.0-x64.exe
>
> Please let us know if it works on Windows 7.
>

Dave told me offlist that it's working for him.

So, we need to think about how long we'll support Windows 7. Sooner or
later we will have to update Python... :-(

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com

Re: pgAdmin 4 v5.0 released

[Dave Page]

On Thu, Feb 25, 2021 at 3:13 PM Dave Page  wrote:

>
>
> On Thu, Feb 25, 2021 at 2:46 PM Dave Caughey  wrote:
>
>> Here's what happens when I run the command on the terminal.
>>
>> [image: image.png]
>>
>> But... pgAdmin v4.30 runs fine.
>>
>
> So I believe the issue is that Python 3.9 has dropped support for Windows
> 7 and earlier, something which I for one didn't realise until I started
> looking into this (see https://www.python.org/downloads/windows/).
>
> I've kicked off a build using Python 3.8 for testing. That claims to
> support back to Vista. I'll send a link once it's done.
>

Here's the Python 3.8 based test build. Note that I haven't tested it at
all - I just kicked off the normal build process but told it to use 3.8
instead of 3.9.

https://developer.pgadmin.org/builds/2021-02-25python38-1/pgadmin4-5.0-x64.exe

Please let us know if it works on Windows 7.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com

Re: pgAdmin 4 v5.0 released

[Dave Page]

On Thu, Feb 25, 2021 at 2:46 PM Dave Caughey  wrote:

> Here's what happens when I run the command on the terminal.
>
> [image: image.png]
>
> But... pgAdmin v4.30 runs fine.
>

So I believe the issue is that Python 3.9 has dropped support for Windows 7
and earlier, something which I for one didn't realise until I started
looking into this (see https://www.python.org/downloads/windows/).

I've kicked off a build using Python 3.8 for testing. That claims to
support back to Vista. I'll send a link once it's done.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com

Re: pgAdmin 4 v5.0 released

[Dave Caughey]

With great excitement, I installed the pgAdmin v4.5 on my 64-bit Windows 7
machine, and get the following when I try to launchv4.5.

[image: image.png]

Thankfully v4.30 still runs.

Let me know what logs you'd like/need, and I can create a RM bug.

Cheers,
Dave


On Thu, Feb 25, 2021 at 7:57 AM Akshay Joshi 
wrote:

> The pgAdmin Development Team are pleased to announce pgAdmin 4 version
> 5.0. This release of pgAdmin 4 includes 31 bug fixes and new features. For
> more details please see the release notes
> .
>
> Notable changes in this release include:
>
> Features:
>
>-
>
>New Desktop Runtime (Using NWjs):
>
> The Desktop Runtime is now based on NWjs which integrates a browser and
> the Python server creating a standalone application. By implementing it
> using NWjs we get rid of the separate server application and the
> independent browser. We also get rid of QT and C++ runtime logic.
>
> There are two minor known issues with this feature (6255
>  and 6258
> ), both of which are due to
> bugs in NWjs itself; Users on macOS should use the application menu to exit
> pgAdmin, rather than quitting from the Dock icon to avoid the first issue.
> The second issue may cause Windows users to see a red square instead of the
> normal application icon in some circumstances.
>
>-
>
>Logical Replication support:
>
> Logical replication uses a publish and subscribe model with one or more
> subscribers subscribing to one or more publications on a publisher node. We
> have added support for logical replication by introducing new treeview
> nodes and dialogues with which users can easily create/alter/delete
> publications and subscriptions. Support is also included in the Schema Diff
> tool.
>
>-
>
>Quick Search functionality:
>
> Added a quick search option in the Help menu to search menu items and help
> articles. Type at least three characters to display all the matching
> possibilities under Menu items and the relevant documents under Help
> articles.
>
>-
>
>Make Statistics, Dependencies, Dependants tabs closable. Users can add
>them back using the 'Add panel' option on the context menu for the tab
>strip.
>-
>
>When running in Docker/Kubernetes, ensure logs are not stored in the
>container, and only sent to the console.
>
> Bugs/Housekeeping:
>
>-
>
>Use cheroot as the default production server for pgAdmin4
>-
>
>Updated Javascript dependencies to the latest versions
>-
>
>Fixed an issue where the focus is not properly set on the filter text
>editor after closing the error dialog.
>-
>
>Fixed an issue where the dependencies tab shows multiple owners for
>the objects having shared dependencies.
>-
>
>Fixed an issue where the Zoom to fit button in the ERD Tool only works
>if the diagram is larger than the canvas.
>-
>
>Fixed an issue where the user was unable to change the background
>color for a server.
>-
>
>Fixed an issue where external utility jobs (backup, maintenance etc.)
>are failing when the log level is set to DEBUG.
>-
>
>Ensure DEB/RPM packages depend on the same version of each other.
>-
>
>Fixed an autocomplete issue where it is not showing any suggestions if
>the schema name contains escape characters.
>
> Builds for Windows and macOS are available now, along with a Python Wheel,
> Docker Container, RPM, DEB Package, and source code tarball from:
>
> https://www.pgadmin.org/download/
>
> --
> Akshay Joshi
> pgAdmin Project
>
>