Hi Bastiaan, Can you share pgAdmin logs (whatever it has)? Also check the permission of /data/databases/pgadmin4/<USER> directory.
On Sat, Oct 11, 2025 at 3:41 PM Bastiaan Wakkie <[email protected]> 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. > > > or is this git issue material? > > Cheers, > > Bastiaan > > > > -- Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com* <https://www.enterprisedb.com/> "Don't Complain about Heat, Plant a TREE"
