Re: Urgent!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Urgent!
Date: 2005-10-13 16:31:17
Message-ID: 23171.1129221077@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> You should never just turn off a database server... always shut it down
>> normally... Turning it off was a major mistake.

> PostgreSQL should never get corrupted by turning off the server. It
> isn't ideal to do that, but it should not get corrupted.

We can only make that promise if we are on hardware that doesn't lie to
us about disk write completion ... if this machine is generic PC
hardware it's probably not configured properly.

The symptoms sound to me like corrupt data (probably due to a partial
page disk write). There isn't going to be any magic fix, but you can
probably recover everything but the specific damaged page(s). See the
mailing list archives for previous discussions of cleaning up data
corruption.

regards, tom lane

In response to

  • Re: Urgent! at 2005-10-13 15:56:48 from Bruce Momjian

Browse pgsql-admin by date

  From Date Subject
Next Message Nigel Bishop 2005-10-13 16:48:39 Re: DB Cluster hanging
Previous Message Scott Marlowe 2005-10-13 16:31:09 Re: DB Cluster hanging