Permission warning accessing pg_stat_tmp/global.stat on macOS

[fantix]

Start an instance on macOS with data persistence:

$ docker run --rm  -e EDGEDB_SERVER_PASSWORD=xxx   -e EDGEDB_SERVER_TLS_CERT_MODE=generate_self_signed   -v /path/to/data:/var/lib/edgedb/data edgedb/edgedb

Wait for a couple of minutes and logs will have something like this:

WARNING 164 2022-08-19T16:08:48.114 postgres: could not open statistics file "pg_stat_tmp/global.stat": Operation not permitted

This is mostly docker-library/postgres#878 and initially reported here for EdgeDB.

It would be nice if we could redefine the tmp dir to workaround this warning.