Re: pg_clog - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_clog
Date
Msg-id 27860.1166471749@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_clog  ("Edoardo Ceccarelli" <eddy@axa.it>)
List pgsql-admin
"Edoardo Ceccarelli" <eddy@axa.it> writes:
> I bet a crashing process could cause that data corruption, right?

No, Postgres is remarkably resistant to causing corruption during a
crash; it's deliberately engineered that way.  I don't say this
*couldn't* be the explanation but it shouldn't be your first guess.
Frankly I think hardware flakiness is more likely.

There are currently two known crashing bugs in 8.2.0, and both of them
will result in a simple crash, no data corruption.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Where in the source is the "database system identifier" generated?
Next
From: Rickard Sjöström
Date:
Subject: Upgrading from 7.4 to 8.2