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, macOS and Windows to manage PostgreSQL and EDB Advanced Server 9.5 and above.

Screenshot of pgAdmin

Latest Videos

News

2021-02-25 - pgAdmin 4 v5.0 Released

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

Notable changes in this release include:

Features:

  • New Desktop Runtime (Using NWjs):
  • The Desktop Runtime is now based on NWjs which integrates a browser and the Python server creating a standalone application. By implementing it using NWjs we get rid of the separate server application and the independent browser. We also get rid of QT and C++ runtime logic.

    There are two minor known issues with this feature (6255 and 6258), both of which are due to bugs in NWjs itself; Users on macOS should use the application menu to exit pgAdmin, rather than quitting from the Dock icon to avoid the first issue. The second issue may cause Windows users to see a red square instead of the normal application icon in some circumstances.

  • Logical Replication support:
  • Logical replication uses a publish and subscribe model with one or more subscribers subscribing to one or more publications on a publisher node. We have added support for logical replication by introducing new treeview nodes and dialogues with which users can easily create/alter/delete publications and subscriptions. Support is also included in the Schema Diff tool.

  • Quick Search functionality:
  • Added a quick search option in the Help menu to search menu items and help articles. Type at least three characters to display all the matching possibilities under Menu items and the relevant documents under Help articles.

  • Make Statistics, Dependencies, Dependants tabs closable. Users can add them back using the 'Add panel' option on the context menu for the tab strip.
  • When running in Docker/Kubernetes, ensure logs are not stored in the container, and only sent to the console.

Bugs/Housekeeping:

  • Use cheroot as the default production server for pgAdmin4.
  • Updated Javascript dependencies to the latest versions.
  • Fixed an issue where the focus is not properly set on the filter text editor after closing the error dialog.
  • Fixed an issue where the dependencies tab shows multiple owners for the objects having shared dependencies.
  • Fixed an issue where the Zoom to fit button in the ERD Tool only works if the diagram is larger than the canvas.
  • Fixed an issue where the user was unable to change the background color for a server.
  • Fixed an issue where external utility jobs (backup, maintenance etc.) are failing when the log level is set to DEBUG.
  • Ensure DEB/RPM packages depend on the same version of each other.
  • Fixed an autocomplete issue where it is not showing any suggestions if the schema name contains escape characters.

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 5.0