MIME-Version: 1.0
References: <4D67E594-098F-4234-87D8-68F827AF2531@arcict.com>
 <d947712004aa39633639bd5a23d6a6d6b6b2665a.camel@cybertec.at>
 <2E2F11F8-718A-4E6A-81E0-4F5CC1F1273A@arcict.com> <a08f7e54-0a6f-466b-b3fc-08165076c605@aklaver.com>
 <19556056-40E7-4FA3-A2A1-0A345AEBFD9E@arcict.com> <ZfGPfsckcxYLtagw@tamriel.snowman.net>
 <76FAACAC-F64A-43DA-BDBF-340A40C47045@arcict.com> <CAF-3MvOKqiKbcG-1M=ZeW-O99PeUJ0THPm8DWrRKcTT263GtAg@mail.gmail.com>
 <B610FFEA-18C3-40BD-8751-87685B204C2F@arcict.com>
In-Reply-To: <B610FFEA-18C3-40BD-8751-87685B204C2F@arcict.com>
From: Thomas Munro <thomas.munro@gmail.com>
Date: Fri, 29 Mar 2024 16:25:01 +1300
Message-ID: <CA+hUKGLKmmTm0Ea_tJz_mkdvQPF_759SqA0sRB1OEwAQZHUGxQ@mail.gmail.com>
Subject: Re: could not open file "global/pg_filenode.map": Operation not permitted
To: Nick Renders <postgres@arcict.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BhUKGLKmmTm0Ea_tJz_mkdvQPF_759SqA0sRB1OEwAQZHUGxQ%40mail.gmail.com>
Precedence: bulk

On Fri, Mar 29, 2024 at 4:47=E2=80=AFAM Nick Renders <postgres@arcict.com> =
wrote:
> Looking at the 2 machines that are having this issue (and the others that=
 don't), I think it is somehow related to the following setup:
> - macOS Sonoma (14.4 and 14.4.1)
> - data directory on an external drive
>
> That external drive (a Promise RAID system in one case, a simple SSD in t=
he other) has the option "ignore ownership" on by default. I have tried dis=
abling that, and updating the data directory to have owner + read/write acc=
ess for the postgres user. It seemed to work at first, but just now the iss=
ue re-appeared again.
>
> Any other suggestions?

I don't have any specific ideas and I have no idea what "ignore
ownership" means ... what kind of filesystem is running on it?  For
the simple SSD, is it directly connected, running a normal Apple APFS
filesystem, or something more complicated?

I wonder if this could be related to the change in 16 which started to
rename that file:

https://git.postgresql.org/gitweb/?p=3Dpostgresql.git;a=3Dcommitdiff;h=3Dd8=
cd0c6c95c0120168df93aae095df4e0682a08a

Did you ever run 15 or earlier on that system?