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.

Screenshot of pgAdmin

News

2020-05-28 - pgAdmin 4 v4.22 Released

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

Notable changes in this release include:

  • Show the startup log as well as the server log in the runtime's log viewer.
  • Implement Selenium Grid to run multiple tests across different browsers, operating systems, and machines in parallel.
  • Remove support for Python 2.
  • Ensure that maintenance job should be worked properly for indexes under a materialized view.
  • Ensure that file browse "home" button should point to $HOME rather than /.
  • Fixed data truncation issue when updating the data of type character with length
  • Fixed generated SQL issue for auto vacuum options.
  • Fixed internal server error when clicking on Triggers -> 'Enable All' for partitions
  • Fixed the SQL help issue for EDB Postgres Advanced Server.
  • Fixed an issue where if LDAP_SEARCH_BASE_DN is not set then, the value for LDAP_BASE_DN will be considered.
  • Improve code coverage and API test cases for Indexes, Rules, Triggers and Compound Triggers.

Download your copy here.

2020-04-30 - pgAdmin 4 v4.21 Released

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

Notable changes in this release include:

  • Added LDAP authentication support.
  • Added search object functionality.
  • Added support of Foreign Tables, Packages, Sequences and Synonyms to the Schema Diff.
  • Warn the user if an unsupported, deprecated or unknown browser is detected.
  • Added multiple drop/delete functionality for the table constraints.
  • Fixed copy-paste row issues in View/Edit Data.
  • Added dark mode support for the configuration dialog on Windows/macOS runtime.
  • Added alert message to Reset Layout if any of the panels from Query Tool failed to load.
  • Fixed an issue when the user performs refresh on a large size materialized view.
  • Ensure that default sort order should be using the primary key in View/Edit data.
  • Fixed an issue where changing the values of columns with JSONB or JSON types to NULL
  • Ensure that if the delimiter is set other than comma then download the file as '.txt' file.

Download your copy here.

2019-11-21 - Try pgAdmin online!

Our friends at EnterpriseDB have kindly made an online demo environment for pgAdmin available to allow new users to try it out in their browser without needing to download or install any software. The environment (based on the Katacoda learning platform) includes pgAdmin and PostgreSQL 12, preloaded with the pagila sample database, and is unique to every user allowing a far better experience than typical shared demo environments.

Click here to try it out now!

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.22