Postgres Pro
Downloads
Home   >   mailing lists

Re: silent data loss with ext4 / all current versions - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: silent data loss with ext4 / all current versions
Date
Msg-id CAMsr+YH7j0uvBJQfaOrFX_d0o5mmKkOhj4iqhBYDyW156HAVVg@mail.gmail.com
Whole thread Raw
In response to silent data loss with ext4 / all current versions  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: silent data loss with ext4 / all current versions  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view
On 27 November 2015 at 19:17, Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote:
 
It's also possible to mitigate this by setting wal_sync_method=fsync

Are you sure?

https://lwn.net/Articles/322823/ tends to suggest that fsync() on the file is insufficient to ensure rename() is persistent, though it's somewhat old.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: silent data loss with ext4 / all current versions
Next
From: Craig Ringer
Date:
Subject: Re: How to add and use a static library within Postgres backend