Re: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...

It looks like you are suffering from actual hardware failures:

%cd /pgsql/data/base/horde
%ls -l pg_attribute_relid_attnam_index
-rw------- 1 pgsql pgsql 65536 Aug 21 12:27 pg_attribute_relid_attnam_index
%wc pg_attribute_relid_attnam_index
wc: pg_attribute_relid_attnam_index: read: Input/output error

%wc *
1 1 4 PG_VERSION
wc: active_sessions: read: Input/output error
13 50 16384 active_sessions_pkey
0 0 0 auth_user
0 0 0 auth_user_md5
0 3 16384 auth_user_md5_pkey
0 3 16384 auth_user_pkey
51 806 32768 imp_addr
0 5 8192 imp_logs
97 468 16384 imp_pref
0 3 16384 k_username
0 3 16384 k_username_md5
1 101 8192 pg_aggregate
1 11 16384 pg_aggregate_name_type_index
1 12 8192 pg_am
wc: pg_am_name_index: read: Input/output error
3 220 16384 pg_amop
3 31 16384 pg_amop_opid_index
2 26 16384 pg_amop_strategy_index
2 70 8192 pg_amproc
0 136 8192 pg_attrdef
0 10 16384 pg_attrdef_adrelid_index
35 736 57344 pg_attribute
wc: pg_attribute_relid_attnam_index: read: Input/output error
16 664 32768 pg_attribute_relid_attnum_index
23 144 16384 pg_class
2 112 16384 pg_class_oid_index
2 17 16384 pg_class_relname_index
58 3096 73728 pg_description
wc: pg_description_objoid_index: read: Input/output error
2 84 8192 pg_index
1 47 16384 pg_index_indexrelid_index
0 0 0 pg_indexes
0 0 0 pg_inheritproc
0 0 0 pg_inherits
0 3 16384 pg_inherits_relid_seqno_index
0 4 1752 pg_internal.init
0 0 0 pg_ipl
0 10 8192 pg_language
0 3 16384 pg_language_name_index
0 8 16384 pg_language_oid_index
0 0 0 pg_listener
wc: pg_listener_relname_pid_index: read: Input/output error
1 39 8192 pg_opclass
1 39 16384 pg_opclass_deftype_index
1 9 16384 pg_opclass_name_index
wc: pg_operator: read: Input/output error
11 652 32768 pg_operator_oid_index
14 95 65536 pg_operator_oprname_l_r_k_index
176 3305 212992 pg_proc
71 1520 49152 pg_proc_oid_index
wc: pg_proc_proname_narg_type_index: read: Input/output error
0 0 0 pg_relcheck
0 3 16384 pg_relcheck_rcrelid_index
28 351 8192 pg_rewrite
wc: pg_rewrite_oid_index: read: Input/output error
0 3 16384 pg_rewrite_rulename_index
0 0 0 pg_rules
15 327 16384 pg_statistic
10 232 16384 pg_statistic_relid_att_index
0 0 0 pg_tables
0 6 8192 pg_trigger
0 4 16384 pg_trigger_tgconstrname_index
0 5 16384 pg_trigger_tgconstrrelid_index
0 5 16384 pg_trigger_tgrelid_index
8 170 16384 pg_type
3 150 16384 pg_type_oid_index
2 20 16384 pg_type_typname_index
0 0 0 pg_user
0 0 0 pg_views
655 13822 1132252 total

Do you know if there's a way to determine where these files are
physically stored? I'm wondering if all the damaged indexes live
on the same disk track/cylinder/whatever ...

regards, tom lane