Setup for Remote Database Access
To work with an Ingres database stored on another computer, the computer on which you are entering commands and the computer that contains the database must be connected by a network. (The computer on which you are entering commands is called the local node and the computer that contains the database is called the remote node.)
To work on an Ingres database on a remote node, the following setup is required:
• Ingres Net must be installed on your local node and on each remote node.
• Either you or the system administrator must use the netutil or ingnet utility to define each remote node that contains a database that you want to access. Defining a remote node gives it a vnode (virtual) name. From then on, you need only specify the vnode name of the remote node and the name of the database. Net handles the details of gaining access to the remote node.
• Ingres Star users must be authorized on the local node as well as each remote node they wish to access, unless installation passwords are used. This authorization is also done through the netutil or ingnet utility. Use netutil or ingnet on your local node to define your login authorization to your account on the remote node. (Alternatively, the system administrator must define your access to a public guest account on that remote node).
Note: You need to define authorization to your account on a remote node only once. Your authorization remains until you delete it.
Note: If installation passwords are used, the installation password of a remote node must be entered with netutil or ingnet.