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-06-25 - pgAdmin 4 v4.23 Released

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

Notable changes in this release include:

  • Added option to ignore the whitespaces while comparing objects in schema diff.
  • Added server group name while selecting servers in schema diff.
  • Added support of Row Security Policies.
  • Improve error messaging if the storage and log directories cannot be created.
  • Cleanup Windows build scripts and ensure Windows x64 builds will work.
  • Fixed an issue where the Edge browser version is showing wrong and warning message gets displayed.
  • Fixed an issue where select all checkbox only selects the first 50 tables.
  • Fixed an issue where two identical tables showing different by schema diff tool.
  • Fixed an issue when dumping servers from a desktop pgAdmin app by providing an option '--sqlite-path'
  • Ensure that the query tool panel gets closed when clicking on the 'Don't Save' button.

Download your copy now!

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.

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 now!

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.

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 now!

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.

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