Thread: pgAdmin 4 v4.30 released

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

Where is x86 setup file for Windows?

czw., 28 sty 2021 o 14:14 Akshay Joshi <akshay.joshi@enterprisedb.com> napisał(a):

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

--

Z wyrazami szacunku
Andrzej Gerasimuk

Hi,

We have dropped the support for x86 installer for pgadmin4

32 bit Windows support is available for versions up to v4.29.

https://www.pgadmin.org/download/pgadmin-4-windows/

On Mon, Feb 1, 2021 at 1:14 PM androxkentaki <androxkentaki@gmail.com> wrote:

Where is x86 setup file for Windows?

czw., 28 sty 2021 o 14:14 Akshay Joshi <akshay.joshi@enterprisedb.com> napisał(a):

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

--

Z wyrazami szacunku
Andrzej Gerasimuk

--

Fahar Abbas

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com

Hi,

On Mon, Feb 1, 2021 at 1:39 PM androxkentaki <androxkentaki@gmail.com> wrote:

Hello

Thanks for fast response

So is there any fast way to migrate all settings from x86 to x64 of pgAdmin?

Can you please take a database backup from x86 and restore it into the x64 machine?

https://www.pgadmin.org/docs/pgadmin4/development/backup_dialog.html

Kind Regards,

pon., 1 lut 2021 o 09:38 Fahar Abbas <fahar.abbas@enterprisedb.com> napisał(a):

Hi,

We have dropped the support for x86 installer for pgadmin4

32 bit Windows support is available for versions up to v4.29.

https://www.pgadmin.org/download/pgadmin-4-windows/

On Mon, Feb 1, 2021 at 1:14 PM androxkentaki <androxkentaki@gmail.com> wrote:

Where is x86 setup file for Windows?

czw., 28 sty 2021 o 14:14 Akshay Joshi <akshay.joshi@enterprisedb.com> napisał(a):

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

--

Z wyrazami szacunku
Andrzej Gerasimuk

--

Fahar Abbas

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com

--

Z wyrazami szacunku
Andrzej Gerasimuk

--

Fahar Abbas

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com

Hi Andrej,

You can uninstall the 32 bit version and install the 64 bit. The settings will stay.

Just to be safe, make a copy of the file - %APPDATA%/<Local or Roaming>/pgAdmin/pgadmin4.db, which contains all the settings.

You do not need to take backup of PostgreSQL database.

On Mon, Feb 1, 2021 at 2:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Hi,

On Mon, Feb 1, 2021 at 1:39 PM androxkentaki <androxkentaki@gmail.com> wrote:

Hello

Thanks for fast response

So is there any fast way to migrate all settings from x86 to x64 of pgAdmin?

Can you please take a database backup from x86 and restore it into the x64 machine?

https://www.pgadmin.org/docs/pgadmin4/development/backup_dialog.html

Kind Regards,

pon., 1 lut 2021 o 09:38 Fahar Abbas <fahar.abbas@enterprisedb.com> napisał(a):

Hi,

We have dropped the support for x86 installer for pgadmin4

32 bit Windows support is available for versions up to v4.29.

https://www.pgadmin.org/download/pgadmin-4-windows/

On Mon, Feb 1, 2021 at 1:14 PM androxkentaki <androxkentaki@gmail.com> wrote:

Where is x86 setup file for Windows?

czw., 28 sty 2021 o 14:14 Akshay Joshi <akshay.joshi@enterprisedb.com> napisał(a):

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

--

Z wyrazami szacunku
Andrzej Gerasimuk

--

Fahar Abbas

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com

--

Z wyrazami szacunku
Andrzej Gerasimuk

--

Fahar Abbas

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com

--

Thanks,

Aditya Toshniwal

pgAdmin hacker | Sr. Software Engineer | edbpostgres.com

"Don't Complain about Heat, Plant a TREE"

Hi Aditya

Thank You.

I will try that

pon., 1 lut 2021 o 09:59 Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> napisał(a):

Hi Andrej,

You can uninstall the 32 bit version and install the 64 bit. The settings will stay.

Just to be safe, make a copy of the file - %APPDATA%/<Local or Roaming>/pgAdmin/pgadmin4.db, which contains all the settings.

You do not need to take backup of PostgreSQL database.

On Mon, Feb 1, 2021 at 2:18 PM Fahar Abbas <fahar.abbas@enterprisedb.com> wrote:

Hi,

On Mon, Feb 1, 2021 at 1:39 PM androxkentaki <androxkentaki@gmail.com> wrote:

Hello

Thanks for fast response

So is there any fast way to migrate all settings from x86 to x64 of pgAdmin?

Can you please take a database backup from x86 and restore it into the x64 machine?

https://www.pgadmin.org/docs/pgadmin4/development/backup_dialog.html

Kind Regards,

pon., 1 lut 2021 o 09:38 Fahar Abbas <fahar.abbas@enterprisedb.com> napisał(a):

Hi,

We have dropped the support for x86 installer for pgadmin4

32 bit Windows support is available for versions up to v4.29.

https://www.pgadmin.org/download/pgadmin-4-windows/

On Mon, Feb 1, 2021 at 1:14 PM androxkentaki <androxkentaki@gmail.com> wrote:

Where is x86 setup file for Windows?

czw., 28 sty 2021 o 14:14 Akshay Joshi <akshay.joshi@enterprisedb.com> napisał(a):

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

--

Z wyrazami szacunku
Andrzej Gerasimuk

--

Fahar Abbas

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com

--

Z wyrazami szacunku
Andrzej Gerasimuk

--

Fahar Abbas

EnterpriseDB Corporation

Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: live:fahar.abbas
Website: www.enterprisedb.com

--

Thanks,

Aditya Toshniwal

pgAdmin hacker | Sr. Software Engineer | edbpostgres.com

"Don't Complain about Heat, Plant a TREE"

--

Z wyrazami szacunku
Andrzej Gerasimuk

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.joshi@enterprisedb.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