From: Arnd Baranowski <baranowski@oculeus.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@postgresql.org
Subject: Re: PostgreSQL & latest Mac OS Sonoma, a possible bug / configuration issue
Date: Mon, 5 Feb 2024 23:00:26 +0100
Message-ID: <E51BA147-F341-485D-8384-FCF6CA3CF7E4@oculeus.com> (raw)
In-Reply-To: <269596.1707165898@sss.pgh.pa.us>
References: <C87F1481-6A03-45E3-BE60-C55F568220C0@oculeus.com>
<269596.1707165898@sss.pgh.pa.us>
Correction fsync is „On" and the wal_sync_method is set to „open_datasync“
> Am 05.02.2024 um 21:44 schrieb Tom Lane <tgl@sss.pgh.pa.us>:
>
> 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: baranowski@oculeus.com, tgl@sss.pgh.pa.us
Subject: Re: PostgreSQL & latest Mac OS Sonoma, a possible bug / configuration issue
In-Reply-To: <E51BA147-F341-485D-8384-FCF6CA3CF7E4@oculeus.com>
* 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