A web based administration tool for the PostgreSQL database!

pgAdmin

pgAdmin

  -  184 MB  -  Freeware
  • Latest Version

    pgAdmin 4 8.9 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.9-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.9 Screenshots

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

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

What's new in this version:

New features:
- Provide option to set theme based on OS theme preference

Housekeeping:
- Remove the usage of MUI makeStyles as it doesn’t support React 18

Fixed:
- Disable the query tool editor input if any SQL is being loaded to prevent users from typing
- Fixed an issue where resizable data editors in query tool should not be allowed to resize beyond the app window bounds
- Fixed new line indentation in query editor and add a user preference to disable it
- Ensure that a user can connect to a server using SSL certificates and identity files from a shared storage
- Fixed an issue where object explorer toolbar button not showing shortcut in the tooltip
- Add support for comments on RLS policy object
- Fixed an issue where changing a column name should reflect in all the constraints in table object dialog and ERD table dialog
- Fixed an issue where dark theme shows white background when all tabs are closed
- Ensure preferences can be loaded using preferences.json
- Fixed an issue where the schema diff incorrectly marked tables as different due to schema-qualified trigger functions in the trigger definitions
- Fixed an issue where backslash breaks syntax highlighting
- Search Objects dialog should focus on search input on open
- Fixed incorrect sorting of size in statistics tab
- Fixed an issue where query tool shortcuts for find/replace are not working
- Fixed migration failure while using external database
- Fixed an issue where query tool auto-complete stops working after connection change
- Fix the permissions issue in the pgAdmin installation directory on Debian and RHEL-8 platforms
- Fixed an issue where delete button in Users data was enabled for incorrect rows