Postgres Pro
Downloads
Home   >   mailing lists

BUG #13350: blindly fsyncing data dir considered harmful - Mailing list pgsql-bugs

From andrew@tao11.riddles.org.uk
Subject BUG #13350: blindly fsyncing data dir considered harmful
Date
Msg-id 20150525142657.4686.35151@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      13350
Logged by:          Andrew Gierth
Email address:      andrew@tao11.riddles.org.uk
PostgreSQL version: 9.1.16
Operating system:   Debian (and probably others)
Description:

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.

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #13349: Recheck logic with index mixed up when used with LATERAL
Next
From: digoal@126.com
Date:
Subject: BUG #13348: PostgreSQL 9.5 sampletable BUG return rows not the same as reltuples*sample factor?