Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS - Mailing list pgsql-hackers

From Christophe Pettus
Subject Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS
Date
Msg-id DB6243F9-ABC1-49EB-94A3-AC4E80FEEAF6@thebuild.com
Whole thread Raw
In response to Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS
List pgsql-hackers
> On Apr 2, 2018, at 16:27, Craig Ringer <craig@2ndQuadrant.com> wrote:
>
> They're undocumented and extremely surprising semantics that are arguably a violation of the POSIX spec for fsync(),
orat least a surprising interpretation of it. 

Even accepting that (I personally go with surprising over violation, as if my vote counted), it is highly unlikely that
wewill convince every kernel team to declare "What fools we've been!" and push a change... and even if they did,
PostgreSQLcan look forward to many years of running on kernels with the broken semantics.  Given that, I think the
PANICoption is the soundest one, as unappetizing as it is. 

--
-- Christophe Pettus
   xof@thebuild.com



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS
Next
From: Andres Freund
Date:
Subject: Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS