Re: pg_dumpall failing from possible corrupted shared memory

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dumpall failing from possible corrupted shared memory
Date: 2006-10-27 02:46:32
Message-ID: 20061027024632.10511.qmail@web31811.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> >Worst-case, you can probably fix things by dropping and
> > recreating the constraint or index ...log_min_messages = info but before you do that, I'd
> urge
> > you to try to get as much info as you can about the nature of the
> > catalog corruption. If there's a bug here, as opposed to random
> > cosmic-ray damage, we can't fix it without more info.

I eliminated the non-offending index with this query:

select pg_get_indexdef(indexrelid)
from pg_index
where indexrelid <> 604251 -- this is the index with the problem
order by indexrelid;

How do I go about determining if the crash i caused by faulty hardware or a possible bug?

Regards,

Richard Broersma Jr.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-27 03:06:30 Re: [SQL] Can we convert from Postgres to Oracle !!???
Previous Message lord.zoltar 2006-10-27 02:23:17 arrays of user types.