public inbox for [email protected]  

help / color / mirror / Atom feed
From: Thomas Munro <[email protected]>
To: Nick Renders <[email protected]>
Cc: [email protected]
Subject: Re: could not open file "global/pg_filenode.map": Operation not permitted
Date: Thu, 4 Apr 2024 10:14:33 +1300
Message-ID: <CA+hUKGLKbx+zjqthDp1YS=uiWB9PJ2p56BGx+iYUB3LmPN8p5Q@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

On Sat, Mar 23, 2024 at 3:01 AM Nick Renders <[email protected]> wrote:
> We now have a second machine with this issue: it is an Intel Mac mini running macOS Sonoma (14.4) and PostgreSQL 16.2.
> This one only has a single Data directory, so there are no multiple instances 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%2BF0EL4Up6yVYbbcWse4xKaqW4wc2xpw67Pq9FjmByWVg%4...






view thread (15+ messages)

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: could not open file "global/pg_filenode.map": Operation not permitted
  In-Reply-To: <CA+hUKGLKbx+zjqthDp1YS=uiWB9PJ2p56BGx+iYUB3LmPN8p5Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox