> How does it know what a crashed PostgreSQL database look like?
>
> Besides, active transactions need to be *rolled back*, not written
> ahead, since half the data hasn't been sent from the computer yet.
There's a section of the docs dealing with this:
http://www.postgresql.org/docs/8.1/static/wal.html
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.