On Wednesday February 7 2007 9:01 am, Tom Lane wrote: > "Ed L." <pgsql@xxxxxxxxxxxxx> writes: > > How do I fix this 7.4.6 issue short of initdb? > > invalid page header in block 110 of relation "pg_statistic" > > I looked at the block via pg_filedump (included below), and > > it does not appear to me to be corrupted, so not sure what I > > would zero out, if anything. > > Seems odd to me too ... but pg_statistic doesn't contain any > irreplaceable data. See if you can TRUNCATE it. If so, do > an ANALYZE to repopulate it. I don't recall if 7.4 has any > special hoops you'd have to jump through to truncate a system > catalog ... $ psql -c "truncate table pg_statistic" ERROR: permission denied: "pg_statistic" is a system catalog I suppose this means single-user mode is required? Any other trick to do this during uptime? TIA. Ed
