Re: newbie qs; fixing and checking databases

Did somebody just yell "fire" in a crowded theatre?

Ken

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Bruce Momjian
Sent: Wednesday, October 16, 2002 12:54 PM
To: Rusty Wright
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] 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(at)candle(dot)pha(dot)pa(dot)us | (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 majordomo(at)postgresql(dot)org