Bruce Momjian <[EMAIL PROTECTED]> writes:
> scott.marlowe wrote:
>>> There is no real need (or benefit) from having the database on a
>>> journalled filesystem - the journalling is only trying to give similar
>>> sorts of guarantees to what the fsync in PostgreSQL is doing.
>> Is this true?  I was under the impression that without at least meta-data 
>> journaling postgresql could still be corrupted by power failure.

> It is false.  ext2 isn't crash-safe, and PostgreSQL needs an intact file
> system for WAL recovery.

But it should be okay to set the filesystem to journal only its own
metadata.  There's no need for it to journal file contents.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to