pgAdmin 4

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 ... [More] 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! [Read News] [Less]

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 ... [More] 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! [Read News] [Less]

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 ... [More] 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! [Read News] [Less]

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 ... [More] 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! [Read News] [Less]

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. Note: We are pleased to announce a number of new packaging ... [More] options for pgAdmin with this release. Note that as these packages are all new, they have only been tested by the pgAdmin development team and its possible issues may be found in general use. We will aim to resolve any issues reported as quickly as possible. Please report any issues , making sure you include any error messages and details of the platform you're running on. Windows 64 bit Windows users can now choose to use a new 64-bit build of pgAdmin. This is being published alongside the 32-bit build which will be discontinued in a future release. If you already have the 32-bit build of pgAdmin installed on Windows, you must uninstall it before installing the 64-bit build. Linux Packages We now have pre-built native packages for popular RPM and DEB based platforms. These are all built in a consistent way and are designed to avoid the dependency issues are seen with other Linux packages in the past. RHEL/CentOS/Fedora Yum repositories can be found on the PostgreSQL download site. Follow the instructions on that page to setup the required repository and install pgAdmin 4 in desktop or server mode. Supported platforms: RHEL/CentOS 7 & 8 (x86_64) Fedora 30, 31 & 32 (x86_64) Debian/Ubuntu Apt repositories can be found on the PostgreSQL download site. Follow the instructions on that page to setup the required repository and install pgAdmin 4 in desktop or server mode. Supported platforms: Debian 9 (Stretch), 10 (Buster) Ubuntu 16.04 (Xenial), 18.04 (Bionic), 19.04 (Disco), 19.10 (Eoan), 20.04 (Focal) PyPi Following the last release of pgAdmin, v4.22 was published to the Python package index (PyPi). This will continue with future releases, enabling users of Python 3.4 and later to install quickly and easily. Please see the Python download page for more information: 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! [Read News] [Less]

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 ... [More] 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! [Read News] [Less]

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. Note: The next release of pgAdmin (expected to be ... [More] v4.22) will not support running under Python 2.7. This will only affect users running the Python wheel package under Python 2.7 or those running from their own source code build. 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! [Read News] [Less]

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 ... [More] 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. [Read News] [Less]

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 ... [More] 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. [Read News] [Less]

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 ... [More] 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. [Read News] [Less]