| From: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
|---|---|
| To: | Nick Renders <postgres(at)arcict(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: could not open file "global/pg_filenode.map": Operation not permitted |
| Date: | 2024-03-29 03:25:01 |
| Message-ID: | CA+hUKGLKmmTm0Ea_tJz_mkdvQPF_759SqA0sRB1OEwAQZHUGxQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Mar 29, 2024 at 4:47 AM Nick Renders <postgres(at)arcict(dot)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 the other) has the option "ignore ownership" on by default. I have tried disabling that, and updating the data directory to have owner + read/write access for the postgres user. It seemed to work at first, but just now the issue 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:
Did you ever run 15 or earlier on that system?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Farber | 2024-03-29 19:53:08 | Please recommend postgresql.conf improvements for osm2pgsql loading Europe |
| Previous Message | 黄宁 | 2024-03-29 01:28:36 | how to check if the license is expired. |