OpenTelemetry Support
Does pgadmin support opentelemetry logging, for both gunicorn access logs and app logs? I didn't see anything like that in the app config example. Thanks, Wade
Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
Hi all, Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied The rest of the pgadmin4 application is working like normal.. I can run any sql queries without problems, just cannot load or save any files! What did I do/remember: 1) recently updated postgresql to 17.5 on manjaro rolling release. 2) I remember that I went to the root of the storage when it started to act weird. Not sure this is connected though 3) When I try opening any file stored in the storage, I'm getting ... "Request failed with status code 500" ... error in the application but I cannot find *anywhere* in the logs an indication of what is happening (Also not in my postgresql, supervisor, nginx or journalctl logs). 4) I updated pgadmin4 from 9.6 to 9.8 like I always do (pip install -U pgadmin4) to see if this would fix it but the problem persists. 5) ...I changed CONSOLE_LOG_LEVEL = 10 in the hope to see more but alas... 6) ...I enabled postgresql log to see something comes up there, but no postgresql seems quietly doing it's thing.. 7) I checked the ... STORAGE_DIR = "/data/databases/pgadmin4/storage" ... and all is owned by the pgadmin user. 8) Via the command line I can add/delete/remove files/directories in the storage folder and I will see them in the storage (manager) but still unable to open or save any file. 9) BUT when I create a new sql script and try to save it or "save as" I am getting an "Access denied" message : "Successfully run. Total query runtime: 311 msec. 14603 rows affected. Access denied (/new script.sql)Access denied (/new_file.sql)Access denied (/two.new.sql)" (The message keeps appending my last attempts, btw) Did anybody else had this problem before? ... and know how to fix it? ... or knows a way to track down the 500 error of the app. or is this git issue material? Cheers, Bastiaan
pgAdmin 4 v9.9 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.9. This release of pgAdmin 4 includes 10 bug fixes and new features. For more details, please see the release notes at: https://www.pgadmin.org/docs/pgadmin4/9.9/release_notes_9_9.html pgAdmin is the leading open-source graphical management tool for PostgreSQL. For more information, please see: https://www.pgadmin.org/ Notable changes in this release include: Features: - Add support of DEPENDS/NO DEPENDS ON EXTENSION for ALTER FUNCTION. - Added "MULTIRANGE_TYPE_NAME" option while creating a Range Type. - Added "SUBSCRIPT" option while creating an External Type. - Added option to skip the password dialog when using an identity file. - Added 'failover' and 'two_phase' parameter support in CREATE/ALTER SUBSCRIPTION for PostgreSQL v17+. - Add support for initializing the pgAdmin4 Kubernetes Helm chart. Bugs/Housekeeping: - Fixed an issue where the query tool displayed 'default' instead of 'null' for null text data in the data output. - Fixed an issue where the pgAdmin configuration database wasn't being created on a fresh install when an external database was used for the configuration. - Fixed an issue where shortcuts are not working as expected on multiple keyboard layouts. - Fixed an issue where saving the newly changed preferences was not reflecting on the preferences tab. Builds for Windows and macOS are available now, along with a Python Wheel, Docker Container, RPM, DEB Package, and source code tarball from: https://www.pgadmin.org/download/ -- Akshay Joshi pgAdmin Project
Password exec troubleshooting
Hello pgadmin-support Long-time user, first time emailing. I’m trying to use the Password exec feature to fetch a secret from AWS Secrets Manager. I’ve created both a python script and then a sh script and neither work. Oddly nothing about password exec is reported in logs. I just get the error below. pgAdmin 4 v 9.7 as desktop app python 3.13.7 macOS 15.7.1 Things I’ve tried: Executing either script from the command line works as expected and returns just the password string. scripts have chmod +x for all users. I’ve provided the full path to script in the Password exec entry Tried quoting and escaping command line. The shell script uses aws cli and full path is provided in script. Moved the script to the ~/Library/Application Support/pgAdmin 4 in case macOS disk access issues were in play. Error: connection failed: connection to server at “10.x.x.x", port 5432 failed: could not initiate GSSAPI security context: Unspecified GSS failure. Minor code may provide more information: Cannot find KDC for realm "KERBEROS.MICROSOFTONLINE.COM" connection to server at “10.x.x.x", port 5432 failed: fe_sendauth: no password supplied From what I can parse of source code, I don’t think the ENABLE_SERVER_PASS_EXEC_CMD comes into play as I’m not operating in server mode. Does anyone have examples of a config that works? Any advice on how I can debug further? Thanks for any pointers!
