Re: newbie qs; fixing and checking databases - Mailing list pgsql-admin

From Rusty Wright
Subject Re: newbie qs; fixing and checking databases
Date
Msg-id 200210161936.g9GJaHQ03777@socrates.Berkeley.EDU
Whole thread Raw
In response to newbie qs; fixing and checking databases  (Rusty Wright <rusty@socrates.Berkeley.EDU>)
Responses Re: newbie qs; fixing and checking databases  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: VACUUM FULL fails to free diskspacef
Next
From: "Devinder K Rajput"
Date:
Subject: Re: newbie qs; examining databases and tables