Chris Miles wrote: > On Thu, Oct 10, 2002 at 10:09:55AM -0400, Bruce Momjian wrote: > > We also don't recommend NFS directories because the NFS file behavior is > > not 100% the same as a local file system. > > Can you comment on what the incompatabities are? (related to PostgreSQL > only). > > We currently run PostgreSQL on Linux servers with the data on dedicated > Netapp filers over NFS. We have had no problems so far and performance > is very acceptable. > > If there is something I need to watch out for, I would like to know.
Good question. It is my understanding that fsync, locking, and the order of writes is not guaranteed in NFS like it is for local file systems. I question how well it would handle any of the failure modes that local file systems can withstand. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster