[comp.databases] ingres files on a remotely mounted file system

theisen@vms.macc.wisc.edu (Barbara Theisen) (12/21/89)

We would like to install Ingres (current version) on a Decstation 3100 with
a *small* hard drive.  THis particluar Decstation (along with several others)
would be on a network with a large file server, running NFS.  We would 
like to install the Ingres files, as well as the data files in a remotely
mounted file system.  Is this technically feasible?  Has anyone done it?
Note that we do not want to run Ingres on the file server, nor do we want 
to run Ingres/Net (which entails running on the server anyway).  We only
want the Ingres files, ie everything that you need to install, plus the data
files, application files, etc, to be located in a file system that 
happens to exist on a different machine.  

If this ability is not in the current version, does anyone *know* if it
will be available *soon*.  (It is my understanding that the 6.n version
of Ingres under Ultrix is about to ship any day, and I'd rather know
about that version).

Thanks for the help.

                         Barbara Theisen

jeffl@sybase.Sybase.COM (Jeff Lichtman) (12/24/89)

> We would 
> like to install the Ingres files, as well as the data files in a remotely
> mounted file system.  Is this technically feasible?

This would be slow even if feasible.  You would be going across the network
for database reads and writes.  Do you want to pay that kind of performance
penalty?

BTW, I'm not saying it's unfeasible.  I believe it can be done rather easily
using Ingres.  I just don't think it's a good idea.
---
Jeff Lichtman at Sybase
{mtxinu,pacbell}!sybase!jeffl  -or- jeffl@sybase.com
"Saints should always be judged guilty until they are proved innocent..."