News Archive

2020-12-10 - pgAdmin 4 v4.29 Released

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

Notable changes in this release include:

  • Ensure that folder rename should work properly in Storage Manager
  • Fixed an issue where the debugger's custom tab title not applied when opened in the new browser tab
  • Fixed an issue where dynamic tab title has not applied the first time for debugger panel
  • Fixed an issue where schema diff doesn't show the result of compare if source schema has tables with RLS
  • Fixed an issue where the process watcher dialog throws an error for the database server which is already removed
  • Ensure that code coverage should cover class and function declarations
  • Ensure that dirty indicator (*) should not be visible when renaming the tabs
  • Fixed an issue where shared servers import is failing
  • Improve code coverage and API test cases for Foreign Tables, Debugger, Views and Materialized Views

Download your copy now!

2020-11-12 - pgAdmin 4 v4.28 Released

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

Notable changes in this release include:

  • Added support to download utility files at the client-side.
  • Added support to rename query tool and debugger tabs title.
  • Added support for dynamic tab size.
  • Added tab title placeholder for Query Tool, View/Edit Data, and Debugger.
  • Added support to compare schemas and databases in schema diff.
  • Ensure that non-superuser should be able to debug the function.
  • Ensure that query history should be listed by date/time in descending order.
  • Ensure that Grant Wizard should include foreign tables.
  • Ensure that search object functionality works with case insensitive string.

Download your copy now!

2020-10-15 - pgAdmin 4 v4.27 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.27. 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:

  • Added Macro support.
  • Added support to view trigger function under the respective trigger node.
  • Allow user to change the database connection from an open query tool tab.
  • Added support to ignore the owner while comparing objects in the Schema Diff tool.
  • Merged the latest code of 'pgcli' used for the autocomplete feature.
  • Fixed invalid literal issue when fetching dependencies for Materialized View.
  • Fixed an issue where schema diff is showing identical table as different due to default vacuum settings.
  • Ensure that the user should be able to change the start value of the existing sequence.
  • Fixed an issue where the query tool is not fetching more than 1000 rows for the table does not have any primary key.
  • Fixed an issue where 'Rows X' column values were not visible properly for Explain Analyze in Dark theme.
  • Fixed an issue where file extension is stripped on renaming a file.

Download your copy now!

2020-09-17 - pgAdmin 4 v4.26 Released

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

Notable changes in this release include:

  • Added SQL Formatter support in Query Tool.
  • Added a new button to the query tool toolbar to open a new query tool window.
  • Added shared server support for admin users.
  • Warn the user when connecting to a server that is older than pgAdmin supports.
  • Ensure that schema names starting with 'pg' should be visible in browser tree when standard_conforming_strings is set to off.
  • Fixed an issue where --load-server does not allow loading connections that use pg_services.
  • Fixed string indices must be integers issue for PostgreSQL < 9.3.
  • Fixed an issue where the application ignores the fixed port configuration value.
  • Remove illegal argument from trigger function in trigger DDL statement.
  • Ensure that 'setup-web.sh' should work in Debian 10.
  • Fixed excessive CPU usage by stopping the indefinite growth of the graph dataset.

Download your copy now!

2020-08-20 - pgAdmin 4 v4.25 Released

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

Notable changes in this release include:

  • Modified schema diff tool to compare two databases instead of two schemas
  • Resolve schema diff dependencies by selecting the appropriate node automatically and maintain the order in the generated script.
  • Replace charting library Flotr2 with ChartJS using React.
  • Upgrade font-awesome from v4 to v5.
  • Fixed an issue where debugger doesn't work if the search path is set other than 'public'.
  • Fixed ssh tunnel hang issue when the user tries to disconnect the server.
  • Fixed an issue where conversion of bytea to the binary string results in an error.
  • Fixed an issue where the entire logs are in red text when the user runs backup and restore.
  • Ensure that the user will be able to modify the start value of the Identity column.
  • Fixed an issue where 'ALTER VIEW' statement is missing when the user sets the default value of a column for View.

Download your copy now!

2020-07-23 - pgAdmin 4 v4.24 Released

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

Notable changes in this release include:

  • Support configuration files that are external to the application installation.
  • Added support for LDAP authentication with different DN by setting the dedicated user for the LDAP connection.
  • Added support for schema level restriction.
  • Added RLS Policy support in Schema Diff.
  • Added support for permissive/restricted policy type while creating RLS Policy.
  • Added support for LDAP anonymous binding.
  • Added High Contrast theme support.
  • Added missing dependencies/dependent and corrected some wrongly identified.
  • Replace the runtime themes with ones that don't have sizing issues.
  • Fixed tab indent issue on a selection of lines is deleting the content when 'use spaces == true' in the preferences.
  • Fixed CSRF errors when pgAdmin opened in an iframe on safari browser.

Download your copy now!

2020-06-25 - pgAdmin 4 v4.23 Released

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

Notable changes in this release include:

  • Added option to ignore the whitespaces while comparing objects in schema diff.
  • Added server group name while selecting servers in schema diff.
  • Added support of Row Security Policies.
  • Improve error messaging if the storage and log directories cannot be created.
  • Cleanup Windows build scripts and ensure Windows x64 builds will work.
  • Fixed an issue where the Edge browser version is showing wrong and warning message gets displayed.
  • Fixed an issue where select all checkbox only selects the first 50 tables.
  • Fixed an issue where two identical tables showing different by schema diff tool.
  • Fixed an issue when dumping servers from a desktop pgAdmin app by providing an option '--sqlite-path'
  • Ensure that the query tool panel gets closed when clicking on the 'Don't Save' button.

Download your copy now!

2020-05-28 - pgAdmin 4 v4.22 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.22. This release of pgAdmin 4 includes over 36 bug fixes and new features. For more details please see the release notes.

Notable changes in this release include:

  • Show the startup log as well as the server log in the runtime's log viewer.
  • Implement Selenium Grid to run multiple tests across different browsers, operating systems, and machines in parallel.
  • Remove support for Python 2.
  • Ensure that maintenance job should be worked properly for indexes under a materialized view.
  • Ensure that file browse "home" button should point to $HOME rather than /.
  • Fixed data truncation issue when updating the data of type character with length
  • Fixed generated SQL issue for auto vacuum options.
  • Fixed internal server error when clicking on Triggers -> 'Enable All' for partitions
  • Fixed the SQL help issue for EDB Postgres Advanced Server.
  • Fixed an issue where if LDAP_SEARCH_BASE_DN is not set then, the value for LDAP_BASE_DN will be considered.
  • Improve code coverage and API test cases for Indexes, Rules, Triggers and Compound Triggers.

Download your copy now!

2020-04-30 - pgAdmin 4 v4.21 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.21. This release of pgAdmin 4 includes over 74 bug fixes and new features. For more details please see the release notes.

Notable changes in this release include:

  • Added LDAP authentication support.
  • Added search object functionality.
  • Added support of Foreign Tables, Packages, Sequences and Synonyms to the Schema Diff.
  • Warn the user if an unsupported, deprecated or unknown browser is detected.
  • Added multiple drop/delete functionality for the table constraints.
  • Fixed copy-paste row issues in View/Edit Data.
  • Added dark mode support for the configuration dialog on Windows/macOS runtime.
  • Added alert message to Reset Layout if any of the panels from Query Tool failed to load.
  • Fixed an issue when the user performs refresh on a large size materialized view.
  • Ensure that default sort order should be using the primary key in View/Edit data.
  • Fixed an issue where changing the values of columns with JSONB or JSON types to NULL
  • Ensure that if the delimiter is set other than comma then download the file as '.txt' file.

Download your copy now!

2020-04-02 - pgAdmin 4 v4.20 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.20. This release of pgAdmin 4 includes over 13 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Added support of Collation, FTS Configuration, FTS Dictionary, FTS Parser and FTS Template to the Schema Diff.
  • Added support of Domain, Domain Constraints and Types to the Schema Diff.
  • Added and fixed gettext usage for better translation coverage.
  • Improve logic to get the DDL statements as a part of the comparison.
  • Enhance the color of switch control for both light and dark theme.
  • Change some colors and opacity to comply with WCAG color contrast standards.
  • Fixed tab key navigation issue for Grant Wizard.
  • Fix an issue where the user can not change the value of DateTime picker control using keyboard.

Download your copy here.

2020-03-05 - pgAdmin 4 v4.19 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.19. This release of pgAdmin 4 includes over 18 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Added Python 3.8 support.
  • Added accessibility support in AlertifyJS.
  • Added Czech language support.
  • Improvements in the UI for both default and dark themes.
  • Fix an issue where debugger not showing all arguments anymore after hitting SQL error while debugging.
  • Ensure that all the transactions should be canceled before closing the connections when a server is disconnected using pgAdmin.
  • Fixed Firefox monospaced issue by updating the font to the latest version.
  • Improve the style of the highlighted code after query execution for Dark mode.
  • Changed background pattern for geometry viewer to use #fff for all themes.

Download your copy here.

2020-02-06 - pgAdmin 4 v4.18 Released

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

Notable changes in this release include:

  • Added a Schema Diff tool to compare two schemas and generate a diff script.
  • Added support for a multi-level partitioned table.
  • Added labels and titles after parsing and validating all the pgAdmin4 web pages for accessibility.
  • Set input controls as read-only instead of disabled will allow tab navigation in the properties tab and also allow screen readers to read it.
  • Fix an issue where select, insert and update scripts on tables throwing an error.
  • Logout the pgAdmin session when no user activity of mouse move, click or keypress.
  • Fixed an issue where Grant wizard unable to handle multiple objects when the query string parameter exceeds its limit.
  • Ensure that path file name should not disappear when changing ext from the dropdown in file explorer dialog.
  • Fix an issue where setting STORAGE_DIR to empty should show all the volumes on Windows in server mode.

Download your copy here.

2020-01-09 - pgAdmin 4 v4.17 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.17. This release of pgAdmin 4 includes over 20 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Allow screen-reader to read relationship attributes in nested elements.
  • Ensure all binaries are securely signed and linked with the hardened runtime in the macOS bundle.
  • Added support to view multilevel partitioned tables.
  • Rename some internal environment variables that could conflict with Kubernetes.
  • Fix an issue where operator, access method and operator class is not visible for exclusion constraints.
  • Ensure that constraints, indexes, rules, triggers, and compound triggers should be created on partitions.
  • Fix syntax highlighting in code mirror for backslash and escape constant.
  • Ensure that the user should be able to select/modify tablespace for the partitioned table on v12 and above.
  • Added support for on-demand loading of items in Select2

Download your copy here.

2019-12-12 - pgAdmin 4 v4.16 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.16. This release of pgAdmin 4 includes over 43 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Run pgAdmin in the container as a non-root user.
  • Added aria-label to provide an invisible label where a visible label cannot be used.
  • Added role="status" attribute to all the status messages for accessibility.
  • Use a 'play' icon for the Execute Query button in the Query Tool for greater consistency with other applications.
  • Allow Gunicorn logs in the container to be directed to a file specified through GUNICORN_ACCESS_LOGFILE.
  • Fix network disconnect issue while establishing the connection via SSH Tunnel and it impossible to expand the Servers node.
  • Ensure that the superuser should be able to create role, as the superuser overrides all the access restrictions.
  • Enhance the logic to change the label from 'Delete/Drop' to 'Remove' for the server and server group node.
  • Fix VPN network disconnect issue where pgAdmin4 hangs on expanding the Servers node.
  • Ensure that the Servers collection node should expand independently of server connections.
  • Fix pgAdmin4 failed to start issue after upgrading to version 4.15.

Download your copy here.

2019-11-21 - Try pgAdmin online!

Our friends at EnterpriseDB have kindly made an online demo environment for pgAdmin available to allow new users to try it out in their browser without needing to download or install any software. The environment (based on the Katacoda learning platform) includes pgAdmin and PostgreSQL 12, preloaded with the pagila sample database, and is unique to every user allowing a far better experience than typical shared demo environments.

Try it out now!

2019-11-14 - pgAdmin 4 v4.15 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.15. This release of pgAdmin 4 includes over 33 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Added Dark(Beta) UI Theme option.
  • Added support for custom theme creation and selection.
  • Added encrypted password in reverse engineered SQL for roles.
  • Support Enable Always and Enable Replica on triggers.
  • Add an option to request confirmation before cancelling/resetting changes on a Properties dialog.
  • Rename the context menu from 'Drop Server' to 'Remove Server'.
  • Fixed issue where Drop and Disconnect connection menu points are too close to each other.
  • Ensure all messages are retained in the Query Tool from long running queries.
  • Ensure compression level is passed to pg_dump when backing up in directory format.
  • Ensure the number of jobs can be specified when backing up in directory format.

Download your copy here.

2019-10-17 - pgAdmin 4 v4.14 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.14. This release of pgAdmin 4 includes over 21 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Added Copy with headers functionality when copy data from Query Tool/View Data.
  • Implemented the Query Plan Analyser.
  • Include PostgreSQL 12 binaries in the container.
  • Ensure the MAC OSX app should be notarized for Catalina.
  • Optimize Webpack to improve overall performance.
  • Ensure backup a partition table should not backup the whole database.
  • Ensure that 'ENTER' key in the data filter should not run the query.
  • Highlighted the color of closing or opening parenthesis when user select them in CodeMirror.
  • Ensure that pgAdmin should work behind reverse proxy if the inbuilt server is used as it is.
  • Ensure the search path should not be quoted for Database.
  • Ensure the search path should not be quoted for Function, Procedure and Trigger Function.
  • Fix issue where VALID foreign keys show as NOT VALID in the SQL tab for tables.

Download your copy here.

2019-09-19 - pgAdmin 4 v4.13 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.13. This release of pgAdmin 4 includes over 46 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Added Gather Merge, Named Tuple Store Scan and Table Function Scan icon for explain module.
  • Don't wait for the database connection before rendering the Query Tool UI, for improved UX.
  • Allow configuration options to be set from the environment in the container distribution.
  • Ensure editable and read-only columns in Query Tool should be identified by icons and tooltips in the column header.
  • Add an Italian translation.
  • Refactor Dockerfile to avoid needing to run supporting scripts (i.e. 'docker build .' will work) and minimise layers.
  • Ensure Boolean columns should be editable using keyboard keys.
  • Fix error while importing data to a table using Import/Export dialog and providing "Not null columns" option.
  • Fix an issue where oid column should not be pasted when copy/paste row is used on query output containing the oid column.
  • Ensure port and username should not be mandatory when a service is provided.
  • Unescape HTML entities in database names in the Query Tool title bar.
  • Fix PGADMIN_SERVER_JSON_FILE environment variable support in the container.
  • Ensure sequence with negative value should be created.
  • Fix issue where EXEC script doesn't write the complete script for Procedures.

Download your copy here.

2019-08-22 - pgAdmin 4 v4.12 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.12. This release of pgAdmin 4 includes over 38 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Add support of Compound Triggers for EPAS 12+.
  • Add support for planner support functions in PostgreSQL 12+ functions.
  • Add support for generated columns in Postgres 12+.
  • Use the full tab space for CodeMirror instances on dialogues where appropriate.
  • Allow a banner to be displayed on the login and other related pages showing custom text.
  • Allow enhanced cookie protection to be disabled for compatibility with dynamically addressed hosting environments.
  • Add an optimisation to the internal code responsible for searching for treeview nodes.
  • Display the row count in the popup message when counting table rows, not just in the properties list.
  • Add support in query history to show internal queries generated by pgAdmin during save data operations.
  • Update wcDocker to allow the browser's context menu to be used except in tab strips and panel headers.
  • Fix generation of reverse engineered SQL for partition table, partitions were shown as a child of indexes.
  • Update wcDocker to prevent window state loading creating blank dialogues.
  • Ensure the query tool will work with older versions of psycopg2 than we officially support, albeit without updatable resultsets

Download your copy here.

2019-07-25 - pgAdmin 4 v4.11 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.11. This release of pgAdmin 4 includes over 34 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Add support for editing of resultsets in the Query Tool, if the data can be identified as updatable.
  • Add EXPLAIN options for SETTINGS and SUMMARY.
  • Set the mouse cursor appropriately based on the layout lock state.
  • Prevent flickering of large tooltips on the Graphical EXPLAIN canvas.
  • Fix an error while retrieving json data from the table.
  • Fix 'malformed array literal' error when updating a pgAgent job.
  • Fix an error that could be seen when editing column privileges.
  • Fix an error seen when updating a connection string in a pgAgent job step.
  • EXPLAIN options should be Query Tool instance-specific.
  • Allow keyboard navigation of all controls on subnode grids.

Download your copy here.

2019-07-04 - pgAdmin 4 v4.10 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.10. This release of pgAdmin 4 includes over 6 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Allow some objects to be dragged/dropped into the Query Tool to insert their signature into the query text.
  • Allow the path to /pgadmin4/servers.json to be overridden in the container distribution.
  • Ensure the browser close confirmation is only shown when closing a Query Tool which is running in a separate browser tab.
  • Prevent an error that may occur when editing data with an integer primary key.
  • Fix a quoting issue that caused a blank UI to be displayed when running in French.
  • Ensure the version comparision should be correct for windows installer.

Download your copy here.

2019-06-27 - pgAdmin 4 v4.9 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.9. This release of pgAdmin 4 includes over 27 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Visually distinguish simple tables from tables that are inherited and from which other tables are inherited.
  • Add a framework for testing reversed engineered SQL and CRUD API endpoints.
  • Initial support for PostgreSQL 12.
  • Ensure we include the CSRF token when uploading files.
  • Prevent the geometry viewer grabbing key presses when not in focus under Firefox, IE and Edge.
  • Ensure that browser auto-fill doesn't cause Help pages to be opened unexpectedly.
  • Fix an initialisation error when two functions with parameters are debugged in parallel.
  • Remove additional "SETOF" included when generating CREATE scripts for trigger functions.
  • Ensure the correct label is used in panel headers when viewing filtered rows.
  • Fix issue where new column should be created with Default value.
  • Fix keyboard navigation in "inner" tabsets such as the Query Tool and Debugger.

Download your copy here.

2019-06-03 - pgAdmin 4 v4.8 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.8. This release of pgAdmin 4 includes over 4 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Allow the UI layout to be fully locked or to prevent docking changes.
  • Fix the issue of accessing the SQL for Views and Materialized Views. Regression of pluralisation of folder names.
  • Omit the geometry viewer in the Query Tool from layout saving.
  • Improve the performance of explain plan by embedding the images only when downloading it.

Download your copy here.

2019-05-30 - pgAdmin 4 v4.7 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.7. This release of pgAdmin 4 includes over 22 bug fixes. For more details please see the release notes here.

Notable changes in this release include:

  • Fixed CSRF security vulnerability issue, per Alvin Lindstam.
  • Added Master Password to increase the security of saved passwords.
  • In server mode, update all the saved server credentials when user password is changed.
  • Fix the responsive layout of the main menu bar.
  • Fix file browser path issue which occurs when client is on Windows and server is on Mac/Linux.
  • Clarify wording for the NO INHERIT option on constraints, per Michel Feinstein.
  • Update the UI logo.
  • Relax the permission check on the directory containing the config database, as it may fail in some environments such as OpenShift.
  • Stop using application/x-javascript as a mime type and use the RFC-compliant application/javascript instead.

Download your copy here.

2019-05-02 - pgAdmin 4 v4.6 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.6. This release of pgAdmin 4 includes over 17 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Depend on psycopg2-binary in the Python wheel, rather than psycopg2.
  • Added support for Default Partition.
  • Ensure that record should be add/edited for root partition table with primary keys.
  • Ensure the treeview shows all sequences except those used to implement IDENTITY columns (which can be edited as part of the column). Show all if Show System Objects is enabled.
  • Prevent duplicate columns being included in reverse engineered SQL for tables.
  • Ensure sanity of the permissions on the storage and session directories and the config database.
  • Ensure that on clicking Delete button should not delete rows immediately from the database server, it should be deleted when Save button will be clicked.

Download your copy here.

2019-04-10 - pgAdmin 4 v4.5 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.5. This release of pgAdmin 4 includes over 5 bug fixes. For more details please see the release notes here.

Notable changes in this release include:

  • Ensure that pgAdmin4 should work properly with psycopg2 v2.8.
  • Fixed 'Change Password' issue for SCRAM authentication.
  • Ensure that two consecutive SELECT statements should work properly.
  • Relabel the Save button on the datagrid text editor to avoid confusion with the actual Save button that updates the database.

Download your copy here.

2019-04-04 - pgAdmin 4 v4.4 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.4. This release of pgAdmin 4 includes over 35 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Add support for reverse proxied setups with Gunicorn, and document Gunicorn, uWSGI & NGINX configurations
  • Make the Query Tool history persistent across sessions
  • Add support for IDENTITY columns
  • Add an ePub doc build target
  • Update all Python and JavaScript dependencies
  • Update wcDocker to fix the issue where the Scratch Pad grows in size if the results panel is resized
  • Enlarge the grab handles for resizing dialogs
  • Use the user's full email address (not just the username part) as the basis for the storage directory name

Download your copy here.

2019-03-07 - pgAdmin 4 v4.3 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.3. This release of pgAdmin 4 includes over 38 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Add a "scratch pad" to the Query Tool to hold text snippets whilst editing.
  • Add Commit and Rollback buttons to the Query Tool.
  • Automatically expand child nodes as well as the selected node on the treeview if there is only one.
  • Include multiple versions of the PG utilties in containers.
  • Update Alpine Linux version in the docker container.
  • Support double-click on Query Tool result grid column resize handles to auto-size to the content.
  • Allow X-FRAME-OPTIONS to be set for security. Default to SAMEORIGIN.
  • Install a script to start pgAdmin (pgadmin4) from the command line when installed from the Python wheel.
  • Close connections gracefully when the user logs out of pgAdmin.

Download your copy here.

2019-02-07 - pgAdmin 4 v4.2 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.2. This release of pgAdmin 4 includes over 40 bug fixes. For more details please see the release notes here.

Notable changes in this release include:

  • Replace Bootstrap switch with Bootstrap4 toggle to improve the performance
  • Fixed Statistics panel hang issue for 1000+ tables
  • Ensure that browser should warn before close or refresh
  • Increase frames splitter mouse hover area to make it easier to resize
  • Fixed Query Tool Initialization Error
  • Dashboard graph optimization
  • Fixed keyboard navigation for dialog tabs
  • Ensure that output of the query should be displayed even if Data Output window is detached from the Query Tool

Download your copy here.

2019-01-15 - pgAdmin 4 v4.1 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.1. This release of pgAdmin 4 includes over 7 bug fixes. For more details please see the release notes here.

Notable changes in this release include:

  • Ensure that last row of table data should be visible and user will be able to add new row
  • Fix ordering of VACUUM options which changed in PG11
  • Ensure the context menu works after a server is renamed
  • Make the browser more robust in the face of multibyte characters in SQL_ASCII databases

Download your copy here.

2019-01-10 - pgAdmin 4 v4.0 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.0. This release of pgAdmin 4 includes over 26 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Slick new UI design
  • Allow query plans to be downloaded as an SVG file
  • Allow servers to be pre-loaded into container deployments

Download your copy here.

2018-11-29 - pgAdmin 4 v3.6 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.6. This release of pgAdmin 4 includes over 10 bug fixes and new features. For more details please see the release notes here.

Note: This is the first release of pgAdmin on a new monthly release cycle.

Notable changes in this release include:

  • Add support for dropping multiple objects at once from the collection Properties panel.
  • Add the ability to import and export server definitions from a config database.

Download your copy here.

2018-11-01 - pgAdmin 4 v3.5 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.5. This release of pgAdmin 4 includes over 11 bug fixes and new features. For more details please see the release notes here.

Note: This is the first release of pgAdmin on a new monthly release cycle.

Notable changes in this release include:

  • Migrate from Bootstrap 3 to Bootstrap 4.
  • Save the treeview state periodically, and restore it automatically when reconnecting.
  • Support to stop the utility processes (Backup/Restore/Maintenance...).

Download your copy here.

2018-10-04 - pgAdmin 4 v3.4 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.4. This release of pgAdmin 4 includes over 11 bug fixes and new features. For more details please see the release notes here.

Note: This is the first release of pgAdmin on a new monthly release cycle.

Notable changes in this release include:

  • Add shortcuts for View Data and the Query tool to the Browser header bar.
  • Add optional data point markers and mouse-over tooltips to display values on graphs.
  • Ensure the runtime can startup properly if there are wide characters in the account/user name on Windows.

Download your copy here.

2018-09-06 - pgAdmin 4 v3.3 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.3. This release of pgAdmin 4 includes over 21 bug fixes and new features. For more details please see the release notes here.

Note: This is the first release of pgAdmin on a new monthly release cycle.

Notable changes in this release include:

  • Add a geometry viewer that can render PostGIS data on a blank canvas or various map sources.

Download your copy here.

2018-08-09 - pgAdmin 4 v3.2 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.2. This release of pgAdmin 4 includes over 20 bug fixes and new features. For more details please see the release notes here.

Note: This is the first release of pgAdmin on a new monthly release cycle.

Notable changes in this release include:

  • Add a cache busting mechanism to prevent issues following upgrades.
  • Add support for SCRAM password changes (require psycopg2 2.8).
  • Allow save password to be reset.
  • Introduce real time preference handling in Query Tool, Debugger and Dashboards.
  • SSH Tunneling fixes.

Download your copy here.

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]

2018-06-28 - pgAdmin 4 v3.1 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.1. This release of pgAdmin 4 includes over 30 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Add support for SSH tunneled connections.
  • Various fixes for handling data in SQL_ASCII databases.
  • Add support for LISTEN/NOTIFY in the Query Tool.
  • Function/Procedure support for PostgreSQL 11.
  • Various fixes and enhancements to the Greenplum support.

Download your copy here.

2018-04-13 - pgAdmin 4 v3.0 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.0. This release of pgAdmin 4 includes over 100 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • The desktop runtime now runs as a system tray application and utilises the browser on the system to display pgAdmin. This resolves numerous bugs and issues caused by QtWebKit/QtWebEngine.
  • Data can now be sorted in edit mode in the Query Tool.
  • Keyboard navigation with configurable shortcuts for many operations has been added to allow use of pgAdmin without a mouse.
  • Dashboard tables and charts can be enabled/disabled.
  • Server and database statistics, functions, partitions, external tables and EXPLAIN are now supported on Greenplum.
  • Support for pg_service.conf files has been added.
  • The Docker Container distribution is vastly slimmed down, having move to Alpine Linux with Gunicorn to host the pgAdmin web application.

Download your copy here.

2018-01-11 - pgAdmin 4 v2.1 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 2.1. This release of pgAdmin 4 includes nearly 90 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Support for colouring connections in the treeview and query tool
  • Configurable formatting for CSV and clipboard datasets
  • Editing of table data for tables with OIDs but no primary keys
  • Immediately retrieve default column values when saving new/edited rows in the query tool

We've also added a new distribution in the form of a Docker Container. See the Docker Hub repo for more information.

Download your copy of pgAdmin here.

2017-10-05 - pgAdmin 4 v2.0 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 2.0. This release of pgAdmin 4 includes over 70 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • PostgreSQL and EDB Advanced Server 10 support
  • An updated icon set and embedded fonts for consistent look and feel on all platforms
  • Significant speed enhancements, particularly at startup time
  • Out-of-the-box ability to run in either server or desktop mode with no additional configuration changes required
  • Support for SSL certificate based authentication
  • Detailed display of server status info on the dashboards, with options to cancel queries and terminate sessions

Download your copy here.

2017-07-13 - pgAdmin 4 v1.6 released

The pgAdmin Development Team are pleased to announce the release of pgAdmin 4 version 1.6. This release of pgAdmin 4 includes over 70 bug fixes and a dozen new features. For details, please see the release notes.

Notable changes in this release include:

  • Significant performance improvements on Windows, massively reducing initial load time and improving UI response for the vast majority of users during testing.
  • Enhancements to the Query Tool enabling the viewing of large query resultsets far more quickly. For example, a simple test query with 96K rows rendered results within 1 second vs. 22 seconds in pgAdmin III during testing!
  • A major rewrite of the Query History tab allows browsing of queries executed in the query tool with full details including the entire query, in a much nicer user interface.
  • The Desktop Runtime now supports detachable tabs, allowing the Query Tool and Debugger to be opened in new tabs and then moved to alternate displays (from 1.5 this was possible in web mode only)
  • The Query Tool's Results Grid has been overhauled with a new, sleek look an feel supporting selection of arbitrary rows, columns or blocks of cells with full copy support and column sizing retention.
  • The Dashboard tab can now be closed if desired, to minimise query traffic resulting from graph updates.

For more information, checkout the online documentation, the screenshots, and of course the download page.

2017-05-19 - pgAdmin 4 v1.5 released

The pgAdmin Development Team are pleased to announce the release of pgAdmin 4 version 1.5. This release of pgAdmin 4 includes over 20 bug fixes and improvements. For details, please see the issue tracker roadmap.

For more information, checkout the online documentation, the screenshots, and of course the download page.

2017-04-13 - pgAdmin 4 v1.4 released

The pgAdmin Development Team are pleased to announce the release of pgAdmin 4 version 1.4. This release of pgAdmin 4 includes over 30 bug fixes and improvements. For details, please see the issue tracker roadmap.

For more information, checkout the online documentation, the screenshots, and of course the download page.

2017-03-10 - pgAdmin 4 v1.3 released

The pgAdmin Development Team are pleased to announce the release of pgAdmin 4 version 1.3. This is the third release of pgAdmin 4, and includes over 30 bug fixes and improvements. For details, please see the issue tracker roadmap.

For more information, checkout the online documentation, the screenshots, and of course the download page.

2016-09-29 - pgAdmin 4 v1.0 released

After over 10,000 hours of development work, pgAdmin 4 v1.0 is finally available for download! Visit the download page to get your copy, or download the PostgreSQL 9.6 installers from EDB.

pgAdmin 4 is a complete rewrite of pgAdmin, built using Python and Javascript/jQuery. A desktop runtime written in C++ with Qt allows it to run standalone for individual users, or the web application code may be deployed directly on a webserver for use by one or more users through their web browser. The software has the look and feel of a desktop application whatever the runtime environment is, and vastly improves on pgAdmin III with updated user interface elements, multi-user/web deployment options, dashboards and a more modern design.

For more information, checkout the online documentation, the screenshots, and of course the download page.