pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Network Storage Devices / NFS ...
4+ messages / 2 participants
[nested] [flat]

* Network Storage Devices / NFS ...
@ 2005-06-03 01:19  Marc G. Fournier <scrappy@postgresql.org>
  0 siblings, 1 reply; 4+ messages in thread

From: Marc G. Fournier @ 2005-06-03 01:19 UTC (permalink / raw)
  To: pgsql-admin


Anyone actually dealing with a configuration using this for your data 
drives?  I'm looking for more details on what exactly they are using for 
the NFS server, but I have a client reporting that their pg_xlog directory 
is *full* of .nfs* files that are 'months old' ... I'm suspecting that 
this is some sort of temp file that the NFS itself is creating, and is 
safe to just delete, but am wondering if someone out there knows more 
definitively ... ?



----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Network Storage Devices / NFS ...
@ 2005-06-03 03:29  Matthew D. Fuller <fullermd@over-yonder.net>
  parent: Marc G. Fournier <scrappy@postgresql.org>
  0 siblings, 1 reply; 4+ messages in thread

From: Matthew D. Fuller @ 2005-06-03 03:29 UTC (permalink / raw)
  To: Marc G. Fournier <scrappy@postgresql.org>; +Cc: pgsql-admin

On Thu, Jun 02, 2005 at 10:19:38PM -0300 I heard the voice of
Marc G. Fournier, and lo! it spake thus:
> 
> Anyone actually dealing with a configuration using this for your
> data drives?  I'm looking for more details on what exactly they are
> using for the NFS server, but I have a client reporting that their
> pg_xlog directory is *full* of .nfs* files that are 'months old' ...
> I'm suspecting that this is some sort of temp file that the NFS
> itself is creating, and is safe to just delete, but am wondering if
> someone out there knows more definitively ... ?

As I recall, that's a side-effect of deleting files on NFS, because of
the statelessness.  If one client has a file open, and another client
deletes it, or two processes on the same client have it open and
deleted respectively, or something on the server...   I can't remember
which case it is.  But they're renames of files that were "deleted".
If nothing has them open (fstat or lsof or something) they should be
safe to delete (but don't blame me if it blows up!).


-- 
Matthew Fuller     (MF4839)   |  fullermd@over-yonder.net
Systems/Network Administrator |  http://www.over-yonder.net/~fullermd/
           On the Internet, nobody can hear you scream.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Network Storage Devices / NFS ...
@ 2005-06-03 03:45  Marc G. Fournier <scrappy@postgresql.org>
  parent: Matthew D. Fuller <fullermd@over-yonder.net>
  0 siblings, 1 reply; 4+ messages in thread

From: Marc G. Fournier @ 2005-06-03 03:45 UTC (permalink / raw)
  To: Matthew D. Fuller <fullermd@over-yonder.net>; +Cc: Marc G. Fournier <scrappy@postgresql.org>; pgsql-admin

On Thu, 2 Jun 2005, Matthew D. Fuller wrote:

> On Thu, Jun 02, 2005 at 10:19:38PM -0300 I heard the voice of
> Marc G. Fournier, and lo! it spake thus:
>>
>> Anyone actually dealing with a configuration using this for your
>> data drives?  I'm looking for more details on what exactly they are
>> using for the NFS server, but I have a client reporting that their
>> pg_xlog directory is *full* of .nfs* files that are 'months old' ...
>> I'm suspecting that this is some sort of temp file that the NFS
>> itself is creating, and is safe to just delete, but am wondering if
>> someone out there knows more definitively ... ?
>
> As I recall, that's a side-effect of deleting files on NFS, because of
> the statelessness.  If one client has a file open, and another client
> deletes it, or two processes on the same client have it open and
> deleted respectively, or something on the server...   I can't remember
> which case it is.  But they're renames of files that were "deleted".
> If nothing has them open (fstat or lsof or something) they should be
> safe to delete (but don't blame me if it blows up!).

This is what I was thinking two (around safeness to delete) ... to be 
absolutely certain, doing a quick maintenance shutdown for the postmaster, 
remove all .nfs* files and then restarting should be safe too ...

Sound about right?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Network Storage Devices / NFS ...
@ 2005-06-03 03:49  Matthew D. Fuller <fullermd@over-yonder.net>
  parent: Marc G. Fournier <scrappy@postgresql.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Matthew D. Fuller @ 2005-06-03 03:49 UTC (permalink / raw)
  To: Marc G. Fournier <scrappy@postgresql.org>; +Cc: pgsql-admin

On Fri, Jun 03, 2005 at 12:45:08AM -0300 I heard the voice of
Marc G. Fournier, and lo! it spake thus:
> On Thu, 2 Jun 2005, Matthew D. Fuller wrote:
> >
> >If nothing has them open (fstat or lsof or something) they should
> >be safe to delete (but don't blame me if it blows up!).
> 
> This is what I was thinking two (around safeness to delete) ... to
> be absolutely certain, doing a quick maintenance shutdown for the
> postmaster, remove all .nfs* files and then restarting should be
> safe too ...

Ah, I knew there had to be a better explanation around...
<http://www.webservertalk.com/archive211-2005-2-891673.html; seems to
cover it pretty well.

Yah, if they're in that directory, it's pretty much a given that the
postmaster was the only program touching them (and if it was anything
else, you probably don't care about it).  So, shutting down and
deleting the files should take care of it.


-- 
Matthew Fuller     (MF4839)   |  fullermd@over-yonder.net
Systems/Network Administrator |  http://www.over-yonder.net/~fullermd/
           On the Internet, nobody can hear you scream.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-06-03 03:49 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-03 01:19 Network Storage Devices / NFS ... Marc G. Fournier <scrappy@postgresql.org>
2005-06-03 03:29 ` Matthew D. Fuller <fullermd@over-yonder.net>
2005-06-03 03:45   ` Marc G. Fournier <scrappy@postgresql.org>
2005-06-03 03:49     ` Matthew D. Fuller <fullermd@over-yonder.net>

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