Thread: psql error
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!
"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