Alban Hertroys <haramrae@xxxxxxxxx> writes: > That begs the question what happens in case of a crash or (worse) a partial crash when multiple file systems are involved. As long as the OS+hardware honors the contract of fsync(), everything's fine. If the storage system loses data that it claims to have fsync'd to stable storage, there's not much we can do about that, except recommend that you have a backup plan. In practice, the more complicated your storage infrastructure is, the more likely it is to have bugs ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
