Re: Could not remove file messages

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mija Lee <mija(at)scharp(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Could not remove file messages
Date: 2007-08-30 19:07:43
Message-ID: 7642.1188500863@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Mija Lee <mija(at)scharp(dot)org> writes:
> We're running 8.1.4. Relevant log messages below:

> 01:45:59 PDT WARNING: could not remove file or directory "base/11210840": File exists
> 01:45:59 PDT WARNING: could not remove database directory "base/11210840"

Hm, on what platform? There are known reasons for this to happen on
Windows (basically, that removing files can be delayed if the bgwriter
process still has them open). I'm not sure to what extent that's been
fixed in later PG releases. But you really ought to be running 8.1.9
anyway ...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Matthews, James 2007-08-30 19:33:06 Re: Querying a parent table's child schemas
Previous Message Mija Lee 2007-08-30 17:15:22 Could not remove file messages