Re: pgAdmin 4 v4.30 released

Hi Patrick

There is a context menu option 'Generate ERD (Beta)' which works only on
the database node.
[image: ERD.png]

On Sat, Feb 13, 2021 at 8:54 PM Patrick De Visschere <pdvisschere(at)edpnet(dot)be>
wrote:

> How can I view an existing database schema with the ERD tool?
> Or maybe this doesn’t work yet?
>
> P. De Visschere
>
> On 28 Jan 2021, at 14:14, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
> wrote:
>
> The pgAdmin Development Team is pleased to announce pgAdmin 4 version 4.30.
> This release of pgAdmin 4 includes 38 bug fixes and new features. For
> more details please see the release notes at:
>
> https://www.pgadmin.org/docs/pgadmin4/4.30/release_notes_4_30.html.
>
> pgAdmin is the leading Open Source graphical management tool for
> PostgreSQL. For more information, please see:
>
> https://www.pgadmin.org/
>
> Notable changes in this release include:
>
> *Features:*
>
> - ERD Tool (Beta):
>
> The Entity-Relationship Diagram (ERD) tool is a database design tool that
> provides a graphical representation of database tables, columns, and
> inter-relationships. You can use the ERD tool to design a new schema and
> generate the SQL required to create it or to reverse engineer and diagram
> an existing database schema.
>
>
> - Kerberos Support:
>
> Kerberos support is added in pgAdmin 4 using SPNEGO for logging into
> pgAdmin, similar to the existing LDAP and "internal" options. Note that
> support for logging into database servers using Kerberos is not included in
> this release, but will be added in a future version.
>
>
> - Add a container option (PGADMIN_DISABLE_POSTFIX) to disable the
> Postfix server:
>
> Postfix (like other MTAs) must start as user 'root', and the pgAdmin
> container achieves this using 'sudo'. Whilst that works well in most
> environments, it can cause problems in some. This option allows you to
> completely disable Postfix to avoid these issues, though you will need to
> configure an external mail server to be used to send password reset emails.
>
>
> *Bugs/Housekeeping:*
>
> - Improve the explain plan details by showing a popup instead of a
> tooltip when clicking on plan nodes.
> - Ensure that verbose logs are visible for Utility (Backup,
> Maintenance etc.) jobs.
> - Added support for expressions in exclusion constraints.
> - Ensure that the 'template1' database is not visible after pg_upgrade.
> - Added appropriate help message and a placeholder for letting users
> know about the account password expiry for Login/Group Role.
> - Updated Flask-BabelEx to the latest version. Fixed extra parentheses
> issue around joins for Views.
> - Ensure that the current value of sequences is ignored while
> comparing using Schema Diff.
> - Fixed an issue when the user tries to delete multiple records in the
> data grid.
> - Fixed TypeError exception in schema diff when selecting two
> identical objects.
> - Include PostgreSQL 13 utilities in the container distribution.
>
>
> 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
>
>
>
>
>
>

--
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres <http://edbpostgres.com>*

*Mobile: +91 976-788-8246*