pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Daniel Caune <daniel.caune@ubisoft.com>
Cc: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: "could not open file" issue
Date: Mon, 24 Apr 2006 17:40:07 -0400
Message-ID: <20060424214006.GE18690@surnet.cl> (raw)
In-Reply-To: <1E293D3FF63A3740B10AD5AAD88535D20213299C@UBIMAIL1.ubisoft.org>
References: <1E293D3FF63A3740B10AD5AAD88535D20213299C@UBIMAIL1.ubisoft.org>

Daniel Caune wrote:

> It seems that was possible:  I tried first to truncate the table (it
> passed), and finally I tried to drop the table (it also passed).  Then
> I created the table.  I'm not sure that it fixes my problem.  I
> modified my fstab file so that Linux checks my file system's health on
> the next boot.

If you experienced memory corruption, it would be wise to run some
hardware diagnosys tools, just to be sure.  For example memtest86,
badblocks, etc.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



view thread (8+ messages)

Message-ID: <20060424214006.GE18690@surnet.cl>
Permalink:  ../20060424214006.GE18690@surnet.cl/
Also on:    postgresql.org/message-id/20060424214006.GE18690@surnet.cl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: alvherre@commandprompt.com, daniel.caune@ubisoft.com, ajs@crankycanuck.ca
  Subject: Re: "could not open file" issue
  In-Reply-To: <20060424214006.GE18690@surnet.cl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox