pgAdmin 4

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.2. This release of pgAdmin 4 includes 24 bug fixes and new features. For more details please see the release notes. Note: From this release onwards pgAdmin 4 will now use the ... [More] operating system's password store to save the server passwords in desktop mode instead of using Master Password. Notable changes in this release include: Features: Add Option to only show active connections on Dashboard. Allow pgAdmin to retrieve master password from external script/program. Add an option to hide/show empty object collection nodes. Added support to use standard OS secret store to save server/ssh tunnel passwords instead of master password in pgAdmin desktop mode. Implement new PostgreSQL 15 features in publication dialog and SQL. Bugs/Housekeeping: Fixed an issue where Foreign Key columns are shown in the wrong order in SQL and Properties. Ensure that a new row should be added on top in the User Management dialog. Fixed an issue where REVOKE ALL DDL in table SQL was added only for one role. Tools menu should be toggled for "pause replay of wal" and "resume replay of wal". Make the 'Connect to server' dialog a modal dialog. Fixed an issue where PSQL tool prompts for password if using password exec command. Fix circular reference error for the multirange data types in the query tool. Fix an issue in the register server when setting the role, an arbitrary SQL query can be fired. View SQL tab not quoting column comments. VarChar Field Sizes are missing from Query's Grid header. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.1. This release of pgAdmin 4 includes 23 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Show ... [More] object breadcrumbs path along with its comment on object hover. Allow on demand record count setting to be changed per user using preferences. Added support to show statistics for materialized views. Added support to create an unnamed index. Bugs/Housekeeping: Mac crash when you press Command-Shift-C. Fixed an issue where Reset Password is not working after upgrading to latest flask-security-too. Ensure that the ERD tool should work with the external database after moving to psycopg3. Fixed an issue with the properties tab not getting updated if the user updates the selected node. Fix an issue in View SQL when column level privileges are set with multiple roles. Fixed an issue where query tool hangs for some time when multiple columns are selected to open geometry viewer. Ensure that when pasting a row in query tool grid, default value is used for autogenerated/serial columns. Ensure to quote the primary key value if needed while deleting rows from the table. Fixed an issue where PSQL is not working if the PGUSER env variable is set and service file is used for server connection details. Show proper message if the debugger is stopped by the user. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 7.0. This release of pgAdmin 4 includes 43 bug fixes and new features. For more details please see the release notes. Note: To upgrade on RHEL 8, Rocky Linux 8, Fedora 36, and ... [More] Fedora 37 users have to manually remove the “python3-mod_wsgi” package. While removing the “python3-mod_wsgi” package, it removes all the dependencies, and pgadmin 4 is one of the dependencies. Notable changes in this release include: Features: Auto expand row edit form when a new row is added for Primary Key, Foreign Key, Unique Constraint, and Exclusion Constraint. Added support for mounting shared storage in server mode. Add a note on top of keyboard shortcuts preferences to show the Accesskey of the browser. Added capability to deploy PostgreSQL servers on Google Cloud. Added support of BigAnimal v3 API. On pressing Ctrl+C on a tree object, copy the fully qualified name to the clipboard. Added option to create unique constraint with nulls not distinct. Bugs/Housekeeping: Upgrade from psycopg2 to psycopg3, Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions, and Remove Bootstrap and jQuery usage. Fixed the LDAP authentication issue for the simultaneous login attempts. (CVE-2023-1907). Show appropriate error message when master password is not set instead of 'Crypt key missing'. Ensure that the user's storage directory is created when the users are created, as well as for those users whose directories have not yet been created. Fixed an issue where migration on an external database is not working. Fixed CSV export from Query Tool results does not include all columns for multiple CTEs. Fixed 'rawunicodeescape' codec can't decode issue in an SQL_ASCII database. Use fetch instead of Axios to close connections in SQLEditor, ERD, Schema Diff, and Debugger to ensure it completes. Ensure that when pasting rows the rows are added right below the selected rows for copying. Fix the dependents SQL of Roles which is throwing a type casting error on PostgreSQL 15 Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.21. This release of pgAdmin 4 includes 19 bug fixes and new features. For more details please see the release notes. Note: This is the last release of pgAdmin that will support ... [More] Python 3.6 and Psycopg2. Future releases will require Python 3.7 or later. This means that this is also the last release that will be supported on CentOS and RHEL 7.x Notable changes in this release include: Features: Allow changing cardinality notation in ERD to use Chen notation. Add additional logging for successful logins and user creation. Bugs/Housekeeping: Fixed an issue where pgAdmin failed to connect when the Postgres password included special characters. Ensure that the database migration does not fail with a NoSuchTableError exception. Fixed an issue where the database server is not connected using a service file. Handle MERGE operation in query tool explain introduced in PostgreSQL 15. Ensure that the schema diff tool should pick up the change in the column grants. Ensure that Grant column permission to a view is visible in the SQL tab. Ensure that content on the DDL comparison panel should get refreshed on selecting the object using the up and down arrow keys. Fixed an issue where the user can't create trigger AFTER UPDATE OF. Do not allow to save invalid JSON in query tool JSON editor. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.20. This release of pgAdmin 4 includes 18 bug fixes and new features. For more details please see the release notes. Note: Whilst pgAdmin 4 does not formally support downgrading ... [More] , it typically does work if you uninstall and then reinstall the application. This release of pgAdmin includes a major change to the configuration database structure which is NOT backward compatible, and therefore a straightforward downgrade will not work. If you are using the default SQLite database for your configuration (as will be the case for the vast majority of users), the old version of the configuration database will be backed up to "pgadmin4.db.prev.bak" in your storage directory. If you wish to downgrade to pgAdmin v6.19 or earlier, after running v6.20, you must restore this file to "pgadmin4.db" in the same directory, BEFORE starting the older version of pgAdmin again. If you are storing your configuration in an external PostgreSQL database, you will need to restore a backup of that database taken prior to the upgrade to v6.20, if you wish to return to the earlier version. Changes made after migration such as the addition of new servers, will not be stored in the old database and will have to be re-created following a downgrade. Notable changes in this release include: Features: Added support for setting PostgreSQL connection parameters. With the help of this feature, a user can specify the connection parameters when connecting to a server using the server dialog. In the server dialog, we have added a new Parameters tab and removed the SSL tab. The Parameters tab now contains all SSL tab controls. Bugs/Housekeeping: Use uplot for Dashboard graphs to reduce CPU usage. Fixed an issue where the client cert location was not stored on the shared servers. Fix orphan database connections resulting in an inability to connect to databases. Ensure that the system columns should not visible in the import/export data. Increase the length of the value column of the setting table. Fix an issue where drag and drop object names are not working. Fix an issue where the role is used as a username for newly added servers when opening the query tool. Fixed an issue where Query history is not getting loaded with the external database. Fix failing import servers CLI due to vulnerability fix Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.19. 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: Added ... [More] support of AWS provider for BigAnimal cloud deployment. Bugs/Housekeeping: Ensure that the authenticated users can't access each other's directories and files by providing relative paths. (CVE-2023-0241). Allow YouTube video demo links to be added to appropriate pgAdmin documentation. Fixed an issue where an incorrect password was used with the shared server. Ensure the browser tree does not freeze while rendering 10k+ nodes/objects. Fixed an issue where the default value of string for columns should wrap in quotes in the create script. Fix the webserver and internal authentication setup issue. Ensure the appbundle has correct permissions so that pgAdmin can be accessed by users other than the owner. Fixed a missing "jwks_uri" in metadata error that occurred when logging in with an oAuth2 provider like Azure or Google. Fixed an issue where the Geometry viewer does not show the popup when columns are less than 3. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.18. This release of pgAdmin 4 includes 13 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Added ... [More] native menu support in desktop mode. This feature converts the top-level menu to a native menu using NWjs. As a result, it uses the look and feel of the platform that it runs on when in Desktop mode. Enhancements to the ERD when selecting a relationship. Bugs/Housekeeping: Fixed an issue where Transaction IDs were not found in session in the Query Tool. Fixed an issue where tablespace was missing on partition tables in SQL. Fixed an issue where properties tab was refreshing on tab change even if the selected node is same. Fixed an issue with auto-complete not working as expected with double quotes. Ensure that table statistics are sorted by size. Fixed an issue while updating server node info removes the clear saved password menu. Fixed an issue where master password was not set correctly with external config database. Fixed an error in the collation create script for PG-15. Fixed BigAnimal authentication aborted issue. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.17. This release of pgAdmin 4 includes 10 bug fixes and new features. For more details please see the release notes. Security Release Please note that this release includes a ... [More] security update to ensure only authorized and authenticated users can validate binary paths when using pgAdmin running in server mode. Users running pgAdmin in server mode should upgrade to this release as soon as possible. This issue does not affect users running in desktop mode. Notable changes in this release include: Bugs/Housekeeping: Ensure that only authorized and authenticated users can validate binary paths (CVE-2022-4223). Update the BigAnimal API version to V2. Remove all traces of Backbone and Underscore. Fixed an issue where the wrong schema is displayed for a foreign key in the schema diff tool. Ensure that the query history date format in Desktop mode matches the format of the locale of the pgadmin server. Fixed an issue where the CSV file would not download if the CSV quote character length exceeded 1. Ensure that DATA_DIR dependent folders/files are automatically created inside the specified DATA_DIR if they are not specified separately in the configuration file. Fixed an issue where the editor position was wrong when editing data from the result grid. Ensure the query tool is launched successfully for the servers registered with the PostgreSQL service. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.16. 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 for storing configurations of pgAdmin in an external database. Use the external database server to save the pgAdmin 4 user settings in situations where SQLite is not preferred. It is useful when adding HA support for the configuration database or to avoid using SQLite on non-ephemeral storage. Added the ability to generate ERDs for tables. Add the possibility to configure the Oauth2 claim which is used for the pgAdmin username. Bugs/Housekeeping: Fixed an issue where the screen was freezing while closing the wcDocker panel. Ensure that autocomplete works properly with objects starting with double quotes. Ensure that pgAdmin routes should have the SCRIPT_NAME prefix. Ensure that the appropriate permissions are set on the key file before trying an SSL connection with the server in server mode. Fixed an issue where the result grid was not working properly while trying to edit data by hitting Enter key. Fixed an issue where AutoComplete was not working correctly due to incorrect regex. Fixed an issue where the 'Confirm on close or refresh' setting was ignored when closing the query/ERD tool opened in the new tab. Fixed an issue where pgadmin does not respect reverse proxy anymore. Ensure that the load file paths are children of the storage directory. Use the shared server username when opening the query tool. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.15. This release of pgAdmin 4 includes 35 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Added ... [More] support for IAM token based authentication for AWS RDS or Azure DB. By using this feature, database connection starts with token-based authentication for AWS RDS or Azure DB. To achieve this we have added a password command option. Added support to specify the background fill color to the table nodes in the ERD tool. Allow reordering table columns using drag and drop in ERD Tool. Add option to generate SQL with DROP table DDL in ERD Tool. Added high availability options to AWS deployment. Expose the Gunicorn limit_request_line parameter in the container, with the default set to the maximum of 8190. Bugs/Housekeeping: Fixed an exception that occurs while taking backup and SSL certificates/keys are not found in the specified path. Ensure that the path to the psqlrc file is correct when multiple users open the PSQL tool at the same time. Ensure that the query tool creates a new tab with the appropriate user when pressing Alt+Shift+Q. Added the close button for all the notifications of the notistack. Ensure that the scroll position should be preserved for the result set in the query tool on tab change. Fixed an issue where the prompt is not visible when clicking on the 'save results to file' button on the large data. Fixed error occurring while LDAP authentication for a user with multiple email attributes. Fixed the cross-site scripting vulnerability. Ensure that the login form is hidden if the authentication source is OAuth2 or Kerberos. Fixed an issue where the password recovery link was not working. Download your copy now! [Read News] [Less]