Skip site navigation (1) Skip section navigation (2)

Re: Patch to improve reliability of postgresql on linux nfs

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, George Barnett <gbarnett(at)atlassian(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Patch to improve reliability of postgresql on linux nfs
Date: 2011-09-09 15:30:02
Message-ID: E6D9F81D0609BDC4C969BFA7@apophis.local (view raw or whole thread)
Lists: pgsql-hackers

--On 9. September 2011 10:27:22 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> On the whole I think you'd be better off lobbying your NFS implementors
> to provide something closer to the behavior of every other filesystem on
> the planet.  Or checking to see if you need to adjust your NFS
> configuration, as the other responders mentioned.

You really need at least mount options 'hard' _and_ 'nointr' on NFS mounts, 
otherwise you are out of luck. Oracle and DB2 guys recommend those settings and 
without them any millisecond of network glitch could disturb things 



In response to


pgsql-hackers by date

Next:From: Robert HaasDate: 2011-09-09 15:32:46
Subject: Re: pg_last_xact_insert_timestamp
Previous:From: Simon RiggsDate: 2011-09-09 15:18:57
Subject: Re: unite recovery.conf and postgresql.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group