News

2019-10-17 - pgAdmin 4 v4.14 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.14. This release of pgAdmin 4 includes over 21 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

• Added Copy with headers functionality when copy data from Query Tool/View Data.
• Implemented the Query Plan Analyser.
• Include PostgreSQL 12 binaries in the container.
• Ensure the MAC OSX app should be notarized for Catalina.
• Optimize Webpack to improve overall performance.
• Ensure backup a partition table should not backup the whole database.
• Ensure that 'ENTER' key in the data filter should not run the query.
• Highlighted the color of closing or opening parenthesis when user select them in CodeMirror.
• Ensure that pgAdmin should work behind reverse proxy if the inbuilt server is used as it is.
• Ensure the search path should not be quoted for Database.
• Ensure the search path should not be quoted for Function, Procedure and Trigger Function.
• Fix issue where VALID foreign keys show as NOT VALID in the SQL tab for tables.

Download your copy here.

2019-09-19 - pgAdmin 4 v4.13 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.13. This release of pgAdmin 4 includes over 46 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

• Added Gather Merge, Named Tuple Store Scan and Table Function Scan icon for explain module.
• Don't wait for the database connection before rendering the Query Tool UI, for improved UX.
• Allow configuration options to be set from the environment in the container distribution.
• Ensure editable and read-only columns in Query Tool should be identified by icons and tooltips in the column header.
• Add an Italian translation.
• Refactor Dockerfile to avoid needing to run supporting scripts (i.e. 'docker build .' will work) and minimise layers.
• Ensure Boolean columns should be editable using keyboard keys.
• Fix error while importing data to a table using Import/Export dialog and providing "Not null columns" option.
• Fix an issue where oid column should not be pasted when copy/paste row is used on query output containing the oid column.
• Ensure port and username should not be mandatory when a service is provided.
• Unescape HTML entities in database names in the Query Tool title bar.
• Fix PGADMIN_SERVER_JSON_FILE environment variable support in the container.
• Ensure sequence with negative value should be created.
• Fix issue where EXEC script doesn't write the complete script for Procedures.

Download your copy here.

2019-08-22 - pgAdmin 4 v4.12 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.12. This release of pgAdmin 4 includes over 38 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

• Add support of Compound Triggers for EPAS 12+.
• Add support for planner support functions in PostgreSQL 12+ functions.
• Add support for generated columns in Postgres 12+.
• Use the full tab space for CodeMirror instances on dialogues where appropriate.
• Allow a banner to be displayed on the login and other related pages showing custom text.
• Allow enhanced cookie protection to be disabled for compatibility with dynamically addressed hosting environments.
• Add an optimisation to the internal code responsible for searching for treeview nodes.
• Display the row count in the popup message when counting table rows, not just in the properties list.
• Add support in query history to show internal queries generated by pgAdmin during save data operations.
• Update wcDocker to allow the browser's context menu to be used except in tab strips and panel headers.
• Fix generation of reverse engineered SQL for partition table, partitions were shown as a child of indexes.
• Update wcDocker to prevent window state loading creating blank dialogues.
• Ensure the query tool will work with older versions of psycopg2 than we officially support, albeit without updatable resultsets

Download your copy here.

2019-07-25 - pgAdmin 4 v4.11 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.11. This release of pgAdmin 4 includes over 34 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

• Add support for editing of resultsets in the Query Tool, if the data can be identified as updatable.
• Add EXPLAIN options for SETTINGS and SUMMARY.
• Set the mouse cursor appropriately based on the layout lock state.
• Prevent flickering of large tooltips on the Graphical EXPLAIN canvas.
• Fix an error while retrieving json data from the table.
• Fix 'malformed array literal' error when updating a pgAgent job.
• Fix an error that could be seen when editing column privileges.
• Fix an error seen when updating a connection string in a pgAgent job step.
• EXPLAIN options should be Query Tool instance-specific.
• Allow keyboard navigation of all controls on subnode grids.

Download your copy here.

2019-07-04 - pgAdmin 4 v4.10 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.10. This release of pgAdmin 4 includes over 6 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

• Allow some objects to be dragged/dropped into the Query Tool to insert their signature into the query text.
• Allow the path to /pgadmin4/servers.json to be overridden in the container distribution.
• Ensure the browser close confirmation is only shown when closing a Query Tool which is running in a separate browser tab.
• Prevent an error that may occur when editing data with an integer primary key.
• Fix a quoting issue that caused a blank UI to be displayed when running in French.
• Ensure the version comparision should be correct for windows installer.

Download your copy here.

2018-07-12 - pgAgent v4.0.0 Released

The pgAdmin Development Team are pleased to announce the release of pgAgent v4.0.0.

pgAgent is a job scheduler for PostgreSQL; for more information please see the documentation included as part of the pgAdmin documentation at https://www.pgadmin.org/docs/pgadmin4/3.x/pgagent.html.

Download (source): https://www.pgadmin.org/download/pgagent-source-code/

We expect DEB and RPM packages to be available from the PostgreSQL APT/YUM repositories in due course, as well as an updated installer from EnterpriseDB available through StackBuilder.

Notable changes in this release include:

• Remove the dependency on wxWidgets. pgAgent now uses Boost for thread management and synchronisation [Neel Patel]
• Refactor connection parsing logic to fix issues with and improve handling of connection strings [Thomas Krennwallner]
• Handle 2 digit server version numbers [Ashesh Vashi]
• Fix handling of the "succeeded" flag on job steps which could prevent failure of steps causing the following steps to fail [Sanket Mehta]