Postgres Pro
Downloads
Home   >   mailing lists

Another postgres 'file not found' error - Mailing list pgsql-sql

From Ian Cass
Subject Another postgres 'file not found' error
Date
Msg-id 106501c212cb$d6f49750$6602a8c0@salamander
Whole thread Raw
Responses Re: Another postgres 'file not found' error  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Re: Another postgres 'file not found' error  ("Josh Berkus" <josh@agliodbs.com>)
Re: Another postgres 'file not found' error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "SDX"
Date:
Subject: How to unsubscribe?
Next
From: Achilleus Mantzios
Date:
Subject: Re: Another postgres 'file not found' error