Question Hello,
Is it possible to copy an Ingres intallation from one pc to another?. Let say, I have an Ingres server and i am going to create same server with same database, user & role in a different machine.
I tried unloaddb to unload iidbdb and iidatabase but it did'nt work. I believe I am missing someting.
Thanks.
Cheers,
JB
Answer Hello,
It is not a good idea at all to unload/reload iidbdb. You must start from an empty Ingres installation and transfert the following (both mean the old and the new server) :
1/ your parameters : analyse both ingprenv, config.dat and protect.dat
2/ take care of particulars configuration files such as (see in $II_SYSTEM/ingres/files) *.def, *.map, termcap (this list is not complete, there are many cases and files to transfert, depend on you configuration)
3/ users configuration : via accessdb you can make a sql script (from source server) and run it on the target installation with : sql iidbdb < users.sql. Take care to create by hand your groups if you have some, this script did not concern them
4/ create all your Ingres locations in the target installation. You must have same location name and number from both side, and did not care about path of locations. The number of locations you use depend on the databases on those locations. Check infodb on all your source DB to see a complete list and usage (data, work, checkpoint, journal and dump)
5/ create and extend all your databases (empty)
6/ on the source machine, unloaddb them
7/ on the target machine, reload them
8/ if you have applications (Report Writer, Frames (vifred) ABF or OpenROAD), prefer the exportapp/importapp method. Otherwise you might have stability issues)
9/ Don't forget your Ingres/Net configuration (see netutil)
A method to make a real clone can be :
Source machine
1/ ingstop
2/ archive II_SYSTEM directory and all concerned directory
Target machine
1/ copy and extract the archive on the source machine (in the same directory exactly)
2/ In the $II_SYSTEM/ingres/files/config.dat and protect.dat replace the old machine name by the new one
3/ ingsetenv II_GCNxx_LCL_VNODE new_machine_name (where xx depend on the value of II_INSTALLATION)
4/ In the $II_SYSTEM/ingres/files/name directory, all the files have the machine name in their name. Rename all files with new machine name
5/ ingstart
and you might have a real clone of your original installation.
Take care to have the same OS flavour and version (patches included) on both systems.
