Re: could not open file "global/pg_filenode.map": Operation not permitted - Mailing list pgsql-general

From Nick Renders
Subject Re: could not open file "global/pg_filenode.map": Operation not permitted
Date
Msg-id 80036B55-2935-4F22-9151-5661F5AA04A7@arcict.com
Whole thread Raw
In response to Re: could not open file "global/pg_filenode.map": Operation not permitted  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: could not open file "global/pg_filenode.map": Operation not permitted
List pgsql-general
On 29 Mar 2024, at 4:25, Thomas Munro wrote:
>
> 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=postgresql.git;a=commitdiff;h=d8cd0c6c95c0120168df93aae095df4e0682a08a
>
> Did you ever run 15 or earlier on that system?


In the macOS Finder, when you show the Info (command+i) for an external drive (or any partition that is not the boot
drive),there is a checkbox "Ignore ownership on this volume" in the Permissions section. I think it is by default "on"
forexternal drives. 

The external SSD is an Orico drive that is connected with USB-C. It is initialised as a GUID Partition Map with a
singleAFPS partition. 

We have run PostgreSQL 15 and earlier, before upgrading to 16 when it came out last year. We didn't have any problems
with16 until recently, after upgrading to Sonoma. 


Nick



pgsql-general by date:

Previous
From: M Tarkeshwar Rao
Date:
Subject: [MASSMAIL]Query regarding new version of shared library with older binary
Next
From: sud
Date:
Subject: Re: Timestamp conversion Error in dynamic sql script