A web based administration tool for the PostgreSQL database!

pgAdmin

pgAdmin

  -  192 MB  -  Freeware
  • Latest Version

    pgAdmin 4 8.13 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.13-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.13 Screenshots

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

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

What's new in this version:

Supported Database Servers:
- PostgreSQL: 12, 13, 14, 15, 16 and 17
- EDB Advanced Server: 12, 13, 14, 15, and 16

Bundled PostgreSQL Utilities:
- psql, pg_dump, pg_dumpall, pg_restore: 17.0

New features:
- Replace infinite scrolling with pagination in query tool data output for better UX and performance
- Add an object menu option to disconnect all server and database connections
- Alternate the background color of rows to enhance readability
- Allow to pass PGADMIN_CONFIG_CONFIG_DATABASE_URI from docker secrets
- Format dashboard graph metrics for better readability
- Added support for auto-detecting and setting the End-of-line character (LF/CRLF) in the query tool editor
- Make the background color for the serial number and header cells distinct

Housekeeping:
- Updated the react-menu library from v2 to v4
- Remove bootstrap from the runtime code
- Remove the dependency on python packages eventlet and greenlet

Fixed:
- Fixed an issue to allow the Enter key to save data in the result grid text editor
- Move ‘About pgAdmin 4’ to app menu on macOS
- Fixed an issue where the query tool was crashing when an empty geometry was being rendered
- Fixed an issue where role properties were not loading
- Fix multiple issues related to debugger params dialog input
- Fixed an issue where the dock layout was not saved upon closing a tab
- Fixed an issue where the copy shortcut CTRL +C was not working in the Query Tool data grid
- Fixed an issue where Dashboard tab showing ‘Something went wrong’
- Fixed an issue where cursor selection is not visible in the PSQL tool
- Allow OAuth2 params OAUTH2_NAME, OAUTH2_DISPLAY_NAME, OAUTH2_ICON, OAUTH2_BUTTON_COLOR to be optional
- Add appropriate minimum width and height setting for desktop apps to avoid app accidentally going below visibility levels
- Fixed an issue where graphical explain keeps the node details open even after plan changed
- Fixed an issue in the debugger where function arguments of the character data type were being truncated
- Fix the issue where rows do not retain shading when scrolling
- Use PG17 as the default in the container