Re: fsync, ext2 on Linux - Mailing list pgsql-hackers

From Tom Lane
Subject Re: fsync, ext2 on Linux
Date
Msg-id 27660.1099235701@sss.pgh.pa.us
Whole thread Raw
In response to fsync, ext2 on Linux  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: fsync, ext2 on Linux
Re: fsync, ext2 on Linux
Re: fsync, ext2 on Linux
List pgsql-hackers
Heikki Linnakangas <hlinnaka@iki.fi> writes:
> The Linux [ext2] fsync man page says:
> "It does not necessarily ensure that the entry in the directory 
> containing the file has also reached disk. For that an explicit fsync on 
> the file descriptor of the directory is also needed."

This seems so broken as to defy belief.  A process creating a file
doesn't normally *have* a file descriptor for the parent directory,
and I don't think the concept of an FD for a directory is even
portable (opendir() certainly doesn't return an FD).  One might also
ask if we are expected to fsync everything up to the root in order
to be sure that the file remains accessible, and how exactly we should
do that on directories we don't have write access for.

In general we expect the filesystem to take care of its own metadata.
Run ext3 in journaling mode, or something like that.

(It occurs to me that the admin guide really ought to have a few words
about recommended and non-recommended filesystems ...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Version defines
Next
From: Andrew Dunstan
Date:
Subject: Re: fsync, ext2 on Linux