Also check the permission of /data/databases/pgadmin4/<USER> directory.
On Sat, Oct 11, 2025 at 3:41 PM Bastiaan Wakkie <bwakkie@gmail.com> wrote:
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.
