Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rXHol-009mLj-AY for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Feb 2024 09:32:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rXHok-002HFy-Ff for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Feb 2024 09:32:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rX719-00GBTi-Jj for pgsql-bugs@lists.postgresql.org; Mon, 05 Feb 2024 22:00:43 +0000 Received: from mout.kundenserver.de ([212.227.126.134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rX716-005Fss-EA for pgsql-bugs@postgresql.org; Mon, 05 Feb 2024 22:00:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=oculeus.com; s=s1-ionos; t=1707170437; x=1707775237; i=baranowski@oculeus.com; bh=pzmOuPjL33MkenMDu80q7rJ41mDFT5aCeCekXdf9Z7g=; h=X-UI-Sender-Class:Subject:From:In-Reply-To:Date:Cc:References: To; b=2IYOqsvgblzNvYM9/+TlSCrca/eUTTU8xZyKb0u8N3sFdSaqzdgM6MSWa6E3Ap61 9FhxUBbzNic3f/DqV7/RXHpIUTOT21xndcQDj7ZUiYQnkevF99Q1tK+BfQlwWJhNT CQ8uUmdwZEizjM2JhgSuT3dtMrMq6rp7qWFRkzUwGncTqiKng9ZTePMg+7E0q6bzM 6qZMAs5tRmVSypRzutgReVoVazrI0xYWGiYhCi/U1WsV+OWTSTb8Kixs6ZLnGidaM SzpWA/F3B6nSWH4A3Ud8ni1wO6HAtMRZNRRGT8ZAVw5CLEcAx4H5cY9UatPsJ8l7Y 9410uMN2ZTrUcfNx7A== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from smtpclient.apple ([95.222.250.86]) by mrelayeu.kundenserver.de (mreue012 [212.227.15.167]) with ESMTPSA (Nemesis) id 1MT7ip-1rRqeI1lRn-00UWjI; Mon, 05 Feb 2024 23:00:37 +0100 Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.400.31\)) Subject: Re: PostgreSQL & latest Mac OS Sonoma, a possible bug / configuration issue From: Arnd Baranowski In-Reply-To: <269596.1707165898@sss.pgh.pa.us> Date: Mon, 5 Feb 2024 23:00:26 +0100 Cc: pgsql-bugs@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <269596.1707165898@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.3774.400.31) X-Provags-ID: V03:K1:oU4tPzvQ+A5qq/l5DWE0iJml1De02dPpU7AFqo8sbOhX1TiLUv6 JsFvUlnttrrkjAu9iOqZ5GQU5npyYeHudqtWYQNrFsVH1OIOnfGBfu9DM1IOV2mjxIUD1qK 8nqe65wP22oacPk/5gLIjZYq612wDHtb/88TA/qCYgweirb0LGuCrsOSOMlJIu8iEA5+I0p wWGEILWh97MK/N9HkFc3w== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:6B2a/sqCkco=;Z7ULxUwJwhroFRJcDySXZIC6a/J Rq1lZbZI2qQ8GSAnos8MLvvz5o3MFxTUfZ9uPQliYkel+x88J+Th/A9eHpRYMLCP5vDsDf9ah MCRnB3bFEwKM4hVgzxJWduUp7Z0GHYekAx5HVJvkptw23CXnwlRs1umjKb6Zalafg6vd8Q1Vi hiiKnJdwCctzClox7IZSkBEPGSTqOSbsH3D3y1NJTsnIXo+ie/2wlhTuDBtt1TePVudt3RsOl iYkvhQpokTHusipF1+usWURenfrCQ2kld0nFiRkHIF+fkTMhxb+yeRdcWRxNh6fwfN/WqThlb MhkeTCOTnAEFHQIBM5y24C5vE3IyjHCq6H5OEwtn5jbg04apLli8LmI6abjpi7hF0n5fRK8cR KnuUvlFJ4auN77begIifgHT2gVgLJOdAebsZJfm/0y74/a74Rl1COLxl4RQe9jF4gypusIQzI oz0FS3srKJ+LUhJgIwCR0zJOIZNjhlcNhIuU6EIbAFj7tNcIm1JO7wZjxBd4XH8ZkYf4y0Vnk oOzixML/kBxPtW7Enk3wETg0LgG83UaSE0eLcfssjvoZyqfeC+OP3oyEVYD3XjbtF6vxR6e/D E93roTHVAEPDjkOpuPKOWVwhKnQ7wz14HLmwO9qVuyQCPuLg0XS8OZKhI7aBYXuZNMpC5HNR5 2MoTyAlEJOvGavQzdU1u/OeZiQ1I4tGvgi3ayjezs34Q9rjgiyBlQ75EdqyEKjgFp/HcDPGiX HL5pH8raIko+YUT8za+Lg1JjuWmi3gXXCNERYAAS+cp1MFKyrRPvFI= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Correction fsync is =E2=80=9EOn" and the wal_sync_method is set to = =E2=80=9Eopen_datasync=E2=80=9C > Am 05.02.2024 um 21:44 schrieb Tom Lane : >=20 > Arnd Baranowski 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. =46rom 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. >=20 > 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? >=20 > regards, tom lane