From: Tom Lane <tgl@sss.pgh.pa.us>
To: Arnd Baranowski <baranowski@oculeus.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: PostgreSQL & latest Mac OS Sonoma, a possible bug / configuration issue
Date: Mon, 05 Feb 2024 15:44:58 -0500
Message-ID: <269596.1707165898@sss.pgh.pa.us> (raw)
In-Reply-To: <C87F1481-6A03-45E3-BE60-C55F568220C0@oculeus.com>
References: <C87F1481-6A03-45E3-BE60-C55F568220C0@oculeus.com>
Arnd Baranowski <baranowski@oculeus.com> writes:
> I have a MacBook Pro 16 inch with M3 Max in the base configuration (48 gig RAM, 1 terabyte HD). Operating System macOS the latest Sonoma 14.3. I use the latest Postgres 14 installed via brew in the standard configuration. From time to time (every second or third week) I use to reboot the Mac and since several weeks now (the last 4 reboots at least) I lose data of the database when rebooting and I fall back to a state of several days ahead of the reboot. This affects structure and data added. I cover this via backups and it looks that data is kept in memory rather than written to the database. Beside this Mac and Postgres run fine.
Hmm, what have you got the fsync and wal_sync_method GUCs set to?
What was the last macOS version that was stable for you?
regards, tom lane
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: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, baranowski@oculeus.com
Subject: Re: PostgreSQL & latest Mac OS Sonoma, a possible bug / configuration issue
In-Reply-To: <269596.1707165898@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox