In the case of disk failure, the files will probably be damaged anyway and then i'll have to install new hardware or
format+checkbadblocks and then restore from the backup. I can't see how fsync would help in the case of disk crash.
Withoutreliable raid or something i think this would be a catastrophic failure => get new hardware:
disk/ram/computer/buildingwhatever and go find the (remote) backup.
In the case of power failure, you'll *might* have to restore from backup unless you use ReiserFS or some other
journallingfilesystem. I use ReiserFS. I also have a UPS installed, just to be sure...
Journalling FS will fix the FS problems, so the files are ok.
PG journal will fix the PG problems so the tables will be ok.
From: "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
> On 7 Jul 2003 at 12:59, Mattias Kregert wrote:
>
> > First of all, disable FSYNC... that will speed things up a lot!
>
> That shouldn't have been done so casually. Though can cause performance boost
> and it degrades reliability of data as it can cause data corruption in case of
> power/disk failure.
>
> Bye
> Shridhar