Re: [GENERAL] does database shut down cleanly when WAL device fails?

2005-05-04 Thread Bruce Momjian
Tom Lane wrote: Brandon Craig Rhodes [EMAIL PROTECTED] writes: And the disputed point: - If the drive holding the WAL fails, then the database engine will shut down cleanly by writing everything in RAM out to the real database tables, and no data will

[GENERAL] does database shut down cleanly when WAL device fails?

2005-05-03 Thread Brandon Craig Rhodes
In planning a Postgresql deployment, our team discovered that we have different understandings of how the WAL affects database reliability, and we have not found the Postgresql manual quite explicit enough to distinguish between the following two theories: a) Putting the WAL on a separate

Re: [GENERAL] does database shut down cleanly when WAL device fails?

2005-05-03 Thread Tom Lane
Brandon Craig Rhodes [EMAIL PROTECTED] writes: And the disputed point: - If the drive holding the WAL fails, then the database engine will shut down cleanly by writing everything in RAM out to the real database tables, and no data will be lost. Whoever