Options for fsync?

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Options for fsync?
Date: 2010-03-14 08:54:09
Message-ID: dbbf25901003140054u1595cb22ye53db53c41f5843c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there!

I'm trying to comprehend the current status of filesystem settings and
PostgreSQL settings.

If I run on a machine (using Linux and ext3) with no battery backed
raid controller then I should use fsync=on and disable the write cache
on my harddrives to avoid corruption.

If I had a controller with battery, then I could use fsync=off, but I
should still disable the write cache?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-03-14 09:27:39 Re: Options for fsync?
Previous Message Gordon Shannon 2010-03-14 05:35:20 Re: unexplained autovacuum to prevent wraparound