Re: psql error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "G(dot) Frank Liu" <liug(at)mama(dot)indstate(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psql error
Date: 2004-03-29 04:57:29
Message-ID: 21449.1080536249@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"G. Frank Liu" <liug(at)mama(dot)indstate(dot)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

In response to

  • psql error at 2004-03-29 04:13:13 from G. Frank Liu

Browse pgsql-general by date

  From Date Subject
Next Message John Fabiani 2004-03-29 06:12:40 need pg2dbf or pg2xbase
Previous Message David Garamond 2004-03-29 04:57:20 Re: PG vs MySQL