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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: pg_dumpall failing from possible corrupted shared memory



> 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.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group