Re: BUG #5185: postgres error "invalid page header in block xx of relation "pg_proc_proname_args_nsp_index"

Siwat Siwarborvorn wrote:
> - postgresql 8.3.1 compile with options

Although there isn't anything that might explain this issue, you should
upgrade to the latest 8.3 minor release.

> 6) Every time we fixe by reindex pg_proc_proname_args_nsp_index.

Did you keep a copy of the data files? What do the corrupt pages look
like? Are they empty, perhaps, or filled with garbage, or random bit
flips or what?

That index shouldn't be very big, so you could just copy the
corresponding file from the data directory, gzip it and send it by
email, so that others can take a look. Might want to check it a hex
editor first to make sure there isn't anything sensitive, though. Or you
can send it off-list if you prefer.

Use "SELECT relfilenode FROM pg_class WHERE
relname='pg_proc_proname_args_nsp_index'" to find out the filename in
the data directory.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com