Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 71396476A5A for ; Thu, 13 Jun 2002 09:20:02 -0400 (EDT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id 4F7B9476C58 for ; Thu, 13 Jun 2002 09:18:11 -0400 (EDT) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g5DDJk028113; Thu, 13 Jun 2002 16:19:46 +0300 Date: Thu, 13 Jun 2002 16:19:46 +0300 (EEST) From: Achilleus Mantzios To: Ian Cass Cc: pgsql-sql@postgresql.org Subject: Re: Another postgres 'file not found' error In-Reply-To: <106501c212cb$d6f49750$6602a8c0@salamander> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200206/169 X-Sequence-Number: 8134 On Thu, 13 Jun 2002, Ian Cass wrote: > This is the second time within a week I've been hit by a peculiar 'file not > found' error. I've been replacing a few existing Oracle servers with > Postgres. I'm wondering if that was a wise decision :/ What version of pgsql/os are you using??? (Hoping you dont use any ancient pgsql along with an exotic os :) > > inbound=# update store set state = 0, timestamp = 'now' where timestamp < > (CURRENT_TIMESTAMP - interval '30 seconds') and accountid = '6'; > ERROR: cannot open segment 1 of relation store_ix1 (target block > 1576985508): No such file or directory > > -- > Ian Cass > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr