From: Nick Renders <postgres@arcict.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: could not open file "global/pg_filenode.map": Operation not
 permitted
Date: Fri, 22 Mar 2024 15:01:04 +0100
Message-ID: <76FAACAC-F64A-43DA-BDBF-340A40C47045@arcict.com>
In-Reply-To: <ZfGPfsckcxYLtagw@tamriel.snowman.net>
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>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/76FAACAC-F64A-43DA-BDBF-340A40C47045%40arcict.com>
Precedence: bulk

On 13 Mar 2024, at 12:35, Stephen Frost wrote:

> Greetings,
>
> * Nick Renders (postgres@arcict.com) wrote:
>>> ...run them under different users on the system.
>>
>> Are you referring to the "postgres" user / role? Does that also mean s=
etting up 2 postgres installation directories?
>
> Yes, two separate MacOS user accounts is what I was suggesting.  You
> could use the same postgres binaries though, no need to have two
> installation of them.  You'd need seperate data directories, of course,=

> as you have currently.
>
>> This script runs on a daily basis at 4:30 AM. It did so this morning a=
nd there was no issue with cluster B. So even though the issue is most li=
kely related to the script, it does not cause it every time.
>
> Seems likely that it's some sort of race condition.
>
> Thanks,
>
> Stephen

We now have a second machine with this issue: it is an Intel Mac mini run=
ning macOS Sonoma (14.4) and PostgreSQL 16.2.
This one only has a single Data directory, so there are no multiple insta=
nces running.

I installed Postgres yesterday and restored a copy from our live database=
 in the Data directory. The Postgres process started up without problems,=
 but after 40 minutes it started throwing the same errors in the log:

	2024-03-21 11:49:27.410 CET [1655] FATAL:  could not open file "global/p=
g_filenode.map": Operation not permitted
	2024-03-21 11:49:46.955 CET [1760] FATAL:  could not open file "global/p=
g_filenode.map": Operation not permitted
	2024-03-21 11:50:07.398 CET [965] LOG:  could not open file "postmaster.=
pid": Operation not permitted; continuing anyway

I stopped and started the process, and it continued working again until a=
round 21:20, when the issue popped up again. I wasn't doing anything on t=
he machine at that time, so I have no idea what might have triggered it.

Is there perhaps some feature that I can enable that logs which processes=
 use these 2 files?

Thanks,

Nick Renders