pgAdmin

PostgreSQL Tools

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

pgAdmin may be used on Linux, Unix, Mac OS X and Windows to manage PostgreSQL 9.2 and above.

News

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]

The current version of pgAdmin 4 is 4.12