"Edoardo Ceccarelli" <eddy(at)axa(dot)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
In response to
- Re: pg_clog at 2006-12-18 19:01:17 from Edoardo Ceccarelli
pgsql-admin by date
|Next:||From: Rickard Sjöström||Date: 2006-12-19 09:03:52|
|Subject: Upgrading from 7.4 to 8.2|
|Previous:||From: Tom Lane||Date: 2006-12-18 19:45:27|
|Subject: Re: Where in the source is the "database system identifier" generated? |
pgsql-jdbc by date
|Next:||From: Jason Bennett||Date: 2006-12-18 21:34:22|
|Subject: Re: Ant <sql> tag for dollar quoting|
|Previous:||From: Jason Bennett||Date: 2006-12-18 19:33:32|
|Subject: Ant <sql> tag for dollar quoting|