On 2015-01-14 10:53:40 +0100, Andres Freund wrote:
> On 2015-01-14 11:43:00 +0200, Heikki Linnakangas wrote:
> > I'm not thrilled about sprinkling fsync() calls everywhere that we touch
> > files. But I guess that would be the right thing to do. I'm planning to do
> > that as an add-on patch later, fixing also pg_basebackup and any other
> > utilities that need it.
>
> Yea, we really need to do this. We also need it in the server, right now
> there's a bunch of rather ugly corner cases where we rely on not fsynced
> files being present after e.g. two consecutive crashes. Abhijit has sent
> a patch.
explanation
http://archives.postgresql.org/message-id/20140918083148.GA17265%40alap3.anarazel.de
Abhijit's patch
http://www.postgresql.org/message-id/20141106122653.GA18963@toroid.org
Greetings,
Andres Freund
-- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services