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-04-02 - pgAdmin 4 v4.20 Released

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

Notable changes in this release include:

  • Added support of Collation, FTS Configuration, FTS Dictionary, FTS Parser and FTS Template to the Schema Diff.
  • Added support of Domain, Domain Constraints and Types to the Schema Diff.
  • Added and fixed gettext usage for better translation coverage.
  • Improve logic to get the DDL statements as a part of the comparison.
  • Enhance the color of switch control for both light and dark theme.
  • Change some colors and opacity to comply with WCAG color contrast standards.
  • Fixed tab key navigation issue for Grant Wizard.
  • Fix an issue where the user can not change the value of DateTime picker control using keyboard.

Download your copy here.

2020-03-05 - pgAdmin 4 v4.19 Released

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

Notable changes in this release include:

  • Added Python 3.8 support.
  • Added accessibility support in AlertifyJS.
  • Added Czech language support.
  • Improvements in the UI for both default and dark themes.
  • Fix an issue where debugger not showing all arguments anymore after hitting SQL error while debugging.
  • Ensure that all the transactions should be canceled before closing the connections when a server is disconnected using pgAdmin.
  • Fixed Firefox monospaced issue by updating the font to the latest version.
  • Improve the style of the highlighted code after query execution for Dark mode.
  • Changed background pattern for geometry viewer to use #fff for all themes.

Download your copy here.

2020-02-06 - pgAdmin 4 v4.18 Released

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

Notable changes in this release include:

  • Added a Schema Diff tool to compare two schemas and generate a diff script.
  • Added support for a multi-level partitioned table.
  • Added labels and titles after parsing and validating all the pgAdmin4 web pages for accessibility.
  • Set input controls as read-only instead of disabled will allow tab navigation in the properties tab and also allow screen readers to read it.
  • Fix an issue where select, insert and update scripts on tables throwing an error.
  • Logout the pgAdmin session when no user activity of mouse move, click or keypress.
  • Fixed an issue where Grant wizard unable to handle multiple objects when the query string parameter exceeds its limit.
  • Ensure that path file name should not disappear when changing ext from the dropdown in file explorer dialog.
  • Fix an issue where setting STORAGE_DIR to empty should show all the volumes on Windows in server mode.

Download your copy here.

2020-01-09 - pgAdmin 4 v4.17 Released

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

Notable changes in this release include:

  • Allow screen-reader to read relationship attributes in nested elements.
  • Ensure all binaries are securely signed and linked with the hardened runtime in the macOS bundle.
  • Added support to view multilevel partitioned tables.
  • Rename some internal environment variables that could conflict with Kubernetes.
  • Fix an issue where operator, access method and operator class is not visible for exclusion constraints.
  • Ensure that constraints, indexes, rules, triggers, and compound triggers should be created on partitions.
  • Fix syntax highlighting in code mirror for backslash and escape constant.
  • Ensure that the user should be able to select/modify tablespace for the partitioned table on v12 and above.
  • Added support for on-demand loading of items in Select2

Download your copy here.

2019-12-12 - pgAdmin 4 v4.16 Released

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

Notable changes in this release include:

  • Run pgAdmin in the container as a non-root user.
  • Added aria-label to provide an invisible label where a visible label cannot be used.
  • Added role="status" attribute to all the status messages for accessibility.
  • Use a 'play' icon for the Execute Query button in the Query Tool for greater consistency with other applications.
  • Allow Gunicorn logs in the container to be directed to a file specified through GUNICORN_ACCESS_LOGFILE.
  • Fix network disconnect issue while establishing the connection via SSH Tunnel and it impossible to expand the Servers node.
  • Ensure that the superuser should be able to create role, as the superuser overrides all the access restrictions.
  • Enhance the logic to change the label from 'Delete/Drop' to 'Remove' for the server and server group node.
  • Fix VPN network disconnect issue where pgAdmin4 hangs on expanding the Servers node.
  • Ensure that the Servers collection node should expand independently of server connections.
  • Fix pgAdmin4 failed to start issue after upgrading to version 4.15.

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