Thread: psql error

psql error

From
"G. Frank Liu"
Date:
I have problems connecting to my gforge database (http://gforge.org).
It's been working fine, and now

$ psql -U gforge gforge
psql: FATAL:  Invalid page header in block 3 of pg_trigger_tgrelid_tgname_index

Any ideas how I can fix it?
(I am running postgresql v7.34)

Thanks!


Re: psql error

From
Tom Lane
Date:
"G. Frank Liu" <liug@mama.indstate.edu> writes:
> $ psql -U gforge gforge
> psql: FATAL:  Invalid page header in block 3 of pg_trigger_tgrelid_tgname_index

> Any ideas how I can fix it?

See the REINDEX man page.  In 7.3 I think you have to go through the
full run-a-standalone-backend pushup to reindex a system index.

Also look into doing some hardware testing, because this suggests you've
got flaky disks or RAM.

            regards, tom lane