A web based administration tool for the PostgreSQL database!

pgAdmin

pgAdmin

  -  286 MB  -  Freeware
  • Latest Version

    pgAdmin 4 8.11 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-8.11-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 8.11 Screenshots

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

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

What's new in this version:

New features:
- Add a home button to the geometry viewer to set original zoom level when the viewer was opened

Housekeeping:
- Upgrade react-data-grid fork to latest and change pgAdmin accordingly
- Introduce custom React Hook useSchemaState to simplify SchemaView component

Fixed:
- Fixed an issue where refreshing the Schema Diff tool opened in a new tab caused an error
- Fix server heartbeat logging error after deleting the server
- Fixed an issue where the Generate Script ignored filter conditions when a parent node was selected
- Fixed an issue where delete object(shortcut key) affecting both text and Object Explorer items
- Fix an issue where ERD tool should to be able to open saved pgerd file when using keyboard shortcuts
- Updated the documentation for web server authentication
- Fixed an issue where the REVOKE statement in the create script was throwing an error if the role contained special characters
- Improve code highlighting in query editor
- Fix an issue where the wheel package is not getting installed on the arm64-based macOS version < 14
- Fixed an issue where column resizing is not working in search objects dialog
- Fixed an issue where the value in the find box is not updating with selected text in editor if find is already open and re-triggered
- Fixed paths for Flatpak broken after Electron changes