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@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"