Tom Lane <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])