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>
In-Reply-To: <76FAACAC-F64A-43DA-BDBF-340A40C47045@arcict.com>
From: Thomas Munro <thomas.munro@gmail.com>
Date: Thu, 4 Apr 2024 10:14:33 +1300
Message-ID: <CA+hUKGLKbx+zjqthDp1YS=uiWB9PJ2p56BGx+iYUB3LmPN8p5Q@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%2BhUKGLKbx%2BzjqthDp1YS%3DuiWB9PJ2p56BGx%2BiYUB3LmPN8p5Q%40mail.gmail.com>
Precedence: bulk

On Sat, Mar 23, 2024 at 3:01=E2=80=AFAM Nick Renders <postgres@arcict.com> =
wrote:
> 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.

BTW if you're running databases on mains-powered Macs, I have a patch
that you might be interested in, which so far hasn't attracted any
reviews.  The short version is that I bet you can at least lose many
seconds of commits (because WAL doesn't really hit durable part of
disk), and possibly also fail to recover (pg_control hits disk before
WAL, not sure if this is really possible), if you yank the power and
you're using the default settings for wal_sync_method.  I'd like to
rationalise the settings for that stuff and make it safe by default.

I don't know anything about the USB storage pathway but I'd be
surprised if it's different.

https://www.postgresql.org/message-id/flat/CA%2BhUKG%2BF0EL4Up6yVYbbcWse4xK=
aqW4wc2xpw67Pq9FjmByWVg%40mail.gmail.com