Re: psql error - Mailing list pgsql-general

From Tom Lane
Subject Re: psql error
Date
Msg-id 21449.1080536249@sss.pgh.pa.us
Whole thread Raw
In response to psql error  ("G. Frank Liu" <liug@mama.indstate.edu>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: Re: PG vs MySQL
Next
From: John Fabiani
Date:
Subject: need pg2dbf or pg2xbase