Richard Broersma Jr <rabroersma@xxxxxxxxx> writes: >> 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. Oh, if you don't have pg_filedump, get it from http://sources.redhat.com/rhdb/ Be sure to get the one matching your PG version. regards, tom lane
