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

2018-09-06 - pgAdmin 4 v3.3 Released

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

Note: This is the first release of pgAdmin on a new monthly release cycle.

Notable changes in this release include:

  • Add a geometry viewer that can render PostGIS data on a blank canvas or various map sources.

Download your copy here.

2018-08-09 - pgAdmin 4 v3.2 Released

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

Note: This is the first release of pgAdmin on a new monthly release cycle.

Notable changes in this release include:

  • Add a cache busting mechanism to prevent issues following upgrades.
  • Add support for SCRAM password changes (require psycopg2 2.8).
  • Allow save password to be reset.
  • Introduce real time preference handling in Query Tool, Debugger and Dashboards.
  • SSH Tunneling fixes.

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]

2018-06-28 - pgAdmin 4 v3.1 Released

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

Notable changes in this release include:

  • Add support for SSH tunneled connections.
  • Various fixes for handling data in SQL_ASCII databases.
  • Add support for LISTEN/NOTIFY in the Query Tool.
  • Function/Procedure support for PostgreSQL 11.
  • Various fixes and enhancements to the Greenplum support.

Download your copy here.

2018-04-13 - pgAdmin 4 v3.0 Released

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

Notable changes in this release include:

  • The desktop runtime now runs as a system tray application and utilises the browser on the system to display pgAdmin. This resolves numerous bugs and issues caused by QtWebKit/QtWebEngine.
  • Data can now be sorted in edit mode in the Query Tool.
  • Keyboard navigation with configurable shortcuts for many operations has been added to allow use of pgAdmin without a mouse.
  • Dashboard tables and charts can be enabled/disabled.
  • Server and database statistics, functions, partitions, external tables and EXPLAIN are now supported on Greenplum.
  • Support for pg_service.conf files has been added.
  • The Docker Container distribution is vastly slimmed down, having move to Alpine Linux with Gunicorn to host the pgAdmin web application.

Download your copy here.

2018-01-11 - pgAdmin 4 v2.1 Released

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

Notable changes in this release include:

  • Support for colouring connections in the treeview and query tool
  • Configurable formatting for CSV and clipboard datasets
  • Editing of table data for tables with OIDs but no primary keys
  • Immediately retrieve default column values when saving new/edited rows in the query tool

We've also added a new distribution in the form of a Docker Container. See the Docker Hub repo for more information.

Download your copy of pgAdmin here.

2017-07-13 - pgAdmin 4 v1.6 released

The pgAdmin Development Team are pleased to announce the release of pgAdmin 4 version 1.6. This release of pgAdmin 4 includes over 70 bug fixes and a dozen new features. For details, please see the release notes.

Notable changes in this release include:

  • Significant performance improvements on Windows, massively reducing initial load time and improving UI response for the vast majority of users during testing.
  • Enhancements to the Query Tool enabling the viewing of large query resultsets far more quickly. For example, a simple test query with 96K rows rendered results within 1 second vs. 22 seconds in pgAdmin III during testing!
  • A major rewrite of the Query History tab allows browsing of queries executed in the query tool with full details including the entire query, in a much nicer user interface.
  • The Desktop Runtime now supports detachable tabs, allowing the Query Tool and Debugger to be opened in new tabs and then moved to alternate displays (from 1.5 this was possible in web mode only)
  • The Query Tool's Results Grid has been overhauled with a new, sleek look an feel supporting selection of arbitrary rows, columns or blocks of cells with full copy support and column sizing retention.
  • The Dashboard tab can now be closed if desired, to minimise query traffic resulting from graph updates.

For more information, checkout the online documentation, the screenshots, and of course the download page.

The current version of pgAdmin 4 is 3.3