Want to see your pgAdmin video here? Email webmaster@pgadmin.org.
Latest Blog Posts
Customising your pgAdmin 4 workspace - Part 1: Browser
Author: Anil Sahoo, date: Aug. 24, 2023
If you are reading this then you are probably using pgAdmin as a tool to help in your day to day database management activities with PostgreSQL. But, did you know there are a variety of ways you can maximise your productivity by customising the pgAdmin workspace using the Preferences dialog’s various options? This article will show you some of the options for customising the workspace using the Browser node of the Preferences tree control.
pgAdmin User Management in Server Mode
Author: Aditya Toshniwal, date: Aug. 24, 2023
pgAdmin can be deployed as a web application by configuring the app to run in server mode. One can check out server deployment on how to run pgAdmin in server mode. In this blog, we will discuss how to manage the pgAdmin users when running in server mode.
pgAdmin CI/CD
Author: Dave Page, date: Aug. 24, 2023
Almost exactly three years ago I wrote a blog on my personal page entitled Testing pgAdmin which went into great detail discussing how we test pgAdmin prior to releases. Back then, all of the automated testing was performed using Jenkins, with a number of jobs that ran various test suites whenever new code was checked in. All of this infrastructure ran in a virtual private cloud on AWS consisting of a large number of virtual machines and other resources, hosted for the project by EDB. I recently undertook a project to move the testing infrastructure to our Github project, using Github Actions.
Want to see your pgAdmin blog post here? Email webmaster@pgadmin.org.
News
2024-11-14 - pgAdmin 4 v8.13 Released
The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.13. 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:
- Replace infinite scrolling with pagination in query tool data output for better UX and performance.
- Add an object menu option to disconnect all server and database connections.
- Alternate the background color of rows to enhance readability.
- Allow to pass PGADMIN_CONFIG_CONFIG_DATABASE_URI from docker secrets.
- Format dashboard graph metrics for better readability.
- Added support for auto-detecting and setting the End-of-line character (LF/CRLF) in the query tool editor.
- Make the background color for the serial number and header cells distinct.
Bugs/Housekeeping:
- Updated the react-menu library from v2 to v4.
- Fixed an issue that allowed the Enter key to save data in the result grid text editor.
- Move 'About pgAdmin 4' to the app menu on macOS.
- Fixed an issue where the query tool was crashing when an empty geometry was being rendered.
- Fixed an issue where the Dashboard tab showed 'Something went wrong'.
- Fixed an issue where cursor selection is not visible in the PSQL tool.
- Allow OAuth2 params OAUTH2_NAME, OAUTH2_DISPLAY_NAME, OAUTH2_ICON, OAUTH2_BUTTON_COLOR to be optional.
- Add appropriate minimum width and height settings for desktop apps to avoid apps accidentally going below visibility levels.
- Fixed an issue where the graphical explain kept the node details open even after the plan changed.
- Fixed an issue in the debugger where the character data type function arguments were being truncated.
- Fixed an issue that allowed the Enter key to save data in the result grid text editor.
Download your copy now!
2024-09-23 - pgAdmin 4 v8.12 Released
The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.12. 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 feature to restore preferences to their default values.
- Add a new config variable - ALLOW_SPECIAL_EMAIL_DOMAINS to allow special domains for pgAdmin user emails.
- Allow running non-continuous selected SQL code blocks in the query tool.
Bugs/Housekeeping:
- Fixed a security issue where the OAuth2 client ID and secret were exposed through the web browser (CVE-2024-9014).
- Improved the extensibility of the SchemaView and DataGridView.
- Fix the query tool restore connection issue on the server disconnection from the left side object explorer.
- Revamp the current password saving implementation to a keyring and reduce repeated OS user password prompts.
- Fixed an issue where users could not use pgAdmin if they did not have access to the management database.
- Fixed an issue where servers listed in the servers.json file were being reimported upon container restart.
- Added support for OIDC based OAuth2 authentication.
- Fixed an issue where the cursor moves to the end of the line when editing input fields.
- Fixed an issue where different client backend shows all SQL are same.
- Fixed an issue where "Quit App" confirmation modal in desktop app is not respecting "Confirm on close or refresh?"
Download your copy now!
2024-08-22 - pgAdmin 4 v8.11 Released
The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.11. This release of pgAdmin 4 includes 15 bug fixes and new features. For more details please see the release notes.
Notable changes in this release include:
Features:
- Add a home button to the geometry viewer to set the original zoom level when the viewer is opened.
Bugs/Housekeeping:
- Fixed an issue where refreshing the Schema Diff tool opened in a new tab caused an error.
- Fix server heartbeat logging error after deleting the server.
- Fixed an issue where the Generate Script ignored filter conditions when a parent node was selected.
- Fixed an issue where delete object(shortcut key) affected both text and Object Explorer items.
- Fix an issue where the ERD tool should be able to open saved pgerd file when using keyboard shortcuts.
- Fixed an issue where the REVOKE statement in the create script was throwing an error if the role contained special characters.
- Improve code highlighting in the query editor.
- Fix an issue where the wheel package is not getting installed on the arm64-based macOS version < 14.
- Fixed an issue where column resizing is not working in the search objects dialog
- Fixed an issue where the value in the find box is not updating with selected text in the editor if the find is already open and re-triggered.
Download your copy now!
The current version of pgAdmin 4 is 8.13
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.