A web based administration tool for the PostgreSQL database!

pgAdmin

pgAdmin

  -  195 MB  -  Freeware
  • Latest Version

    pgAdmin 4 9.0 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    Windows 8 (64-bit) / Windows 10 (64-bit) / Windows 11

  • User Rating

    Click to vote
  • Author / Product

    pgAdmin Team / External Link

  • Filename

    pgadmin4-9.0-x64.exe

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 is a management tool for PostgreSQL and derivative relational databases such as EnterpriseDB's EDB Advanced Server. It may be run either as a web or desktop application.

Features and Highlights
  • Desktop mode, using a purpose-built runtime
  • Server mode, supporting multiple users over the web
  • Powerful query tool with color syntax highlighting
  • Fast datagrid for display/entry of data
  • Graphical query plan display
  • Grant Wizard for rapid updates to ACLs
  • Procedural language debugger (supporting pl/pgsql and edb-spl)
  • Auto-vacuum management
  • Monitoring dashboard
  • Backup, restore, vacuum and analyze on-demand
  • SQL/shell/batch job scheduling agent
  • Create, view and edit all common PostgreSQL objects
  • Designed for multiple PostgreSQL versions and derivatives
pgAdmin supports most PostgreSQL server-side encodings:
  • SQL_ASCII
  • EUC_JP, EUC_CN, EUC_KR, EUC_TW
  • JOHAB
  • LATIN1, LATIN2, LATIN3, LATIN4, LATIN5, LATIN6, LATIN7, LATIN8, LATIN9, LATIN10
  • ISO_8859_5, ISO_8859_6, ISO_8859_7, ISO_8859_8
  • UNICODE/UTF-8
  • MULE_INTERNAL
  • KOI8
  • WIN
  • ALT
  • WIN1256
  • TCVN
  • WIN874


  • pgAdmin 4 9.0 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    pgAdmin 4 9.0 Screenshot 1
  • pgAdmin 4 9.0 Screenshot 2
  • pgAdmin 4 9.0 Screenshot 3
  • pgAdmin 4 9.0 Screenshot 4
  • pgAdmin 4 9.0 Screenshot 5

What's new in this version:

New features:
- Change button labels and color in delete confirmation dialog for all objects to improve UX
- Enhanced pgAdmin 4 with support for Workspace layouts
- Added the MAINTAIN privilege for PostgreSQL version 17 and above
- Add support for OAuth2 profile array response, which also takes care of the GitHub Private Email ID issue

Housekeeping:
- Show the python version used for the pgAdmin server in the about dialog

Fixed:
- Change the logic of setval function, so that the next nextval of sequence will return exactly the specified value
- Fixed an issue where pgadmin cannot install into path with non ASCII characters
- Fixed an issue where filter dialog save fails when the PostgreSQL server/database connection is lost
- Fixed an issue where option key was not registering in PSQL tool
- Fixed an issue where Schema Diff not produce difference script for Index definition with where condition
- Correct the documentation for the MFA configuration
- Fixed an issue where error message from the database server need space between two sentences
- Fixed an issue where query tool throws utf-8 decode error when using cursor with binary data
- Allow deleting the entry while creating/adding new label to enumeration type
- Fixed an issue where properties dialog throwing an error for Materialized View
- Fix a formatting issue in View/Edit tool generated SQL where some filters are applied
- Fixed an issue where tooltip on a dropdown button is blocking access to dropdown menu
- Fix the error occurring while loading preferences on startup
- Fixed an issue where copying query tool output cell is not working if any SQL text is selected
- Ensure master password pop up is not shown on setting MASTER_PASSWORD_REQUIRED to false
- Remove the option “With no data (concurrently)” from Refresh MATERIALIZED VIEW context menu
- Fix an issue where wrong information is shown after using the filter on the Dashboard> State tab
- Fixed an issue where PSQL tool is not opening if database name have HTML characters in the name
- Fixed an issue where Default Privileges and Privileges not working correctly
- Fixed an issue where quotes were missing in the CREATE script for the tablespace