Some sort of permissions issue on Big Sur is preventing the agents from having permission to run the backup and optimize shell scripts
sethgoldin opened this issue · 5 comments
When running the .sh scripts manually, not through the LaunchAgent, I see:
pg_dump: [custom archiver] could not open output file "/Users/testuser/Desktop//test1_2021_03_10_11_24.backup": Permission denied
Giving Terminal Full Disk Access doesn't resolve the issue.
This is on macOS Big Sur 11.2.2.
The .backup file that gets generated is 0 bytes, and the logs aren't getting touched.
I believe this is related to some new security measures in Big Sur: PostgresApp/PostgresApp#610
However the DaVinci Resolve Project Server 17.1 app is indeed able to backup and optimize successfully, according to its GUI.
This apparently works after giving permissions to ~/Documents, ~/Desktop, and ~/Downloads.
Right now this script calls the tools inside of the /Library/PostgreSQL/9.5/pgAdmin3.app/Contents/SharedSupport, and while I suppose I could recommend giving "full disk access" to the particular binaries, it's probably better just to give the tools read and write access just to whatever directory is being used. It's not immediately clear to me how to do this from the macOS GUI, but I'll poke around.
One other option might be to use the binaries out of /Library/PostgreSQL/9.5/bin, instead of /Library/PostgreSQL/9.5/pgAdmin3.app/Contents/SharedSupport, but I'm not sure if these are the same.
Can't really replicate this on macOS Ventura now, when testing version 2.0 of the tools for PostgreSQL 13 for Resolve 18. But also, we're using the binaries in /Library/PostgreSQL/13/bin/, and not the ones buried inside the pgAdmin app now.
So just going to close this out. Won't fix this.
Thinking this must be related to this: #31