Customize location of runtime dir

[jannyware-inc]

I'm running into an issue where pgserver fails to start for unprivileged users on RHEL 9. Upon server setup it will fail with PermissionError: [Errno 13]: Permission denied: b'/run/user/0/python_PostgresServer'. I believe this is due to platformdirs incorrectly resolving a directory and not the fault of pgserver. I can workaround by running under my user $ export XDG_RUNTIME_DIR=/home/admin, but I would like to eliminate the need for this, possibly by using the 'env' parameter of subprocess.run() which spawns the PG server.

[jannyware-inc]

or perhaps instead of customizing it, it could be hard-coded into the pg_data directory of the server?

[jannyware-inc]

Realized this normally happens when using su w/out updating environment dirs to the su'd user. A workaround is to set XDG_RUNTIME_DIR environ var in the python program before creating the postgres server.