Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id CB3D7476191 for ; Thu, 13 Jun 2002 07:18:56 -0400 (EDT) Received: from mblox.com (unknown [213.155.153.59]) by postgresql.org (Postfix) with ESMTP id CC335475965 for ; Thu, 13 Jun 2002 07:18:55 -0400 (EDT) Received: from salamander (salamander.mblox.com [::ffff:192.168.2.102]) (AUTH: LOGIN ian.cass) by aerosmith with esmtp; Thu, 13 Jun 2002 11:18:58 +0000 Message-ID: <106501c212cb$d6f49750$6602a8c0@salamander> From: "Ian Cass" To: pgsql-sql@postgresql.org Subject: Another postgres 'file not found' error Date: Thu, 13 Jun 2002 12:17:00 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200206/168 X-Sequence-Number: 8133 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 :/ 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