Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA12911; Fri, 10 Apr 92 09:12:48 -0700
Message-Id: <9204101612.AA12911@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: temp-XXXXX files
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Tue, 07 Apr 92 11:00:33 PDT."
             <9204070153.AA14431@dpi.inpe.br> 
Date: Fri, 10 Apr 92 09:06:51 PDT

you write:
>How are the temp-xxxx files created under a database directory managed by pos
 tgres? when my application crashes many of it is left on /data/base/<database
 directory. I am getting messages like this:

> WARN:Apr  3 10:58:31:cannot open       temp_40065
> 
> Postgres Returns An Error - Aborting Program

If the backend creates a temporary relation and crashes before the current
xact can commit then the temporary relation must be removed by hand.  The
reason is that we don't assume we can overwrite existing files under the
data directory.

> Also many ".nfsXXXX" files are generated and left there.

I don't know what these are.


Jeff Meredith
mer@postgres.berkeley.edu