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

2019-11-14 - pgAdmin 4 v4.15 Released

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

Notable changes in this release include:

  • Added Dark(Beta) UI Theme option.
  • Added support for custom theme creation and selection.
  • Added encrypted password in reverse engineered SQL for roles.
  • Support Enable Always and Enable Replica on triggers.
  • Add an option to request confirmation before cancelling/resetting changes on a Properties dialog.
  • Rename the context menu from 'Drop Server' to 'Remove Server'.
  • Fixed issue where Drop and Disconnect connection menu points are too close to each other.
  • Ensure all messages are retained in the Query Tool from long running queries.
  • Ensure compression level is passed to pg_dump when backing up in directory format.
  • Ensure the number of jobs can be specified when backing up in directory format.

Download your copy here.

2019-10-17 - pgAdmin 4 v4.14 Released

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

Notable changes in this release include:

  • Added Copy with headers functionality when copy data from Query Tool/View Data.
  • Implemented the Query Plan Analyser.
  • Include PostgreSQL 12 binaries in the container.
  • Ensure the MAC OSX app should be notarized for Catalina.
  • Optimize Webpack to improve overall performance.
  • Ensure backup a partition table should not backup the whole database.
  • Ensure that 'ENTER' key in the data filter should not run the query.
  • Highlighted the color of closing or opening parenthesis when user select them in CodeMirror.
  • Ensure that pgAdmin should work behind reverse proxy if the inbuilt server is used as it is.
  • Ensure the search path should not be quoted for Database.
  • Ensure the search path should not be quoted for Function, Procedure and Trigger Function.
  • Fix issue where VALID foreign keys show as NOT VALID in the SQL tab for tables.

Download your copy here.

2019-09-19 - pgAdmin 4 v4.13 Released

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

Notable changes in this release include:

  • Added Gather Merge, Named Tuple Store Scan and Table Function Scan icon for explain module.
  • Don't wait for the database connection before rendering the Query Tool UI, for improved UX.
  • Allow configuration options to be set from the environment in the container distribution.
  • Ensure editable and read-only columns in Query Tool should be identified by icons and tooltips in the column header.
  • Add an Italian translation.
  • Refactor Dockerfile to avoid needing to run supporting scripts (i.e. 'docker build .' will work) and minimise layers.
  • Ensure Boolean columns should be editable using keyboard keys.
  • Fix error while importing data to a table using Import/Export dialog and providing "Not null columns" option.
  • Fix an issue where oid column should not be pasted when copy/paste row is used on query output containing the oid column.
  • Ensure port and username should not be mandatory when a service is provided.
  • Unescape HTML entities in database names in the Query Tool title bar.
  • Fix PGADMIN_SERVER_JSON_FILE environment variable support in the container.
  • Ensure sequence with negative value should be created.
  • Fix issue where EXEC script doesn't write the complete script for Procedures.

Download your copy here.

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.

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