Re: newbie qs; fixing and checking databases

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
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073