Prerequisites for using IngresSync
Following are the prerequisites for using IngresSync:
1. JRE 1.8 must be installed on both the source and target nodes.
2. The source and target instances must have the same Ingres version at the patch level. IngresSync will give an error if run against a different major version.
For example: “ERROR: supported database version, II 12.0, does not match actual version, II 11.2"
. cat $II_SYSTEM/ingres/version.rel
3. The source and target instances must have the same installation identifier.
ingprenv | grep II_INSTALLATION
4. The source and target instances must have the same Ingres users.
sql iidbdb
select name from iiuser
5. The source and target databases must have journal checkpoints to ensure appropriate directory structures and file permissions are in place.
6. The source and target databases must have the same name and owner.
sql iidbdb
select name,own from iidatabase
7. The source and target databases must have identical locations, both location names and underlying filesystem path.
infodb <dbname>
8. IngresSync must be executed as the installation owner.
9. Passwordless SSH must be configured from source to target and target to source.
10. Private netutil vnode entries must be configured from source to target and target to source. The vnode names are in the following format:
<nodename>_sync
Last modified date: 08/14/2024