Heads-up: macOS Big Sur upgrade breaks EDB PostgreSQL installations

Поиск
Список
Период
Сортировка
От Dave Page
Тема Heads-up: macOS Big Sur upgrade breaks EDB PostgreSQL installations
Дата
Msg-id CA+OCxoy5+Qk6WPJ926gUVs0wym5aSSUrjOKtkQCEJXsArAN5hA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Heads-up: macOS Big Sur upgrade breaks EDB PostgreSQL installations
Re: Heads-up: macOS Big Sur upgrade breaks EDB PostgreSQL installations
Список pgsql-hackers
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.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Masahiro Ikeda
Дата:
Сообщение: Re: Add statistics to pg_stat_wal view for wal related parameter tuning
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Delay of standby shutdown