Rusty Wright wrote: > It seems to me that if the machine crashes in the middle of a > transaction that there will be or is a very high chance of database > corruption. I don't know if and how postgresql would detect and > handle that after the system reboots. We are running mysql here and > haven't had any data integrity problems.
No chance of corruption. On restart, the WAL file will bring the system back to the state before the transaction started. In fact, the WAL doesn't even have to be used because the transaction isn't marked as completed yet. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
