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?
>
> Find out the ctid of the busted pg_index record; the first part of it is
> the page number.  Then
>
>     pg_filedump -i -f -R page_number pg_index_filename >resultfile
>
> The filename is whatever "select relfilenode from pg_class where relname
> = 'pg_index'" tells you, in whatever subdirectory of $PGDATA/base
> "select oid from pg_database where datname = 'yourdb'" tells you.

mydb=# select ctid from pg_index where indrelid = 16737 and indexrelid = 604251;
  ctid
--------
 (1,11)
(1 row)
mydb=# select relfilenode from pg_class where relname = 'pg_index';
 relfilenode
-------------
        2610
(1 row)
mydb=# select oid from pg_database where datname = 'mydb';
  oid
-------
 16393
(1 row)

postgres@db_server01 ~ $ ./pg_filedump -i -f -R 1 /var/lib/pgsql/data/base/16393/2610 >
./results.log

I've attached the results.log to the email.

Regards,

Richard Broersma Jr.