News Archive

2021-09-09 - pgAdmin 4 v5.7 Released

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

Notable changes in this release include:

Features:

  • Added support for the truncate table with restart identity.
  • Added database and server information on the Maintenance process watcher dialog..
  • Allow the referenced table to be the same as the local table in one to many relationship for ERD Tool..
  • Make closing tabs to be smarter by focusing on the appropriate tab when the user closed a tab..
  • Set PSQLRC and PSQL_HISTORY env vars to apt. user storage path in the server mode..

Bugs/Housekeeping:

  • Fixed blank screen issue on windows and also made changes to use NWjs manifest for remembering window size.
  • Ensure that trigger function SQL should have 'create or replace function' instead of 'create function' only.
  • Fixed the export image issue where relation lines are over the nodes.
  • Fixed width limitation issue in PSQL tool window.
  • Fixed an issue where columns with sequences get altered unnecessarily with a schema diff tool.
  • Ensure that the lock panel should not be blocked for larger records.
  • Fixed an issue where whitespace in function bodies was not applied while generating the script using Schema Diff.
  • Introduced the OAUTH2_SCOPE variable for the Oauth2 scope configuration.
  • Enables pgAdmin to retrieve user permissions in case of nested roles, which helps to terminate the session for AWS RDS.
  • Ensure that pgAdmin should not fail at login due to a special character in the hostname.

Download your copy now!

2021-08-12 - pgAdmin 4 v5.6 Released

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

Notable changes in this release include:

Features:

  • Added support to copy SQL from main window to query tool.
  • This feature is used to copy the SQL script for the selected browser tree node in the query tool. For this we have added new preferences setting ‘Copy SQL from main window to query tool?’

  • Added support for formatted JSON viewer/editor when interacting with data in a JSON column.
  • This feature allows the user to format, view and edit JSON data in a very nice way. JSON editors have so many formats to view data differently.

Bugs/Housekeeping:

  • Rename the "Resize by data?" to "Columns sized by" and disabled the 'Maximum column width' button if 'Columns sized by' is set to 'Column data'.
  • Ensure that the login account should be locked after N number of attempts. N is configurable using the 'MAX_LOGIN_ATTEMPTS' parameter.
  • Fixed CSRF errors for stale sessions by increasing the session expiration time for desktop mode.
  • Fixed an issue in the search object when searching in 'all types' or 'subscription' if the user doesn't have access to the subscription.
  • Fixed an issue where paste was not working through the Right-Click option on PSQL.
  • Fixed TypeError 'NoneType' object is not sub scriptable.
  • Fixed an issue where the titles in query tabs are different.
  • Fixed dashboard server activity issue when active_since parameter is None.

Download your copy now!

2021-07-15 - pgAdmin 4 v5.5 Released

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

Features:

  • Highlighted long running queries on the dashboards
  • This feature is implemented to highlight the long running queries. It allows the user to provide the warning and alert threshold values in minutes. Depending on the threshold value pgAdmin4 highlights the long running queries on the Dashboard.

  • Added support for Reassign/Drop Owned for login roles.
  • This feature allows the user to change the ownership of database objects owned by a database role or remove database objects owned by a database role.

  • Added support for OAuth 2 authentication
  • This feature allows the user to connect to the pgAdmin 4 server using OAuth2 authentication. To enable OAUTH2 authentication for pgAdmin, you must configure the OAUTH2 settings in the config_local.py or config_system.py file.

  • Added option to provide maximum width of the column when 'Resize by data?’ option in the preferences is set to True
  • Do not block the query editor window when running a query

Bugs/Housekeeping:

  • Ensure that the Data Output panel can be snapped back after it is detached.
  • Fixed replace keyboard shortcut issue in the query tool on the normal keyboard layout.
  • Remove leading whitespace and replace it with '[...] ' in the Query Tool data grid so cells don't look empty.
  • Fixed an issue in the search object when searching in 'all types' or 'subscription' if the user doesn't have access to the subscription.
  • Fixed an issue where the New Connection Drop Down has lost default maintenance database, auto-select, and tab-through functionality..
  • Ensure that setting 'Open in new browser tab' should be visible, it should not be based on the value of 'ENABLE_PSQL'.
  • Disable email deliverability check that was introduced in flask-security-too by default to maintain backwards compatibility.
  • Fixed an issue where incorrect column names were listed in the properties of Index.

Download your copy now!

2021-06-17 - pgAdmin 4 v5.4 Released

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

Notable changes in this release include:

Features:

  • PSQL Tool support (Beta)
  • The PSQL tool allows users to connect to PostgreSQL or EDB Advanced server using the psql command-line interface through their browser. Open the PSQL tool from the Tools or browser tree context menu, or use the PSQL tool button at the top of the browser tree. On the Windows platform, this feature is available on Windows 10 (1809 version), and Windows Server 2019 and onwards.

  • Added support to browse binary path and set it for the different database server version.
  • This feature allows the user to set the different binary paths for the supported database server versions. Added browse button to select the binary path along with validation button to validate the path. Validation checks for the utilities and shows the version of the utilities.

  • Rotating the pgAdmin log files on the basis of size and age
  • Using this feature the user will be able to set the log rotation on the basis of size and age. Added configuration parameters LOG_ROTATION_SIZE and LOG_ROTATION_AGE.

  • Window maximize/restore functionality for properties dialog
  • This feature allows the user to maximize and restore the properties dialog.

  • Support non-admin installation on Windows

Bugs/Housekeeping:

  • Updated Flask-Security-Too to the latest v4.
  • Added a mechanism to detect a corrupt/broken config database file.
  • Fixed the issue of renaming the database by another user.
  • Disable browser password saving in the runtime.
  • Ensure that the Query Tool connection string should not be changed as per the 'Query Tool tab title'.
  • Fixed duplicate SQL issue for tables with more than one partition.
  • Fixed an issue where the Foreground Color property of server dialog does not work.
  • Fixed an issue where a decimal number is appended for character varying fields while downloading the data in CSV format.

Download your copy now!

2021-05-20 - pgAdmin 4 v5.3 Released

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

Notable changes in this release include:

Features:

  • Connect PostgreSQL servers using Kerberos authentication
  • This feature provides the user to connect to the database servers using Kerberos authentication. Make sure 'kerberos' must be set as AUTHENTICATION_SOURCES in the config file. Added ‘Kerberos authentication?’ switch control in the server dialog if it is set to True then the user can connect to the database server using Kerberos authentication.

  • Auto width of columns by content size in the data output window.
  • This feature provides the user to set the auto width option of the columns by content size. Added ‘Resize by data?’ option in the preferences. If set to True then data columns will auto-size to the maximum width of the data in the column as loaded in the first batch. If False, the column will be sized to the widest of the data type or column name.

Bugs/Housekeeping:

  • Fixed an issue where data is displayed in the wrong order when executing the query repeatedly.
  • Fixed an issue where the wrong SQL is showing for the child partition tables.
  • Fixed an issue where CSV download quotes the numeric columns.
  • Ensure that pgAdmin should not allow opening external files that are dragged into it.
  • Fixed an issue where schema diff does not create DROP DEFAULT statement for columns.
  • Fixed an issue where the filter 'Include/Exclude By Selection' not working for null values.
  • Added support for the creation of Nested Table and Varying Array Type for Advanced Server.
  • Fixed ModuleNotFoundError when running setup.py from outside of the root.
  • Fixed an issue where the current debug line is not visible in the 'Dark' theme.
  • Fixed an issue where duplicate columns are visible in the browser tree if dependent on multiple sequences.
  • Ensure that pgAdmin4 shut down completely on the Quit command.

Download your copy now!

2021-04-22 - pgAdmin 4 v5.2 Released

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

Notable changes in this release include:

Bugs/Housekeeping:

  • Ensure that the query tool tab should be closed after server disconnection when auto-commit/auto-rollback is set to false.
  • Fixed flickering issue of the input box on check constraints.
  • Corrected the syntax for 'CREATE TRIGGER', use 'EXECUTE FUNCTION' instead of 'EXECUTE PROCEDURE' from v11 onwards.
  • Ensure that the strings in the LDAP auth module are translatable.
  • Ensure that while comparing domains check function dependencies should be considered in schema diff.
  • Added missing dependency 'xdg-utils' for the desktop packages in RPM and Debian.
  • Fixed cannot unpack non-iterable response object error when selecting any partition.
  • Mark the Apache HTTPD config file as such in the web DEB and RPM packages.
  • Fixed an issue where users are unable to see data of the partitions using the View/Edit data option.
  • Fixed an issue where foreign data wrapper properties are not visible if the host option contains two host addresses.
  • Fixed an issue where a connection warning should be displayed on the user clicks on explain or explain analyze and the database server is disconnected from the browser tree.

Download your copy now!

2021-03-25 - pgAdmin 4 v5.1 Released

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

Notable changes in this release include:

Features:

  • Zoom scaling options with keyboard shortcuts in runtime:
  • This feature includes the zoom scaling (Zoom In, Zoom Out, Actual Size) options along with Enter/Exit Full Screen mode. We have added the options in Menu as well as using keyboard shortcuts users can perform the desired operation.

  • Show the login roles that are members of a group role be shown when examining a group role.
  • Added '--replace' option in Import server to replace the list of servers with the newly imported one.
  • Make the container distribution a multi-arch build with x86_64 and Arm64 support.
  • Make 'kerberos' an optional feature in the Python wheel, to avoid the need to install MIT Kerberos on the system by default.

Bugs/Housekeeping:

  • Fixed an issue where hanging symlinks in a directory caused the select file dialog to break.
  • Make the 'Save Data Changes' icon to be more intuitive.
  • Ensure that cell content being auto selected when editing the cell data.
  • Ensure that SQL formatter should not add extra tabs and format the SQL correctly.
  • Ensure that SQL formatter should not use tab size if 'Use spaces?' set to false.
  • Fixed encoding issue when database encoding set to SQL_ASCII and name of the column is in ASCII character.
  • Ensure that the user should be able to kill the session from Dashboard if the user has a 'pg_signal_backend' role.
  • Ensure PGADMIN_DEFAULT_EMAIL looks sane when initialising a container deployment.
  • Fixed an issue where the user is not able to change the connection in Query Tool when any SQL file is opened.
  • Fixed an issue where copy/paste rows in view data paste the wrong value for boolean type.
  • Ensure that toggle buttons are accessible by most screen readers.

Download your copy now!

2021-02-25 - pgAdmin 4 v5.0 Released

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

Notable changes in this release include:

Features:

  • New Desktop Runtime (Using NWjs):
  • The Desktop Runtime is now based on NWjs which integrates a browser and the Python server creating a standalone application. By implementing it using NWjs we get rid of the separate server application and the independent browser. We also get rid of QT and C++ runtime logic.

    There are two minor known issues with this feature (6255 and 6258), both of which are due to bugs in NWjs itself; Users on macOS should use the application menu to exit pgAdmin, rather than quitting from the Dock icon to avoid the first issue. The second issue may cause Windows users to see a red square instead of the normal application icon in some circumstances.

  • Logical Replication support:
  • Logical replication uses a publish and subscribe model with one or more subscribers subscribing to one or more publications on a publisher node. We have added support for logical replication by introducing new treeview nodes and dialogues with which users can easily create/alter/delete publications and subscriptions. Support is also included in the Schema Diff tool.

  • Quick Search functionality:
  • Added a quick search option in the Help menu to search menu items and help articles. Type at least three characters to display all the matching possibilities under Menu items and the relevant documents under Help articles.

  • Make Statistics, Dependencies, Dependants tabs closable. Users can add them back using the 'Add panel' option on the context menu for the tab strip.
  • When running in Docker/Kubernetes, ensure logs are not stored in the container, and only sent to the console.

Bugs/Housekeeping:

  • Use cheroot as the default production server for pgAdmin4.
  • Updated Javascript dependencies to the latest versions.
  • Fixed an issue where the focus is not properly set on the filter text editor after closing the error dialog.
  • Fixed an issue where the dependencies tab shows multiple owners for the objects having shared dependencies.
  • Fixed an issue where the Zoom to fit button in the ERD Tool only works if the diagram is larger than the canvas.
  • Fixed an issue where the user was unable to change the background color for a server.
  • Fixed an issue where external utility jobs (backup, maintenance etc.) are failing when the log level is set to DEBUG.
  • Ensure DEB/RPM packages depend on the same version of each other.
  • Fixed an autocomplete issue where it is not showing any suggestions if the schema name contains escape characters.

Download your copy now!

2021-01-28 - pgAdmin 4 v4.30 Released

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

Notable changes in this release include:

Features:

  • ERD Tool (Beta):
  • The Entity-Relationship Diagram (ERD) tool is a database design tool that provides a graphical representation of database tables, columns, and inter-relationships. You can use the ERD tool to design a new schema and generate the SQL required to create it, or to reverse engineer and diagram an existing database schema.

  • Kerberos Support:
  • Kerberos support is added in pgAdmin 4 using SPNEGO for logging into pgAdmin, similar to the existing LDAP and "internal" options. Note that support for logging into database servers using Kerberos is not included in this release, but will be added in a future version.

  • Add a container option (PGADMIN_DISABLE_POSTFIX) to disable the Postfix server:
  • Postfix (like other MTAs) must start as user 'root', and the pgAdmin container achieves this using 'sudo'. Whilst that works well in most environments, it can cause problems in some. This option allows you to completely disable Postfix to avoid these issues, though you will need to configure an external mail server to be used to send password reset emails.

Bugs/Housekeeping:

  • Improve the explain plan details by showing a popup instead of a tooltip when clicking on plan nodes.
  • Ensure that verbose logs are visible for Utility (Backup, Maintenance etc.) jobs.
  • Added support for expressions in exclusion constraints.
  • Ensure that the 'template1' database is not visible after pg_upgrade.
  • Added appropriate help message and a placeholder for letting users know about the account password expiry for Login/Group Role.
  • Updated Flask-BabelEx to the latest version.
  • Fixed extra parentheses issue around joins for Views.
  • Ensure that the current value of sequences is ignored while comparing using Schema Diff.
  • Fixed an issue when the user tries to delete multiple records in the data grid.
  • Fixed TypeError exception in schema diff when selecting two identical objects.
  • Include PostgreSQL 13 utilities in the container distribution.

Download your copy now!

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.