| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Rusty Wright <rusty(at)socrates(dot)Berkeley(dot)EDU> |
| Cc: | tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: newbie qs; fixing and checking databases |
| Date: | 2002-10-16 19:53:35 |
| Message-ID: | 200210161953.g9GJrZK27717@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ken | 2002-10-16 20:04:57 | Re: newbie qs; fixing and checking databases |
| Previous Message | Devinder K Rajput | 2002-10-16 19:46:57 | Re: newbie qs; examining databases and tables |