From: | Greg Stark <gsstark(at)mit(dot)edu> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: production server down |
Date: | 2004-12-15 17:28:36 |
Message-ID: | 87zn0fqxmj.fsf@stark.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2004-12-15 17:36:53 | Re: [Testperf-general] BufferSync and bgwriter |
Previous Message | Joe Conway | 2004-12-15 17:24:57 | Re: production server down |