Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

Next:From: Rickard SjöströmDate: 2006-12-19 09:03:52
Subject: Upgrading from 7.4 to 8.2
Previous:From: Tom LaneDate: 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 BennettDate: 2006-12-18 21:34:22
Subject: Re: Ant <sql> tag for dollar quoting
Previous:From: Jason BennettDate: 2006-12-18 19:33:32
Subject: Ant <sql> tag for dollar quoting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group