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
2023-09-21 - pgAdmin 4 v7.7 Released
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 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!
2023-08-24 - pgAdmin 4 v7.6 Released
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 '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!
2023-07-27 - pgAdmin 4 v7.5 Released
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 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!
2023-06-29 - pgAdmin 4 v7.4 Released
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 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!
2023-06-06 - pgAdmin 4 v7.3 Released
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:
- 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!
2022-09-21 - Project moved to GitHub
The pgAdmin Project has now moved to GitHub!
The source code repository can be found at: https://github.com/pgadmin-org/pgadmin4.
Issues can be found at https://github.com/pgadmin-org/pgadmin4/issues. All issues have been migrated from the old Redmine trackers.
There are a number of other repositories also in our GitHub organisation for pgAgent, the website, and old versions of pgAdmin.
Please update your links and bookmarks accordingly!
2022-07-11 - pgAdmin User Survey
In order to help us better plan the future of pgAdmin, it's essential that we hear from users so we can focus our efforts in the areas that matter most.
We'd like to gather feedback from as many users as possible, so please take a few minutes and complete the survey below. Feel free to share the link with any friends or colleagues who you think may also want to provide their input.
https://forms.gle/62gzUPNbj4N1jNTB6
Please note that the survey is entirely anonymous (although Google will see your IP address, and may know who you are if you are logged in to your Google account), unless you choose to include any identifying information in any of your responses.
Thank you!
2018-07-12 - pgAgent v4.0.0 Released
The pgAdmin Development Team are pleased to announce the release of pgAgent v4.0.0.
pgAgent is a job scheduler for PostgreSQL; for more information please see the documentation included as part of the pgAdmin documentation at https://www.pgadmin.org/docs/pgadmin4/3.x/pgagent.html.
Download (source): https://www.pgadmin.org/download/pgagent-source-code/
We expect DEB and RPM packages to be available from the PostgreSQL APT/YUM repositories in due course, as well as an updated installer from EnterpriseDB available through StackBuilder.
Notable changes in this release include:
- Remove the dependency on wxWidgets. pgAgent now uses Boost for thread management and synchronisation [Neel Patel]
- Refactor connection parsing logic to fix issues with and improve handling of connection strings [Thomas Krennwallner]
- Handle 2 digit server version numbers [Ashesh Vashi]
- Fix handling of the "succeeded" flag on job steps which could prevent failure of steps causing the following steps to fail [Sanket Mehta]
The current version of pgAdmin 4 is 7.7
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.