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-05-02 - pgAdmin 4 v4.6 Released

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

Notable changes in this release include:

  • Depend on psycopg2-binary in the Python wheel, rather than psycopg2.
  • Added support for Default Partition.
  • Ensure that record should be add/edited for root partition table with primary keys.
  • Ensure the treeview shows all sequences except those used to implement IDENTITY columns (which can be edited as part of the column). Show all if Show System Objects is enabled.
  • Prevent duplicate columns being included in reverse engineered SQL for tables.
  • Ensure sanity of the permissions on the storage and session directories and the config database.
  • Ensure that on clicking Delete button should not delete rows immediately from the database server, it should be deleted when Save button will be clicked.

Download your copy here.

2019-04-10 - pgAdmin 4 v4.5 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.5. This release of pgAdmin 4 includes over 5 bug fixes. For more details please see the release notes here.

Notable changes in this release include:

  • Ensure that pgAdmin4 should work properly with psycopg2 v2.8.
  • Fixed 'Change Password' issue for SCRAM authentication.
  • Ensure that two consecutive SELECT statements should work properly.
  • Relabel the Save button on the datagrid text editor to avoid confusion with the actual Save button that updates the database.

Download your copy here.

2019-04-04 - pgAdmin 4 v4.4 Released

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

Notable changes in this release include:

  • Add support for reverse proxied setups with Gunicorn, and document Gunicorn, uWSGI & NGINX configurations
  • Make the Query Tool history persistent across sessions
  • Add support for IDENTITY columns
  • Add an ePub doc build target
  • Update all Python and JavaScript dependencies
  • Update wcDocker to fix the issue where the Scratch Pad grows in size if the results panel is resized
  • Enlarge the grab handles for resizing dialogs
  • Use the user's full email address (not just the username part) as the basis for the storage directory name

Download your copy here.

2019-03-07 - pgAdmin 4 v4.3 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.3. 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 a "scratch pad" to the Query Tool to hold text snippets whilst editing.
  • Add Commit and Rollback buttons to the Query Tool.
  • Automatically expand child nodes as well as the selected node on the treeview if there is only one.
  • Include multiple versions of the PG utilties in containers.
  • Update Alpine Linux version in the docker container.
  • Support double-click on Query Tool result grid column resize handles to auto-size to the content.
  • Allow X-FRAME-OPTIONS to be set for security. Default to SAMEORIGIN.
  • Install a script to start pgAdmin (pgadmin4) from the command line when installed from the Python wheel.
  • Close connections gracefully when the user logs out of pgAdmin.

Download your copy here.

2019-02-07 - pgAdmin 4 v4.2 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.2. This release of pgAdmin 4 includes over 40 bug fixes. For more details please see the release notes here.

Notable changes in this release include:

  • Replace Bootstrap switch with Bootstrap4 toggle to improve the performance
  • Fixed Statistics panel hang issue for 1000+ tables
  • Ensure that browser should warn before close or refresh
  • Increase frames splitter mouse hover area to make it easier to resize
  • Fixed Query Tool Initialization Error
  • Dashboard graph optimization
  • Fixed keyboard navigation for dialog tabs
  • Ensure that output of the query should be displayed even if Data Output window is detached from the Query Tool

Download your copy here.

2019-01-15 - pgAdmin 4 v4.1 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.1. This release of pgAdmin 4 includes over 7 bug fixes. For more details please see the release notes here.

Notable changes in this release include:

  • Ensure that last row of table data should be visible and user will be able to add new row
  • Fix ordering of VACUUM options which changed in PG11
  • Ensure the context menu works after a server is renamed
  • Make the browser more robust in the face of multibyte characters in SQL_ASCII databases

Download your copy here.

2019-01-10 - pgAdmin 4 v4.0 Released

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

Notable changes in this release include:

  • Slick new UI design
  • Allow query plans to be downloaded as an SVG file
  • Allow servers to be pre-loaded into container deployments

Download your copy here.

2018-11-29 - pgAdmin 4 v3.6 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.6. This release of pgAdmin 4 includes over 10 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 support for dropping multiple objects at once from the collection Properties panel.
  • Add the ability to import and export server definitions from a config database.

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