System Administrator Guide > System Administrator Guide > Understanding IngresSync > Prerequisites for using IngresSync > Using IngresSync on Windows
Was this helpful?
Using IngresSync on Windows
Cygwin must be installed to support IngresSync on Windows. When you install Cygwin to support IngresSync on Windows the following packages are required:
Package
Commands
bash
cd
coreutils
cp, echo, ls, mv, rm, sum, tail, uname
openssh
ssh, ssh server
rsync
rsync
Note:  Ensure these packages are installed as part of Cygwin on both the source and target machines.
Setting up the SSH server on the Target Machine(s)
The SSH server service needs to be set up on the target machine(s).
To set up the SSH server on the target machine(s)
1. Open a Cygwin terminal as the Ingres instance owner user (usually ingres).
2. Run the ssh-host-config command.
3. The user is prompted to install SSHD as a service. Select “yes”.
Note:  In most cases the defaults can be accepted. Recommend saying "no" to StrictModes. Enter "binmode ntsec" for CYGWIN
4. Start Cygwin as a service.
5. After the service is installed change the "log on" entry in the services control panel for "CYGWIN sshd" to instance owner. To do this, you must enter the password (refer to Cygwin documentation for more on setting up cygwin ssh)
Setting up Passwordless SSH
Passwordless SSH connection must be established between the source nodes and target nodes.
To setup the passwordless SSH connection:
1. Open a Cygwin terminal as the instance owner (Ingres).
2. Run this command to generate the Cygwin password file.
- run "mkpasswd -l > /etc/passwd"
3. Edit the password file.
- edit /etc/passwd
 
 
 
ingres:*:197630:197121:U-WINDOWSPC\ingres,S-1-5-21-2391004429-
2486575630-1775960032-1022:/home/ingres:/bin/bash
where "WINDOWSPC" is the hostname of the Windows machine. Change the first field from
"ingres"
ingres:*:197630:197121:U-WINDOWSPC\ingres,S-1-5-21-2391004429-2486575630-1775960032-1022:/home/ingres:/bin/bash
Follow these steps on both the source and target nodes.
Set up the "passwordless" SSH by creating a key with no passphrase and copy the key to the target machine. The environment variables for the target instance, II_SYSTEM, PATH must be set in the system settings on the target machine. This is an option when you install Ingres.
IngresSync commands must be run from the "Ingres Administrator Command Prompt” or equivalent.
 
Last modified date: 08/29/2024