On Thu, 10 Jul 2003, Christopher Kings-Lynne wrote: > Just saw this on our demo server: > > [EMAIL PROTECTED]:~/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. 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. Gavin ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match