- Getting Started
- External database for pgAdmin user settings
- Connecting To A Server
- Managing Cluster Objects
- Managing Database Objects
- Creating or Modifying a Table
- Management Basics
- Backup and Restore
- Developer Tools
- pgAdmin Project Contributions
- Release Notes
- Version 6.21
- Version 6.20
- Version 6.19
- Version 6.18
- Version 6.17
- Version 6.16
- Version 6.15
- Version 6.14
- Version 6.13
- Version 6.12
- Version 6.11
- Version 6.10
- Version 6.9
- Version 6.8
- Version 6.7
- Version 6.6
- Version 6.5
- Version 6.4
- Version 6.3
- Version 6.2
- Version 6.1
- Version 6.0
- Version 5.7
- Version 5.6
- Version 5.5
- Version 5.4
- Version 5.3
- Version 5.2
- Version 5.1
- Version 5.0
- Version 4.30
- Version 4.29
- Version 4.28
- Version 4.27
- Version 4.26
- Version 4.25
- Version 4.24
- Version 4.23
- Version 4.22
- Version 4.21
- Version 4.20
- Version 4.19
- Version 4.18
- Version 4.17
- Version 4.16
- Version 4.15
- Version 4.14
- Version 4.13
- Version 4.12
- Version 4.11
- Version 4.10
- Version 4.9
- Version 4.8
- Version 4.7
- Version 4.6
- Version 4.5
- Version 4.4
- Version 4.3
- Version 4.2
- Version 4.1
- Version 4.0
- Version 3.6
- Version 3.5
- Version 3.4
- Version 3.3
- Version 3.2
- Version 3.1
- Version 3.0
- Version 2.1
- Version 2.0
- Version 1.6
- Version 1.5
- Version 1.4
- Version 1.3
- Version 1.2
- Version 1.1
- Version 1.0
Release date: 2019-12-12
This release contains a number of bug fixes and new features since the release of pgAdmin4 4.15.
Warning: This release includes a change to the container distribution to run pgAdmin as a non-root user. Those users of the container who are running with mapped storage directories may need to change the ownership on the host machine, for example:
sudo chown -R 5050:5050 <host_directory>
Issue #4396 - Warn the user on changing the definition of Materialized View about the loss of data and its dependent objects.
Issue #4435 - Allow drag and drop functionality for all the nodes under the database node, excluding collection nodes.
Issue #4711 - Use a ‘play’ icon for the Execute Query button in the Query Tool for greater consistency with other applications.
Issue #4772 - Added aria-label to provide an invisible label where a visible label cannot be used.
Issue #4773 - Added role=”status” attribute to all the status messages for accessibility.
Issue #4939 - Run pgAdmin in the container as a non-root user (pgadmin, UID: 5050)
Issue #4944 - Allow Gunicorn logs in the container to be directed to a file specified through GUNICORN_ACCESS_LOGFILE.
Issue #4990 - Changed the open query tool and data filter icons.
Issue #4696 - Add Reverse Engineered and Modified SQL tests for Materialized Views.
Issue #4807 - Refactored code of table and it’s child nodes.
Issue #4938 - Refactored code of columns node.
Issue #3538 - Fix issue where the Reset button does not get enabled till all the mandatory fields are provided in the dialog.
Issue #4220 - Fix scrolling issue in ‘Users’ dialog.
Issue #4516 - Remove the sorting of table headers with no labels.
Issue #4659 - Updated documentation for default privileges to clarify more on the grantor.
Issue #4674 - Fix query tool launch error if user name contains HTML characters. It’s a regression.
Issue #4724 - Fix network disconnect issue while establishing the connection via SSH Tunnel and it impossible to expand the Servers node.
Issue #4761 - Fix an issue where the wrong type is displayed when changing the datatype from timestamp with time zone to timestamp without time zone.
Issue #4792 - Ensure that the superuser should be able to create database, as the superuser overrides all the access restrictions.
Issue #4818 - Fix server connection drops out issue in query tool.
Issue #4836 - Updated the json file name from ‘servers.json’ to ‘pgadmin4/servers.json’ in the container deployment section of the documentation.
Issue #4878 - Ensure that the superuser should be able to create role, as the superuser overrides all the access restrictions.
Issue #4893 - Fix reverse engineering SQL issue for partitions when specifying digits as comments.
Issue #4923 - Enhance the logic to change the label from ‘Delete/Drop’ to ‘Remove’ for the server and server group node.
Issue #4925 - Shown some text on process watcher till the initial logs are loaded.
Issue #4926 - Fix VPN network disconnect issue where pgAdmin4 hangs on expanding the Servers node.
Issue #4930 - Fix main window tab navigation accessibility issue.
Issue #4933 - Ensure that the Servers collection node should expand independently of server connections.
Issue #4934 - Fix the help button link on the User Management dialog.
Issue #4935 - Fix accessibility issues.
Issue #4947 - Fix XSS issue in explain and explain analyze for table and type which contain HTML.
Issue #4952 - Fix an issue of retrieving properties for Compound Triggers. It’s a regression of #4006.
Issue #4953 - Fix an issue where pgAdmin4 unable to retrieve table node if the trigger is already disabled and the user clicks on Enable All.
Issue #4958 - Fix reverse engineering SQL issue for triggers when passed a single argument to trigger function.
Issue #4964 - Fix an issue where length and precision are not removed from table/column dialog.
Issue #4965 - Fix an issue where the Interval data type is not displayed in the properties dialog of table/column.
Issue #4966 - Fix ‘Could not find the object on the server.’ error while refreshing the check constraint.
Issue #4975 - Fix issue where the user can not switch the UI language. It’s a regression of #4348.
Issue #4976 - Fix reverse engineering SQL issue where when clause is not visible for PG/EPAS 12.
Issue #4978 - Fix pgAdmin4 failed to start issue after upgrading to version 4.15.
Issue #4982 - Added statistics and storage information in reverse engineering SQL of table/column.
Issue #4985 - Fix an issue where the inherited table name with quotes did not escape correctly.
Issue #4991 - Fix an issue where context menu is open along with submenu and the focus is not on context menu or submenu.