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> <CA+hUKGLKmmTm0Ea_tJz_mkdvQPF_759SqA0sRB1OEwAQZHUGxQ@mail.gmail.com>
 <80036B55-2935-4F22-9151-5661F5AA04A7@arcict.com>
In-Reply-To: <80036B55-2935-4F22-9151-5661F5AA04A7@arcict.com>
From: Thomas Munro <thomas.munro@gmail.com>
Date: Thu, 4 Apr 2024 09:56:12 +1300
Message-ID: <CA+hUKG+26V_KNkyqngzVtndf4fa1P3gCmko4V7YJYspL39BGnA@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%2BhUKG%2B26V_KNkyqngzVtndf4fa1P3gCmko4V7YJYspL39BGnA%40mail.gmail.com>
Precedence: bulk

On Thu, Apr 4, 2024 at 3:11=E2=80=AFAM Nick Renders <postgres@arcict.com> w=
rote:
> In the macOS Finder, when you show the Info (command+i) for an external d=
rive (or any partition that is not the boot drive), there is a checkbox "Ig=
nore ownership on this volume" in the Permissions section. I think it is by=
 default "on" for external drives.

Hmm.  Sounds suspicious, but why would only this file be affected?

> The external SSD is an Orico drive that is connected with USB-C. It is in=
itialised as a GUID Partition Map with a single AFPS partition.
>
> We have run PostgreSQL 15 and earlier, before upgrading to 16 when it cam=
e out last year. We didn't have any problems with 16 until recently, after =
upgrading to Sonoma.

Interesting.  So the rename might have something to do with it, though
I don't have a theory for how,.

Can you show what the permissions and ownership looks like for pg_*
under there, normally, and once the system reaches this state?
Something like:

tmunro@phonebox postgresql % ls -slap pgdata/global/pg_*
16 -rw-------  1 tmunro  staff  8192  4 Apr 09:50 pgdata/global/pg_control
 8 -rw-------  1 tmunro  staff   524  4 Apr 09:50 pgdata/global/pg_filenode=
.map

I'm asking for "pg_*" because I want to see pg_control as well, to
understand the permissions for the other files in the cluster, and
because I want to see if there are any stray remnants of a temporary
file, which would be called pg_filenode.map.tmp.