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-09-26 19:07:27
Message-ID: 25677.1190833647@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:
> I just wanted to follow up on this. We've recently upgraded to 8.2.4. I still
> get this message and the empty subdirectories with the later version of
> postgres. I have seen the .nfs files temporarily in the subdirectories that
> remain so I am sure that you are right about the cause, Tom.

Hmm ... I had hoped that the fixes we put in for Windows would solve
this for NFS too, but apparently not.

> Unless you know that this is being worked on for the next version of
> postgres, I think I'll just write a script that removes empty
> subdirectories from the pgdata dir that are more than a week old or
> so, unless you think this is a bad idea.

Well, any fix will probably not appear in production for some months, so
you might as well put in the script if the empty directories bother you.

regards, tom lane

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Cochez 2007-09-27 06:56:19 Re: Long count(*) time
Previous Message Brian A. Seklecki 2007-09-26 02:06:38 Re: clustering and denormalizing with PostgreSQL?