Re: production server down

Tom Lane <tgl@sss.pgh.pa.us> writes:

> > The server experienced a hang (as yet unexplained) yesterday and was 
> > restarted at 2004-12-13 16:38:49 according to syslog. I'm told by the 
> > network admin that there was a problem with the network card on restart, 
> > so the nfs mount most probably disappeared and then reappeared 
> > underneath a quiescent postgresql at some point between 2004-12-13 
> > 16:39:55 and 2004-12-14 15:36:20 (but much closer to the former than the 
> > latter).
> 
> I've always felt that running a database across NFS was a Bad Idea ;-)

Well not that I disagree with that sentiment, but NFS was specifically
designed to handle this particular scenario. *UNLESS* you use the "soft"
option. As popular as it is, this is precisely the scenario where it causes
problems.

(The "intr" option as well, but I don't think that would be relevant for
postgres).


-- 
greg