@Jesse_b I'm wondering about
this edit you made. I think the double-quotes would expand $HOME to the
current user, putting that value into /etc/paths.d/postgresapp for
everyone. I would think the desired result would be the literal value
$HOME
to be in the global file, so that it's correctly (presumably) expanded to the user that's logging in.