Fork me on GitHub

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 10 and above.

Screenshot of pgAdmin

Latest Videos

Want to see your pgAdmin video here? Email webmaster@pgadmin.org.

Latest Blog Posts

AWS RDS PostgreSQL Deployment with pgAdmin 4

Author: Yogesh Mahajan, date: Aug. 17, 2022

This blog explains and provides a walkthrough of the pgAdmin AWS RDS deployment wizard which can be used to deploy a new PostgreSQL database in the Amazon AWS cloud and register it with pgAdmin so you can begin working with it immediately.

Read more

pgAdmin User Survey 2022

Author: Dave Page, date: Aug. 2, 2022

On Monday 11th July the pgAdmin Development Team opened the first pgAdmin user survey which we then ran for three weeks, closing it on Monday 1st August. The aim of the survey was to help us understand how users are using pgAdmin to help us shape and focus our future development efforts. We had a fantastic response with 278 people taking the time to complete the survey - far exceeding our expectations. Responses were generally positive as well, with a number of people expressing their appreciation for the work of the development team, which is always nice to hear. In this blog post I'll go through the high level topics of the survey and attempt to summarise what has been reported, and draw some initial conclusions. If you would like to take a look at the results yourself...

Read more

Autocomplete feature in Query Tool

Author: Akshay Joshi, date: June 10, 2022

To use autocomplete, begin typing your query; when you would like the query editor to suggest object names or commands that might be next in your query, press the Control + Space key combination. For example, type "SELECT * FROM " (without quotes, but with a trailing space), and then press the Control + Space key combination to select from a popup menu of autocomplete options.

Read more

Want to see your pgAdmin blog post here? Email webmaster@pgadmin.org.

News

2022-11-19 - pgAdmin 4 v6.16 Released

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

Notable changes in this release include:

Features:

  • Added support for storing configurations of pgAdmin in an external database.
  • Use the external database server to save the pgAdmin 4 user settings in situations where SQLite is not preferred. It is useful when adding HA support for the configuration database or to avoid using SQLite on non-ephemeral storage.

  • Added the ability to generate ERDs for tables.
  • Add the possibility to configure the Oauth2 claim which is used for the pgAdmin username.

Bugs/Housekeeping:

  • Fixed an issue where the screen was freezing while closing the wcDocker panel.
  • Ensure that autocomplete works properly with objects starting with double quotes.
  • Ensure that pgAdmin routes should have the SCRIPT_NAME prefix.
  • Ensure that the appropriate permissions are set on the key file before trying an SSL connection with the server in server mode.
  • Fixed an issue where the result grid was not working properly while trying to edit data by hitting Enter key.
  • Fixed an issue where AutoComplete was not working correctly due to incorrect regex.
  • Fixed an issue where the 'Confirm on close or refresh' setting was ignored when closing the query/ERD tool opened in the new tab.
  • Fixed an issue where pgadmin does not respect reverse proxy anymore.
  • Ensure that the load file paths are children of the storage directory.
  • Use the shared server username when opening the query tool.

Download your copy now!

2022-10-20 - pgAdmin 4 v6.15 Released

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

Notable changes in this release include:

Features:

  • Added support for IAM token based authentication for AWS RDS or Azure DB.
  • By using this feature, database connection starts with token-based authentication for AWS RDS or Azure DB. To achieve this we have added a password command option.

  • Added support to specify the background fill color to the table nodes in the ERD tool.
  • Allow reordering table columns using drag and drop in ERD Tool.
  • Add option to generate SQL with DROP table DDL in ERD Tool.
  • Added high availability options to AWS deployment.
  • Expose the Gunicorn limit_request_line parameter in the container, with the default set to the maximum of 8190.

Bugs/Housekeeping:

  • Fixed an exception that occurs while taking backup and SSL certificates/keys are not found in the specified path.
  • Ensure that the path to the psqlrc file is correct when multiple users open the PSQL tool at the same time.
  • Ensure that the query tool creates a new tab with the appropriate user when pressing Alt+Shift+Q.
  • Added the close button for all the notifications of the notistack.
  • Ensure that the scroll position should be preserved for the result set in the query tool on tab change.
  • Fixed an issue where the prompt is not visible when clicking on the 'save results to file' button on the large data.
  • Fixed error occurring while LDAP authentication for a user with multiple email attributes.
  • Fixed the cross-site scripting vulnerability.
  • Ensure that the login form is hidden if the authentication source is OAuth2 or Kerberos.
  • Fixed an issue where the password recovery link was not working.

Download your copy now!

2022-09-22 - pgAdmin 4 v6.14 Released

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

Note:The pgAdmin team has moved all issues from Redmine to GitHub. New issues can no longer be created on Redmine, and any existing issues should be updated on GitHub (each Redmine issue contains a link to the new GitHub issue). Issues can now be found at (https://github.com/pgadmin-org/pgadmin4/issues)

Notable changes in this release include:

Bugs/Housekeeping:

  • Port schema diff, search object, and the remaining component of ERD to React.
  • Remove Alertify, Slickgrid, Backgrid and Backform.
  • Fixes a redirect vulnerability when the user opens the pgAdmin URL.
  • Fixed an issue where pgAdmin failed to start due to bin path migration.
  • Fixed an issue where backup does not work due to parameter 'preexec_fn' no longer being supported.
  • Ensure that the dump servers functionality works from setup.py.
  • Ensure that the Import/Export server menu option is visible.
  • Fixed an issue with the non-visibility of columns added prior to import/export data.
  • Fixed ModuleNotFoundError when running setup.py to load/dump servers.
  • Fixed an issue where textarea of the JSON Editor does not resize with dialog.

Download your copy now!

2022-09-21 - Project moved to GitHub

The pgAdmin Project has now moved to GitHub!

The source code repository can be found at: https://github.com/pgadmin-org/pgadmin4.

Issues can be found at https://github.com/pgadmin-org/pgadmin4/issues. All issues have been migrated from the old Redmine trackers.

There are a number of other repositories also in our GitHub organisation for pgAgent, the website, and old versions of pgAdmin.

Please update your links and bookmarks accordingly!

2022-08-25 - pgAdmin 4 v6.13 Released

The pgAdmin Development Team is pleased to announce pgAdmin 4 versions 6.13. This release of pgAdmin 4 includes 37 bug fixes and new features. For more details please see the release notes.

Notable changes in this release include:

Features:

  • Added support to show all background processes in separate panel.
  • By using this feature, the background process can be seen in the new processes panel. You can view details regarding Backup, Restore, Maintenance, Import/Export, and creating a Cloud instance.

  • Added support to create triggers from existing trigger functions in EPAS.

Bugs/Housekeeping:

  • Port Role Reassign, User Management, Change Ownership, and URL Dialogs to React.
  • Fixed improper parsing of HTTP requests in Pallets Werkzeug v2.1.0 and below (CVE-2022-29361).
  • Pin Flask-SocketIO <= v5.2.0. The latest version does not support Werkzeug in production environments.
  • Ensure that an error is thrown if clipboard access is not provided and change the copy rows shortcut.
  • Ensure that autocomplete does not appear when navigating code using arrow keys.
  • Fixed crypt key is missing issue when logout from the pgAdmin.
  • Ensure that rename panel should work on view/edit panels.
  • Fixed an issue where schema diff did not pick up the change in RLS policy.
  • Fixed an issue with rendering geometry when selecting a complete column.
  • Fixed an issue where copy and pasting a row in the results grid doesn't set the default for boolean.

Note: PostgreSQL/EDB Advanced Server 9.6 and lower will no longer be supported from this release onwards.

Download your copy now!

2022-07-28 - pgAdmin 4 v6.12 Released

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

Notable changes in this release include:

Features:

  • Added support for visualizing the graph using Stacked Line, Bar, Stacked Bar, and Pie charts in the query tool.
  • With this feature, users can visualize the query result set as a Stacked Line, Bar, Stacked Bar, and Pie chart. A new button 'Graph Visualiser' has been added to the Data output panel.

  • Added option to trigger autocomplete on key press in the query tool.
  • This feature allows autocomplete to be accessed with a key press in the query tool. One new parameter is added to Preferences -> Query Tool -> Auto completion -> ‘Autocomplete on key press’ to disable it.

  • Allow users to search within the file/storage manager.
  • Allow users to delete files/folders from the storage manager.

Bugs/Housekeeping:

  • Port the file/storage manager to React.
  • Port change password, master password, and named restore point dialog to React.
  • Ensure that the splash screen can be moved.
  • Ensure that notices should not disappear from the messages tab.
  • Ensure that geometry should be shown for all the selected cells.
  • Preserve the settings set by the user in the import/export data dialog.
  • Fixed an issue where new folders cannot be created in the save dialog.

Download your copy now!

2022-07-11 - pgAdmin User Survey

In order to help us better plan the future of pgAdmin, it's essential that we hear from users so we can focus our efforts in the areas that matter most.

We'd like to gather feedback from as many users as possible, so please take a few minutes and complete the survey below. Feel free to share the link with any friends or colleagues who you think may also want to provide their input.

https://forms.gle/62gzUPNbj4N1jNTB6

Please note that the survey is entirely anonymous (although Google will see your IP address, and may know who you are if you are logged in to your Google account), unless you choose to include any identifying information in any of your responses.

Thank you!

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 6.16

Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.