pgAdmin 4

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

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

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

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

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

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

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

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

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

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]