pgAdmin 4

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.3. This release of pgAdmin 4 includes 16 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Allow ... [More] drag-n-drop column’s collection tree node as comma-separated columns. Added support to rename columns in Views. Added BYPASSRLS|NOBYPASSRLS option while creating a Role. Added support for column storage syntax while creating table. Use COOKIE_DEFAULT_PATH or SCRIPT_NAME in the session cookie path. Added configurable parameter to enable support for PasswordExecCommand in server mode. Bugs/Housekeeping: Fixed an issue where format SQL was messing up the operator. Included many other feature changes. Fixed an issue where formatting inserts empty lines in specific cases. Add support for selecting a schema in the backup database dialog with no tables, mviews, views, or foreign tables. Fixed a UI border issue on the dependencies tab for columns with icons. Fixed an issue where multiple errors were showing if the user did not have connect privileges. Fixed an issue where group membership information was displayed incorrectly. Ensure that the correct SQL is generated when changing the column data type to "char". Fixed an issue pgAdmin fails to launch due to inconsistent PATH variable name on windows. Fix a backend server error when creating a named restore point. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.2. 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: Administer ... [More] pgAdmin Users and Preferences Using the Command Line Interface (CLI). Allow users to convert the View/Edit table into a Query tool to enable editing the SQL generated. Added copy server support, allowing the duplication of existing servers with the option to make certain modifications. Added keep-alive support for SSH sessions when connecting to a PostgreSQL server via an SSH tunnel. Bugs/Housekeeping: Fixed an issue where the query tool title did not change after "Save As" until any new change was made. Fixed an issue where export servers were not adding extensions if not specified. Fixed an issue where pgAdmin imports servers to the wrong accounts for the external authentication. Fixed an issue where an error occurred in the SQL tab when using an extended index(pgroonga). Fixed an issue where DB Restrictions were not visible on the server dialog. Ensure that the 'Dbo' schema is displayed as a regular schema rather than a system catalog schema. Introduce LDAP configuration parameter LDAP_IGNORE_MALFORMED_SCHEMA to ignore fetching schema from the LDAP server. Fixed an issue where Schema Diff not generating difference for missing columns. Fixed an error ''amname' when generating ERD for the database containing partition tables. Fixed an issue where the user is not able to cancel or terminate active queries from the dashboard. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.1. This release of pgAdmin 4 includes 21 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Add ... [More] support for generating ERD for a schema. Add support for creating a function with a custom return type. Bugs/Housekeeping: Fixed several accessibility-related issues for enhanced usability. Ensure that indexes created by constraints are visible in the object explorer when "Show system objects" is enabled. Provide a way to bypass the SSL cert verification for OAuth2 provider. Fixed an issue where reading process logs throws an error when DATA_DIR is moved to a networked drive. Remove the 'Close Window' submenu specifically for OSX to prevent unintended closure of the entire application. Fixed an issue where syntax error was not highlighted in the query tool. Reverse engineer serial columns when generating ERD for database/table. Fixed an issue where the Schema was not visible in the dropdown for table properties or when creating a new table. Ensure that the correct timezone is set for Docker deployments. Fixed an issue where all rows and filter rows buttons of the object explorer toolbar were disabled for views and other supported nodes. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.0. This release of pgAdmin 4 includes 29 bug fixes and new features. For more details please see the release notes. Note: This is a new major version of pgAdmin 4. In this ... [More] upgraded version, we've incorporated updates to essential components such as Flask, Werkzeug, and various other modules. Notably, the default installation path for Windows operating systems has changed, and the version folder has been eliminated. Consequently, users are advised to perform a manual uninstallation of the previous version for a seamless transition to the new release. Notable changes in this release include: Features: Replace the current layout library wcDocker with ReactJS based rc-dock. Changes in the context menu on panel tabs - Add close, close all and close others menu items. Allow closing all the tabs, including SQL and Properties. Have close buttons on individual panel tabs instead of common. Bugs/Housekeeping: Upgrade Flask, Werkzeug and other modules depends on the latest version of Flask. Add DROP SQL for foreign keys in SQL generated by ERD when using WITH DROP option. Fixed an issue where psql was not taking the role used to connect in server properties. Fixed an issue where Geometry Viewer renders geometry incorrectly after trying to view 3D or non-4326 SRID geometry. Fix an issue where the default server-group is being deleted if the load-server json file contains no servers. Fixed an issue where Schema Diff does not work when the user language is set to any language other than English in Preferences. Fix an issue where OAUTH_ADDITIONAL_CLAIMS does not recognise AzureAD with > 150 groups. Fix an issue where import/export data is not working for shared servers. Fix a crash issue occurring when debugging a function with arguments when using pgAdmin with external config database. Fixed an issue where the change server password is not working in desktop mode. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.8. This release of pgAdmin 4 includes 21 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: GUI ... [More] representation of the system's activity using the 'system_stats' extension This feature is used to see the GUI representation of the system's activity using the 'system_stats' extension. Added a new tab 'System Statistics' under the Dashboard tab. This new tab contains the details about CPU, Memory, and Storage. Add support for foreign table's new functionality for PG 11 and above. Allow setting custom username for shared servers, with default as username of server being shared. Add 'GENERATED ALWAYS AS..' option while creating column constraints for Foreign Table Added 'load_balance_hosts' connection string parameter for PG 16 and above. Bugs/Housekeeping: Fixed an issue in ERD tool where the downloaded images have a few links cut. Fixed an issue where user was not able to assign new/old columns as primary key once column with primary key is deleted. Add support for setting prepare threshold in server connection. Fix an issue where global/native keyboard shortcuts are not working when any cell of data output grid has focus. Fixed query history slowness issue by storing query only for those having certain threshold max length. Ensure that the backup works properly for PG 16 on the latest docker image. Fixed an issue where non-super PostgreSQL users are not able to terminate their own connections from dashboard. Fix an issue where scale in columns is not allowed to have value as 0 or below. Fix an issue in graphical explain plan where query tool crashes when the plan has parallel workers details and sort node is clicked for details. Fix an issue where user login is not working if username/email contains single quote in server mode. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.7. 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 ... [More] support to select/deselect objects in the Backup dialog. Added all the new options of the 'WITH' clause in the subscription dialog. Added USING method while creating the table Added compression method option while creating a column. Added Strategy, Locale Provider, ICU Locale, ICU Rules, and OID options while creating a database. Added USING method while creating the materialized view. Add support for additional ID token claim checks for OAuth 2 authentication. Bugs/Housekeeping: Added the 'data type' column in the properties tab of the Columns collection node. Fix an issue where user is not able to change the password when SMTP is not configured. Ensure user is redirected to login page after failed login. Ensure that Materialized view size fields in "Statistics" should be human-readable. Fix an issue where changing the password shows success but the new password is not working. Fix an issue where login form doesn't appear if internal auth source is removed. Fix a security related issue where an authenticated user can run remote command using validate binary path API (CVE-2023-5002). Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.6. 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 the ... [More] 'Ignore Grants' and 'Ignore Tablespace' options in the schema diff tool. Ensure that Schema Diff comparison results should be displayed in the sorted order. Added new/missing options to the VACUUM command Added support for SYSTEM, CONCURRENTLY, and TABLESPACE options in REINDEX. Added Expression to CREATE INDEX. Added cascade option while creating an extension. Added support for ALTER INDEX column statistics. Added unlogged option while creating a sequence. Added all like options while creating a table. Added WAL option to EXPLAIN ANALYZE command. Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command. Add support for TRUNCATE trigger in the foreign table. Bugs/Housekeeping: Generate software bill of materials as part of the package builds. Added support for PostgreSQL and EPAS 16 to ensure it works without any errors. Allow changing the POOL_SIZE and MAX_OVERFLOW config values of the pgAdmin config DB connection pool. Fix incorrect redirection URL after authentication by removing fixed value set to SCRIPT_NAME environment variable in pgAdmin4.wsgi file. Fix an issue where query tool on shared server is throwing error if the pgAdmin config DB is external. Fix the issue where query tool window turns blank if the user tries to generate a graph on the result. Fix an issue where changing MFA_SUPPORTED_METHODS breaks the MFA validation. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.5. 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: Features: Added ... [More] support to detach partitions using concurrently and finalize. Added all supported index storage parameters while creating an index. Added new/missing parameters to pg_dump, pg_dumpall and pg_restore. Bugs/Housekeeping: Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS. Fix an issue where queries longer than 1 minute get stuck. Fix an issue where queries can't complete execution. Fix an issue where queries get stuck with auto-completion enabled. Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used. Fixed an issue where pgAdmin failed to setup role with hyphens in name. Fixed an issue where filters are not working and query history shows empty queries. Fix an issue where adding a sub-folder inside a folder is not working as expected in File Manager. Fix an issue where inserting more than 10 rows does not work correctly in View Data; only parts end up in the table. Ensure user gets proper error if incorrect credentials are entered while authenticating AWS. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.4. This release of pgAdmin 4 includes 16 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Added ... [More] support to drop databases using the 'WITH (FORCE)' option. Add '[ NULLS [ NOT ] DISTINCT ]' option while creating an Index. Added 'OR REPLACE' clause while creating a trigger. Added security_invoker option while creating a view. Bugs/Housekeeping: Fix an issue where the object explorer tree crashes occasionally. Ensure that query tool shortcuts are working properly. Add Password exec command and Expiration time to server export JSON and also allow them to import. When opening pgAdmin the layout should be auto-reset if it is corrupted. Reset layout menu should work if the layout is corrupted while using pgAdmin. Fixed an issue where queries with temporary tables in the same transaction are not working. Fix raise notice from func/proc or code blocks are no longer displayed live. Fix an issue where PSQL is not working if the database name has quotes or double quotes. Fix an encoding error when connecting through Pgbouncer. Fix an issue where explain plan details are showing HTML escaped characters. Fixed an issue where preview images for themes were not loading. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.3. This release of pgAdmin 4 includes 5 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Bugs/Housekeeping: ... [More] Ensure that SSH Tunnel should work properly after upgrading to 7.2 from 7.1. Ensure that the master password dialog should not be visible if the parameter MASTER_PASSWORD_REQUIRED is set to False. Fixed an issue where Foreign Key with 3 or more columns are shown in the wrong order in SQL and Properties. Fix an issue where editing a database object de-selects it on the browser tree. Fixed an issue where pgadmin is unable to take the defined role. Download your copy now! [Read News] [Less]