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

Quick Links


Download


FAQ


Latest Docs


Get Help


Screenshots

Latest Videos

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

All videos

Latest Blog Posts

Configuring and Using Shared Storage in pgAdmin 4

Author: Nikhil Mohite, date: May 31, 2023

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL. In this blog, I will walk you through how to configure and use shared storage in pgAdmin 4.

Read more

How to use pgAgent in pgAdmin 4

Author: Pravesh Sharma, date: May 10, 2023

pgAgent is a tool used for scheduling jobs for PostgreSQL databases. Each job consists of steps and schedules. In this blog we will look at how pgAdmin can be used to create scheduled jobs using pgAgent with PostgreSQL, with steps and schedules to achieve what you want, when you want.

Read more

Setup pgAdmin development environment

Author: Aditya Toshniwal, date: May 10, 2023

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL. In this blog, I will walk you through how to set up the pgAdmin development environment on your machine. The code repository for pgAdmin 4 is: https://github.com/pgadmin-org/pgadmin4.

Read more

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

All blog posts

News

2023-07-27 - pgAdmin 4 v7.5 Released

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.5. 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 to detach partitions using concurrently and finalize.
  • Added all supported index storage parameters while creating an index.
  • Added new/missing parameters to pg_dump, pg_dumpall and pg_restore.

Bugs/Housekeeping:

  • Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS.
  • Fix an issue where queries longer than 1 minute get stuck.
  • Fix an issue where queries can't complete execution.
  • Fix an issue where queries get stuck with auto-completion enabled.
  • Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used.
  • Fixed an issue where pgAdmin failed to setup role with hyphens in name.
  • Fixed an issue where filters are not working and query history shows empty queries.
  • Fix an issue where adding a sub-folder inside a folder is not working as expected in File Manager.
  • Fix an issue where inserting more than 10 rows does not work correctly in View Data; only parts end up in the table.
  • Ensure user gets proper error if incorrect credentials are entered while authenticating AWS.

Download your copy now!

2023-06-29 - pgAdmin 4 v7.4 Released

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

Notable changes in this release include:

Features:

  • Added support to drop databases using the 'WITH (FORCE)' option.
  • Add '[ NULLS [ NOT ] DISTINCT ]' option while creating an Index.
  • Added 'OR REPLACE' clause while creating a trigger.
  • Added security_invoker option while creating a view.

Bugs/Housekeeping:

  • Fix an issue where the object explorer tree crashes occasionally.
  • Ensure that query tool shortcuts are working properly.
  • Add Password exec command and Expiration time to server export JSON and also allow them to import.
  • When opening pgAdmin the layout should be auto-reset if it is corrupted. Reset layout menu should work if the layout is corrupted while using pgAdmin.
  • Fixed an issue where queries with temporary tables in the same transaction are not working.
  • Fix raise notice from func/proc or code blocks are no longer displayed live.
  • Fix an issue where PSQL is not working if the database name has quotes or double quotes.
  • Fix an encoding error when connecting through Pgbouncer.
  • Fix an issue where explain plan details are showing HTML escaped characters.
  • Fixed an issue where preview images for themes were not loading.

Download your copy now!

2023-06-06 - pgAdmin 4 v7.3 Released

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

Notable changes in this release include:

Bugs/Housekeeping:

  • Ensure that SSH Tunnel should work properly after upgrading to 7.2 from 7.1.
  • Ensure that the master password dialog should not be visible if the parameter MASTER_PASSWORD_REQUIRED is set to False.
  • Fixed an issue where Foreign Key with 3 or more columns are shown in the wrong order in SQL and Properties.
  • Fix an issue where editing a database object de-selects it on the browser tree.
  • Fixed an issue where pgadmin is unable to take the defined role.

Download your copy now!

2023-06-01 - pgAdmin 4 v7.2 Released

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

Note:

From this release onwards pgAdmin 4 will now use the operating system's password store to save the server passwords in desktop mode instead of using Master Password.

Notable changes in this release include:

Features:

  • Add Option to only show active connections on Dashboard.
  • Allow pgAdmin to retrieve master password from external script/program.
  • Add an option to hide/show empty object collection nodes.
  • Added support to use standard OS secret store to save server/ssh tunnel passwords instead of master password in pgAdmin desktop mode.
  • Implement new PostgreSQL 15 features in publication dialog and SQL.

Bugs/Housekeeping:

  • Fixed an issue where Foreign Key columns are shown in the wrong order in SQL and Properties.
  • Ensure that a new row should be added on top in the User Management dialog.
  • Fixed an issue where REVOKE ALL DDL in table SQL was added only for one role.
  • Tools menu should be toggled for "pause replay of wal" and "resume replay of wal".
  • Make the 'Connect to server' dialog a modal dialog.
  • Fixed an issue where PSQL tool prompts for password if using password exec command.
  • Fix circular reference error for the multirange data types in the query tool.
  • Fix an issue in the register server when setting the role, an arbitrary SQL query can be fired.
  • View SQL tab not quoting column comments.
  • VarChar Field Sizes are missing from Query's Grid header.

Download your copy now!

2023-05-04 - pgAdmin 4 v7.1 Released

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

Notable changes in this release include:

Features:

  • Show object breadcrumbs path along with its comment on object hover.
  • Allow on demand record count setting to be changed per user using preferences.
  • Added support to show statistics for materialized views.
  • Added support to create an unnamed index.

Bugs/Housekeeping:

  • Mac crash when you press Command-Shift-C.
  • Fixed an issue where Reset Password is not working after upgrading to latest flask-security-too.
  • Ensure that the ERD tool should work with the external database after moving to psycopg3.
  • Fixed an issue with the properties tab not getting updated if the user updates the selected node.
  • Fix an issue in View SQL when column level privileges are set with multiple roles.
  • Fixed an issue where query tool hangs for some time when multiple columns are selected to open geometry viewer.
  • Ensure that when pasting a row in query tool grid, default value is used for autogenerated/serial columns.
  • Ensure to quote the primary key value if needed while deleting rows from the table.
  • Fixed an issue where PSQL is not working if the PGUSER env variable is set and service file is used for server connection details.
  • Show proper message if the debugger is stopped by the user.

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

All news

The current version of pgAdmin 4 is 7.5

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