Path: utzoo!attcan!uunet!know!sdd.hp.com!wuarchive!rex!ukma!husc6!spdcc!dyer
From: dyer@spdcc.COM (Steve Dyer)
Newsgroups: comp.databases
Subject: Ingres and NFS
Message-ID: <4691@spdcc.SPDCC.COM>
Date: 29 Oct 90 17:17:17 GMT
Reply-To: dyer@ursa-major.spdcc.com (Steve Dyer)
Organization: S.P. Dyer Computer Consulting, Cambridge MA
Lines: 29

I'm sorry this question is on such a primitive level, but
it reflects the primitive nature of the information which
has percolated back to me, none of which I've heard told by
anyone who might really know what is going on.  (I also don't
read comp.databases regularly, so I don't know if this has been
discussed before.)

I've heard that Ingres rel 6 "doesn't work" on NFS.  I'd like
to get a better restatement or a refutation of the problem. 

I'm not intimately familiar with the innards of Ingres,
but I would assume that this might refer to the need for
a local raw device to hold the log file.  Also, too, it would
seem obvious that two Ingres instances running on different
machines but on the same database thru NFS won't work (at least
without lots of external support added into the Ingres code for
serialization and coordination.)  But it isn't obvious to me
that just having the databases placed in a directory on a NFS
mounted filesystem managed by a single Ingres instance would
not work, as long as you has a local raw device for the log.
(Yes, there are issues of speed.  I'm discounting that for now...)
 
Can anyone who might know about this or have tried it comment?
Thanks.

-- 
Steve Dyer
dyer@ursa-major.spdcc.com aka {ima,harvard,rayssd,linus,m2c}!spdcc!dyer
dyer@arktouros.mit.edu, dyer@hstbme.mit.edu