multiple installation of ingres

[omaro_ing]

Hi,

I want to install ingres2006 ver 9.0.4 with multiple instance, but with different userID,

exemple


Instance1 with user ingres1

instance2 with user ingres2



instanceN with user ingresN

ihave package installation with RPM.

thanks.

[rhann]

I'm not totally clear on what you are asking to do. Do you want each instance to have a different owner for some reason?

I never use RPM to install, but I can't see why it wouldn't let you create another installation (instance) with a different owner. It would insist that each instance have a different connection identifier (listen address) though, e.g. II, IJ, IK, etc.

Without knowing what you want this kind of arrangement for, I can't say if it's a good idea or not, but it can certainly be done, somehow.

[omaro_ing]

hi,

the first reason of this orgnazaition is to separate authorization of administration for all instance.

thanks

[rhann]

OK, as I said, you can have multiple intstallations/instances each with a different owner, which is not to say the RPM installer will make it easy for you to do that--I don't use it so I don't know. But it is definitely possible.

I still have a nagging thought that there may be an easier way to accomplish what you want. When you say "separate adminstration" of each instance, what do you include in that term? Physical resources like disk and memory, and starting and stopping Ingres, or do you include grants and table/view/procedure ownership, or what?

[maspa05]

With the rpm installer it's possible to specify an response file by setting the II_RESPONSE_FILE environment variable. To specify the user to install as set the II_USERID parameter in this file e.g.

II_USERID=ingres1

See the Installation Guide (here) for more on the response file.

[omaro_ing]

Hi,

i am used the technique of custom installation,
i created a file configuration that contain this parameters

II_USERID=name of admin
II_GROUPID=group if admin


2. I Specifed the name of the response file on the II_RESPONSE_FILE environment variable.
export II_RESPONSE_FILE="name of response file"

3. I Installed the RPM packages by invoking RPM directly.



i used this document : ingres2006 for linux Getting Started

thanks (rahann, maspa05).