psql error
Started by G. Frank Liuabout 22 years ago2 messagesgeneral
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
"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