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 ...
Scheduled downtime finally arrived last night, and I tried
unsuccessfully to truncate this table:
postgres -D $PGDATA -O -o standalone_log mydb
> truncate pg_statistic;
> ^D
pg_ctl start
psql -d mydb -c "vacuum analyze"
The truncate showed no errors. The vacuum analyze showed the
same error in block 110 of the pg_statistic table. Any ideas
what I'm missing here? Is there another acceptable way to
truncate that table, perhaps "rm file; touch file"?
Ed
