Re: pg_clog

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Edoardo Ceccarelli" <eddy(at)axa(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_clog
Date: 2006-12-18 19:55:49
Message-ID: 27860.1166471749@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

"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

Browse pgsql-admin by date

  From Date Subject
Next Message Rickard Sjöström 2006-12-19 09:03:52 Upgrading from 7.4 to 8.2
Previous Message Tom Lane 2006-12-18 19:45:27 Re: Where in the source is the "database system identifier" generated?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jason Bennett 2006-12-18 21:34:22 Re: Ant <sql> tag for dollar quoting
Previous Message Jason Bennett 2006-12-18 19:33:32 Ant <sql> tag for dollar quoting