Re: Corrupt database? 8.1/FreeBSD6.0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Corrupt database? 8.1/FreeBSD6.0
Date: 2007-01-12 15:00:37
Message-ID: 6764.1168614037@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Jeff Amiel <becauseimjeff(at)yahoo(dot)com> writes:
> Any ideas on how should I move forward?

Well, if the problem is indeed in pg_statistic, it'll be easy to repair
(think TRUNCATE...). Have you turned up the logging level to find out?

BTW, please don't do anything to try to correct the problem until we're
pretty sure we understand how this happened --- we might ask you for
more info. AFAICS this isn't having any bad effects except for bleats
in your log file, so you can wait.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2007-01-12 15:07:18 Re: [HACKERS] Checkpoint request failed on version 8.2.1.
Previous Message Richard Huxton 2007-01-12 15:00:12 Re: Need setup help for Postgresql 8.1.3 on Solaris

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas ADI SD 2007-01-12 15:07:07 Re: [GENERAL] Checkpoint request failed on version 8.2.1.
Previous Message Stefan Kaltenbrunner 2007-01-12 14:57:47 Re: [COMMITTERS] pgsql: Stamp major release 8.3.0,