Re: weird problem

On Thu, Jul 10, 2003 at 11:45:09AM +1000, Gavin Sherry wrote:
> On Thu, 10 Jul 2003, Christopher Kings-Lynne wrote:
>
> > Just saw this on our demo server:
> >
> > root(at)phppgadmin:~/htdocs/webdb/conf# /usr/local/pgsql-7.3.3/bin/psql -p5473
> > phppgadmin
> > psql: FATAL: cannot open segment 1 of relation
> > pg_trigger_tgrelid_tgname_index (target block 8310112): No such file or
> > directory
>
> Seems like a hosed file system to me. You'll probably need to go to
> backups and should do some hardware tests.

Hmm... I was thinking the index could be somehow corrupted. However,
it's strange that all databases have the same problem, since pg_trigger
is not shared across databases.

Have you tried reindexing pg_trigger?

> Which file system is this running on. There seem to be a large number of
> people on IRC will similar problems when running on ReiserFS.

Well, older versions of ReiserFS corrupted data for me after crashes
(not PG data though -- CUPS config files and stuff). I supposed newer
versions were fixed, and I think Cristopher runs FreeBSD anyway?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Uno puede defenderse de los ataques; contra los elogios se esta indefenso"