Re: [HACKERS] PostgreSQL, NetBSD and NFS

[Larry Rosenman]

--On Thursday, January 30, 2003 16:02:17 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:

Greg Copeland <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED])

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




---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]