On 11/16/20 4:27 AM, Dave Page wrote: > Hi, > > This is more of a head-ups than anything else, as I suspect this may > come up in various forums. > > The PostgreSQL installers for macOS (from EDB, possibly others too) > create the data directory in /Library/PostgreSQL/<major_ver>/data. This > has been the case since the first release, 10+ years ago. > > It looks like the Big Sur upgrade has taken it upon itself to "fix" any > filesystem permissions it doesn't like. On my system, this resulted in > the data directory having 0755 permissions, which meant that PostgreSQL > refused to start. Manually changing the permissions back to 0700 (0750 > should also work) fixes the issue. > > I'm not sure there's much we can do about this - systems that are likely > to be affected are already out there, and we obviously don't want to > relax the permissions Postgres requires.
Thanks for raising this. We should provide some guidance on upgrading this when upgrading to Big Sur.
Do we know where the other macOS installers place their data directories? We should reach out to the installer maintainers to see if they are seeing the same behavior so we know what guidance to issue.
I believe postgres.app only installs for the current user, and puts it's data under ~/Library/Application Support/Postgres.
