Is there a way I can make it so the postgres user on my os has permission to run files owned by other users
The only permission needed is to read the file, and traverse the directory tree to get to the file. These can be set with
make it so I can run psql from my linux user account rather than having to switch to the postgres user?
There are many options. If your current pg_hba local setting is just
local all all peer, then add a new database superuser which is named the same as your linux account name. Or Change pg_hba.conf so you are using
scram-sha-256, or something fancier), rather than
peer. Or keep using
peer, but provide a user map and edit pg_ident.conf to allow your linux user to connect.
CLICK HERE to find out more related problems solutions.