Re: [BUGS] BUG #13350: blindly fsyncing data dir considered harmful - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: [BUGS] BUG #13350: blindly fsyncing data dir considered harmful
Date
Msg-id 20150525151243.GM26667@tamriel.snowman.net
Whole thread Raw
Responses Re: [CORE] [BUGS] BUG #13350: blindly fsyncing data dir considered harmful  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
All,

(sending to -core to request a release)

* andrew@tao11.riddles.org.uk (andrew@tao11.riddles.org.uk) wrote:
> Operating system:   Debian (and probably others)

> The addition of a recursive fsync of the data dir on startup (in the absence
> of a clean shutdown) causes startup to fail if the data dir contains
> symlinks to files which the postgres user can't write to.
>
> This is the standard configuration for many SSL-enabled setups, including
> the standard debian packaging defaults. Accordingly, crash recovery now
> ALWAYS fails on such systems without manual intervention.

Andrew did a great job summarizing the problem, don't know that there's
much to add there.

This was back-patched all the way and released with the latest round of
minor releases, and given that it means crash recovery fails for a large
number of deployed systems, I think we need to fix (or revert) the
recursive fsync change (d8ac77ab178ddb2ae043b8c463cd30c031e793d0 and
related) and do new releases very shortly.
Thanks!
    Stephen

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Order of columns in query is important?!
Next
From: Magnus Hagander
Date:
Subject: Re: [CORE] [BUGS] BUG #13350: blindly fsyncing data dir considered harmful