Subject: Re: [HACKERS] PostgreSQL, NetBSD and NFS
To: Tom Lane <tgl@sss.pgh.pa.us>
From: Larry Rosenman <ler@lerctr.org>
List: current-users
Date: 01/30/2003 16:40:09
--On Thursday, January 30, 2003 16:02:17 -0500 Tom Lane <tgl@sss.pgh.pa.us> 
wrote:

> Greg Copeland <greg@CopelandConsulting.Net> writes:
>> That was going to be my question too.
>> I thought NFS didn't have some of the requisite file system behaviors
>> (locking, flushing, etc. IIRC) for PostgreSQL to function correctly or
>> reliably.
>
> Whether the thing is trustworthy is a different issue ;-).  I was just
> surprised that it didn't seem to work at all.
>
> In practice, if the NFS server never goes down then you probably haven't
> got a problem.  I'm not sure you could count on the database not getting
> scrambled if the NFS server crashes.  But that wasn't the question...
FWIW I use a netapp filer for my databases here for traffic analysis and IP 
management.

The NETAPP has battery backed NVRAM and will replay the right stuff on it's 
own.

Just another datapoint.

LER

>
> 			regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749