Manual Upgrade

If the upgrade cannot be performed with the installation package, it is possible to upgrade Squore manually.

Before proceeding with the upgrade:

  1. Create a backup of your current Squore installation.

  2. Create a backup of your configuration files.

  3. Install a fresh Squore, from scratch, in the version you wish to upgrade to.

Any of the manual upgrade procedures described below will not keep your configuration changes such as LDAP, HTTPS or JAVA XMX parameter. Be sure to report manually all these changes afterward.

Here is a list of configuration files that are usually modified:

  • <SQUORE_HOME>/config.xml

  • <SQUORE_HOME>/server/bin/standalone.conf

  • <SQUORE_HOME>/server/standalone/configuration/standalone.xml

  • <CLUSTER_DIR>/postgresql.conf

Database backup and restore

This procedure requires only a few steps, the drawback is that for databases with high volumes restore time can be long.

  1. Stop Squore :

    <SQUORE_HOME>/bin/sqctl stop

  2. Start database :

    <SQUORE_HOME>/bin/sqctl start postgresql

  3. Restore your backup : refer to the Restoring Squore Data section.

    If you are using a remote database, backup and restore operations cannot be done automatically and are of the database administrator responsibility.

  4. Upgrade your database, where version is the Squore version the restored backup is coming from:

    <SQUORE_HOME>/bin/sqadm upgrade-data version

    sqadm upgrade-data command runs silently. It can take from a few minutes to a few hours, depending on the amount of data to migrate, the version you are coming from and your hardware performances.

Database directory replacement

This procedure is mainly oriented to users migrating from Windows installations prior to Squore 26 (i.e., installed via an MSI installer) . However, it can be particularly useful for large databases since it bypasses the restore operation by keeping the already existing database directory.

Works only if you are coming from Squore 24 and on.

  1. Stop Squore server from Windows Services.

  2. Uninstall Squore via Control Panel > Change or uninstall a program.

  3. Select Squore and choose "Modify". The wizard will guide you through the uninstalling.

  4. When reaching the page Select Squore data to remove choose none or uncheck all the cases if any is checked by default. Once the installation has finished, only <SQUORE_DATA> directory remains.

  5. Extract the Squore installation package in the parent directory of <SQUORE_DATA>.

  6. Rename <SQUORE_DATA> (ex: from "squore-data" to "squore-data_old").

  7. Install Squore by executing command:

    <SQUORE_HOME>\bin\start.bat ..\..\<SQUORE_DATA>

    Make sure to input the same name and path as before renaming. If <SQUORE_DATA> directory is not specified when running start-db.bat, then <SQUORE_DATA> will be created inside <SQUORE_HOME> and all the related paths will be propagated throughout the configuration files (config.xml, standalone.xml, etc).

  8. Stop the Squore server:

    <SQUORE_HOME>\bin\stop.bat

  9. Replace the freshly installed <SQUORE_DATA> folder with the old one, using the same name as in the installation.

  10. Start the database:

    <SQUORE_HOME>\bin\start-db.bat

  11. Upgrade your database, where version is the Squore version the restored backup is coming from:

    <SQUORE_HOME>\bin\sqadm upgrade-data version

    sqadm upgrade-data command runs silently. It can take from a few minutes to a few hours, depending on the amount of data to migrate, the version you are coming from and your hardware performances.

  12. Start the Squore server:

    <SQUORE_HOME>\bin\start.bat