Upgrade DryvIQ | SQL Server Not Installed on C:/
Summary
This documentation applies to both DryvIQ Managers and Remote Sites, as well as, clustered and non-clustered installations.
For non-clustered installations, follow the steps for the primary node only.
If the install directory was changed from the default during the original install, you must follow Option 2 below
Verify Current Version Installed
In Powershell, run the following command to see what version is currently installed prior to upgrading
C:\Program Files\SkySync> .\skysync.exe --version
Step 1: Stop the DryvIQ service on secondary nodes followed by the primary node
For a Windows installation, while the installer will detect if the service is running and stop it, there may be side effects to other running nodes in a clustered environment as the primary node is upgraded. Therefore, we recommend that DryvIQ services on all secondary nodes followed by the primary node are stopped before proceeding with the upgrade.
Step 2: Run the installation executable on the primary node
The installer will detect if there is an existing DryvIQ installation and the version that is currently installed. As long as the currently installed version is older than the version being installed, the installer will continue as an upgrade.
There are two primary options when upgrading. By default the installer will attempt to upgrade the configured database.
Ensure your command is for the LATEST/UPGRADE version, not the currently installed version.
.\skysync-windows-{{upgrade-version}}.exe --install-pgsql 0
Option 1: Default with Database Upgrade
Use this option if your original install used the default install configuration directory
- By default the installer will attempt to upgrade the configured database.
.\skysync-windows-{{upgrade-version}}.exe --install-pgsql 0
Option 2 | Important Information:
- This option should only be used in special circumstances such as the install directory is not located on the C drive
- Make sure ALL cluster services are stopped, including the primary node that was just upgraded, before doing the database update step
Option 2: Separate Software and Database Upgrade
Ensure the installer is located in the same directory as your original install
.\skysync-windows-{{upgrade-version}}.exe --install-pgsql 0 --skip-dbupdate 1
Once the installer successfully completes, make sure ALL cluster services are stopped, including the primary node that was just upgraded, before doing the database update step
Navigate to the installation directory in a command window and run the following command:
.\skysync.exe db update
Step 3: Run the installation executable on secondary nodes
Since the database was upgraded as part of the primary node upgrade, that portion of the upgrade can be skipped for secondary nodes. Run the following command on the remaining secondary nodes.
.\skysync-windows-{{upgrade-version}}.exe --install-pgsql 0 --skip-dbupdate 1
Step 4: Ensure the DryvIQ services on the primary node has started. Then verify secondary nodes
Verify the services are running DryvIQ on the primary node first; start if needed. Then verify the DryvIQ services are running on the secondary nodes.
Verify Upgraded Version Installed
In Powershell, run the following command to see what version is currently installed prior to upgrading
C:\Program Files\SkySync> .\skysync.exe --version