Re: pg_dumpall failing from possible corrupted shared memory - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: pg_dumpall failing from possible corrupted shared memory
Date
Msg-id 36971.73065.qm@web31808.mail.mud.yahoo.com
Whole thread Raw
In response to Re: pg_dumpall failing from possible corrupted shared memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dumpall failing from possible corrupted shared memory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> Are you interested in dumping out the page of pg_index that
> contains this record, using pg_filedump?

Sure, only how do I use pg_filedump?


> In any case, my advice for recovering from the problem once you get
> tired of investigating is to drop and recreate this index.  (If you're
> not sure which one this is, "select 604251::regclass" would tell you.)


I can hold off recreating the index for awhile.  But, I will probably want to get a back-up of
this database in the next couple of weeks.

Regards,

Richard Broersma Jr.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpython.so
Next
From: Tom Lane
Date:
Subject: Re: pg_dumpall failing from possible corrupted shared memory