Stand with Ukraine flag
Pricing Try it now
Community Edition
Getting Started Documentation Devices Library Guides
Architecture API FAQ
On this page

Old Upgrade instructions

In order to update to new ThingsBoard releases, please follow these CE and PE instructions

Upgrading to 1.0.3

These steps are applicable for 1.0, 1.0.1 and 1.0.2 ThingsBoard versions.

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.0.3/thingsboard-1.0.3.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.0.3/thingsboard-1.0.3.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-1.0.3.deb
1
sudo rpm -Uvh thingsboard-1.0.3.rpm

Database upgrade

This step is required only if you are upgrading from 1.0 or 1.0.1 versions. Please use following instruction to update your single node instance:

Download upgrade scripts:

1
2
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.0.3/upgrade_1.0_1.0.2.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.0.3/system_widgets_1.0_1.0.2.cql

Launch main script:

1
2
chmod +x upgrade_1.0_1.0.2.sh
./upgrade_1.0_1.0.2.sh

Start the service

1
sudo service thingsboard start

Upgrading to 1.1.0

These steps are applicable for 1.0.3 ThingsBoard version.

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.1/thingsboard-1.1.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.1/thingsboard-1.1.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-1.1.deb
1
sudo rpm -Uvh thingsboard-1.1.rpm

Database upgrade

Please use the following instruction to update your single node instance:

Download upgrade scripts:

1
2
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.1.0/upgrade_1.0.3_1.1.0.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.1.0/system_widgets_1.0.3_1.1.0.cql

Launch main script:

1
2
chmod +x upgrade_1.0.3_1.1.0.sh
./upgrade_1.0.3_1.1.0.sh

Start the service

1
$ sudo service thingsboard start

Upgrading to 1.2.0

These steps are applicable for 1.1.0 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.2/thingsboard-1.2.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.2/thingsboard-1.2.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-1.2.deb
1
sudo rpm -Uvh thingsboard-1.2.rpm

Database upgrade

Download upgrade scripts:

1
2
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.0/upgrade_1.1.0_1.2.0.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.0/system_widgets.cql

Launch main script:

1
2
chmod +x upgrade_1.1.0_1.2.0.sh
./upgrade_1.1.0_1.2.0.sh

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-1.2.zip.

ThingsBoard service upgrade

  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Uninstall the previous version of ThingsBoard service by running uninstall.bat located in ThingsBoard install dir.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>uninstall.bat
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Run install.bat script to install the new version of ThingsBoard as a Windows service.
1
C:\thingsboard>install.bat

Database upgrade

1
upgrade_1.1.0_1.2.0.bat

Start the service

1
net start thingsboard

Upgrading to 1.2.1

These steps are applicable for 1.2.0 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.1/thingsboard-1.2.1.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.1/thingsboard-1.2.1.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-1.2.1.deb
1
sudo rpm -Uvh thingsboard-1.2.1.rpm

Database upgrade

Download upgrade scripts:

1
2
3
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.1/upgrade_1.2.0_1.2.1.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.1/schema_update.cql
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.1/system_widgets.cql

Launch main script:

1
2
chmod +x upgrade_1.2.0_1.2.mqtt-js-telemetry-data-as-object.sh
./upgrade_1.2.0_1.2.mqtt-js-telemetry-data-as-object.sh

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-1.2.1.zip.

ThingsBoard service upgrade

  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Uninstall the previous version of ThingsBoard service by running uninstall.bat located in ThingsBoard install dir.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>uninstall.bat
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Run install.bat script to install the new version of ThingsBoard as a Windows service.
1
C:\thingsboard>install.bat

Database upgrade

1
upgrade_1.2.0_1.2.1.bat

Start the service

1
net start thingsboard

Upgrading to 1.2.2

These steps are applicable for 1.2.1 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.2/thingsboard-1.2.2.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.2/thingsboard-1.2.2.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-1.2.2.deb
1
sudo rpm -Uvh thingsboard-1.2.2.rpm

Database upgrade

Download upgrade scripts:

1
2
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.2/upgrade_1.2.1_1.2.2.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.2/system_widgets.cql

Launch main script:

1
2
chmod +x upgrade_1.2.1_1.2.2.sh
./upgrade_1.2.1_1.2.2.sh

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-1.2.2.zip.

ThingsBoard service upgrade

  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Uninstall the previous version of ThingsBoard service by running uninstall.bat located in ThingsBoard install dir.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>uninstall.bat
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Run install.bat script to install the new version of ThingsBoard as a Windows service.
1
C:\thingsboard>install.bat

Database upgrade

1
upgrade_1.2.1_1.2.2.bat

Start the service

1
net start thingsboard

Upgrading to 1.2.3

These steps are applicable for 1.2.2 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.3/thingsboard-1.2.3.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.2.3/thingsboard-1.2.3.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-1.2.3.deb
1
sudo rpm -Uvh thingsboard-1.2.3.rpm

Database upgrade

Download upgrade scripts:

1
2
3
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.3/upgrade_1.2.2_1.2.3.sh
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.3/schema_update.cql
wget https://raw.githubusercontent.com/thingsboard/thingsboard.github.io/master/docs/user-guide/install/resources/1.2.3/system_widgets.cql

Launch main script:

1
2
chmod +x upgrade_1.2.2_1.2.3.sh
./upgrade_1.2.2_1.2.3.sh

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-1.2.3.zip.

ThingsBoard service upgrade

  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Uninstall the previous version of ThingsBoard service by running uninstall.bat located in ThingsBoard install dir.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>uninstall.bat
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Run install.bat script to install the new version of ThingsBoard as a Windows service.
1
C:\thingsboard>install.bat

Database upgrade

1
upgrade_1.2.2_1.2.3.bat

Start the service

1
net start thingsboard

Upgrading to 1.3.0

These steps are applicable for 1.2.3 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.3/thingsboard-1.3.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.3/thingsboard-1.3.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-1.3.deb
1
sudo rpm -Uvh thingsboard-1.3.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten. Please make sure that you set database.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
database:
    type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Execute upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=1.2.3 

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-1.3.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
  database:
      type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
  • Run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=1.2.3

Start the service

1
net start thingsboard

Upgrading to 1.3.1

These steps are applicable for 1.3.0 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.3.1/thingsboard-1.3.1.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.3.1/thingsboard-1.3.1.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-1.3.1.deb
1
sudo rpm -Uvh thingsboard-1.3.1.rpm

NOTE: Package installer may ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
database:
    type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Execute upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=1.3.0 

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-1.3.1.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
  database:
      type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
  • Run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=1.3.0

Start the service

1
net start thingsboard

Upgrading to 1.4.0

These steps are applicable for 1.3.1 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.4/thingsboard-1.4.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v1.4/thingsboard-1.4.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-1.4.deb
1
sudo rpm -Uvh thingsboard-1.4.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten. Please make sure that you set database.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
database:
    type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Execute upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=1.3.1

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-1.4.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
  database:
      type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
  • Run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=1.3.1

Start the service

1
net start thingsboard

Upgrading to 2.0.0

These steps are applicable for 1.4.0 ThingsBoard version.

Ubuntu/CentOS

info sign

Important note


Please note that during upgrade procedure old rules and plugins will be completely removed from your ThingsBoard instance.

Old rules and plugins functionality is replaced by new rule engine components (rule chains and rule nodes).

If you have configured rules or plugins you need to backup them using export function before performing upgrade. After upgrade you will need to configure new rule chains in order to restore your application logic performed by old rules/plugins.

Please refer to new rule engine documentation for details.

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.0/thingsboard-2.0.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.0/thingsboard-2.0.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-2.0.deb
1
sudo rpm -Uvh thingsboard-2.0.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten. Please make sure that you set database.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
database:
    type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Execute upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=1.4.0 

Start the service

1
sudo service thingsboard start

Windows

info sign

Important note


Please note that during upgrade procedure old rules and plugins will be completely removed from your ThingsBoard instance.

Old rules and plugins functionality is replaced by new rule engine components (rule chains and rule nodes).

If you have configured rules or plugins you need to backup them using export function before performing upgrade. After upgrade you will need to configure new rule chains in order to restore your application logic performed by old rules/plugins.

Please refer to new rule engine documentation for details.

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.0.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
  database:
      type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql
  • Run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=1.4.0

Start the service

1
net start thingsboard

Upgrading to 2.0.1

These steps are applicable for 2.0.0 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.1/thingsboard-2.0.1.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.1/thingsboard-2.0.1.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-2.0.1.deb
1
sudo rpm -Uvh thingsboard-2.0.1.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten. Please make sure that you set database.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
database:
    type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.0.1.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
  database:
      type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Start the service

1
net start thingsboard

Upgrading to 2.0.2

These steps are applicable for 2.0.1 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.2/thingsboard-2.0.2.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.2/thingsboard-2.0.2.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-2.0.2.deb
1
sudo rpm -Uvh thingsboard-2.0.2.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
database:
    type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.0.2.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
  database:
      type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Start the service

1
net start thingsboard

Upgrading to 2.0.3

These steps are applicable for 2.0.2 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.3/thingsboard-2.0.3.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.0.3/thingsboard-2.0.3.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-2.0.3.deb
1
sudo rpm -Uvh thingsboard-2.0.3.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten. Please make sure that you set database.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
database:
    type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.0.3.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
  database:
      type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Start the service

1
net start thingsboard

Upgrading to 2.1.0

These steps are applicable for 2.0.3 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.1/thingsboard-2.1.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.1/thingsboard-2.1.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-2.1.deb
1
sudo rpm -Uvh thingsboard-2.1.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten. Please make sure that you set database.type parameter value (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
database:
    type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.1.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.type parameter value (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
  database:
      type: "${DATABASE_TYPE:cassandra}" # cassandra OR sql

Start the service

1
net start thingsboard

Upgrading to 2.2.0

These steps are applicable for 2.1.0, 2.1.1, 2.1.2 and 2.1.3 ThingsBoard versions.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.2/thingsboard-2.2.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.2/thingsboard-2.2.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-2.2.deb
1
sudo rpm -Uvh thingsboard-2.2.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.entities.type and database.ts.type parameters values (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
3
4
5
    database:
      entities:
        type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
      ts:
        type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)

Execute upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.0.0 

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.2.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.entities.type and database.ts.type parameters values (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
  database:
    entities:
      type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
    ts:
      type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
  • Run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=2.0.0

Start the service

1
net start thingsboard

Upgrading to 2.3.0

These steps are applicable for 2.2.0 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.3/thingsboard-2.3.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.3/thingsboard-2.3.rpm

ThingsBoard service upgrade

1
sudo dpkg -i thingsboard-2.3.deb
1
sudo rpm -Uvh thingsboard-2.3.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.entities.type and database.ts.type parameters values (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
3
4
5
    database:
      entities:
        type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
      ts:
        type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)

Execute upgrade script

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.2.0 

Start the service

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.3.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.entities.type and database.ts.type parameters values (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
  database:
    entities:
      type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
    ts:
      type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
  • Run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=2.2.0

Start the service

1
net start thingsboard

Upgrading to 2.4.0

These steps are applicable for 2.3.1 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.4/thingsboard-2.4.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.4/thingsboard-2.4.rpm

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
1
sudo dpkg -i thingsboard-2.4.deb
1
sudo rpm -Uvh thingsboard-2.4.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.entities.type and database.ts.type parameters values (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
3
4
5
    database:
      entities:
        type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
      ts:
        type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)

Execute upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.3.1 

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.4.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).

  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.entities.type and database.ts.type parameters values (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
  database:
    entities:
      type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
    ts:
      type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
  • Run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=2.3.1

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
net start thingsboard

Upgrading to 2.4.1

These steps are applicable for 2.4.0 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.1/thingsboard-2.4.1.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.1/thingsboard-2.4.1.rpm

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
1
sudo dpkg -i thingsboard-2.4.1.deb
1
sudo rpm -Uvh thingsboard-2.4.1.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.entities.type and database.ts.type parameters values (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
3
4
5
    database:
      entities:
        type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
      ts:
        type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)

Execute upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.4.0 

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.4.1.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.entities.type and database.ts.type parameters values (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
  database:
    entities:
      type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
    ts:
      type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
  • Run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=2.4.0

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
net start thingsboard

Upgrading to 2.4.2.1

These steps are applicable for 2.4.1 and 2.4.2 ThingsBoard versions.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.2.1/thingsboard-2.4.2.1.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.2.1/thingsboard-2.4.2.1.rpm

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
1
sudo dpkg -i thingsboard-2.4.2.1.deb
1
sudo rpm -Uvh thingsboard-2.4.2.1.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.entities.type and database.ts.type parameters values (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
3
4
5
    database:
      entities:
        type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
      ts:
        type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)

Execute upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.4.1 

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.4.2.1.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.entities.type and database.ts.type parameters values (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
  database:
    entities:
      type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
    ts:
      type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
  • Run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=2.4.1

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
net start thingsboard

Upgrading to 2.4.3

These steps are applicable for 2.4.2 and 2.4.2.1 ThingsBoard versions.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.3/thingsboard-2.4.3.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.4.3/thingsboard-2.4.3.rpm

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
1
sudo dpkg -i thingsboard-2.4.3.deb
1
sudo rpm -Uvh thingsboard-2.4.3.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.entities.type and database.ts.type parameters values (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
3
4
5
    database:
      entities:
        type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
      ts:
        type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)

Execute upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.4.2

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.4.3.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).

  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please make sure that you set database.entities.type and database.ts.type parameters values (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
  database:
    entities:
      type: "${DATABASE_ENTITIES_TYPE:cassandra}" # cassandra OR sql
    ts:
      type: "${DATABASE_TS_TYPE:cassandra}" # cassandra OR sql (for hybrid mode, only this value should be cassandra)
  • Run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=2.4.2

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
net start thingsboard

Upgrading to 2.5

These steps are applicable for 2.4.3 ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5/thingsboard-2.5.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5/thingsboard-2.5.rpm

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
1
sudo dpkg -i thingsboard-2.5.deb
1
sudo rpm -Uvh thingsboard-2.5.rpm

NOTE: Upgrading ThingsBoard from 2.4.3 to 2.5 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.

Please refer to the guides below that will describe how to upgrade your PostgreSQL service on:

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Please make sure that you set database.entities.type and database.ts.type parameters values (in the file /etc/thingsboard/conf/thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:

1
2
3
4
5
6
7
8
  database:
    ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
    entities:
      type: "${DATABASE_ENTITIES_TYPE:sql}" # cassandra OR sql
    ts:
      type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
  
  # note: timescale works only with postgreSQL database for DATABASE_ENTITIES_TYPE.

NOTE: If you are using PostgreSql(Sql) for time-series data storage before executing the upgrade script, go to the PostgreSQL terminal(psql) and follow the instructions below:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
  # Connect to thingsboard database:
  \c thingsboard
  
  # Execute the next commands:
  
  # Update ts_kv table constraints:
  ALTER TABLE ts_kv DROP CONSTRAINT IF EXISTS ts_kv_unq_key;
  ALTER TABLE ts_kv DROP CONSTRAINT IF EXISTS ts_kv_pkey;
  ALTER TABLE ts_kv ADD CONSTRAINT ts_kv_pkey PRIMARY KEY (entity_type, entity_id, key, ts);
  
  # Update ts_kv_latest table constraints:
  ALTER TABLE ts_kv_latest DROP CONSTRAINT IF EXISTS ts_kv_latest_unq_key;
  ALTER TABLE ts_kv_latest DROP CONSTRAINT IF EXISTS ts_kv_latest_pkey;
  ALTER TABLE ts_kv_latest ADD CONSTRAINT ts_kv_latest_pkey PRIMARY KEY (entity_type, entity_id, key);
  
  # exit psql terminal 
  \q

Finally, execute upgrade script:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.4.3

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please note that upgrading ThingsBoard from 2.4.3 to 2.5 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.
  • Please make sure that you set database.entities.type and database.ts.type parameters values (in the file <ThingsBoard install dir>\conf\thingsboard.yml) to “cassandra” instead of “sql” in order to upgrade your cassandra database:
1
2
3
4
5
6
7
8
  database:
    ts_max_intervals: "${DATABASE_TS_MAX_INTERVALS:700}" # Max number of DB queries generated by single API call to fetch telemetry records
    entities:
      type: "${DATABASE_ENTITIES_TYPE:sql}" # cassandra OR sql
    ts:
      type: "${DATABASE_TS_TYPE:sql}" # cassandra, sql, or timescale (for hybrid mode, DATABASE_TS_TYPE value should be cassandra, or timescale)
  
  # note: timescale works only with postgreSQL database for DATABASE_ENTITIES_TYPE.

NOTE: If you are using PostgreSql(Sql) for time-series data storage before executing the upgrade script, you need to access the psql terminal. Once you will be logged to the psql terminal, please follow the instructions below:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
  # Connect to thingsboard database:
  \c thingsboard
  
  # Execute the next commands:
  
  # Update ts_kv table constraints:
  ALTER TABLE ts_kv DROP CONSTRAINT IF EXISTS ts_kv_unq_key;
  ALTER TABLE ts_kv DROP CONSTRAINT IF EXISTS ts_kv_pkey;
  ALTER TABLE ts_kv ADD CONSTRAINT ts_kv_pkey PRIMARY KEY (entity_type, entity_id, key, ts);
  
  # Update ts_kv_latest table constraints:
  ALTER TABLE ts_kv_latest DROP CONSTRAINT IF EXISTS ts_kv_latest_unq_key;
  ALTER TABLE ts_kv_latest DROP CONSTRAINT IF EXISTS ts_kv_latest_pkey;
  ALTER TABLE ts_kv_latest ADD CONSTRAINT ts_kv_latest_pkey PRIMARY KEY (entity_type, entity_id, key);
  
  # exit psql terminal 
  \q
  • Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=2.4.3

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
net start thingsboard

Upgrading to 2.5.1

These steps are applicable for 2.4.3+ ThingsBoard version.

Ubuntu/CentOS

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.1/thingsboard-2.5.1.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.1/thingsboard-2.5.1.rpm

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
1
sudo dpkg -i thingsboard-2.5.1.deb
1
sudo rpm -Uvh thingsboard-2.5.1.rpm

NOTE: Upgrading ThingsBoard to 2.5.1 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.

Please refer to the guides below that will describe how to upgrade your PostgreSQL service on:

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.

Finally, execute upgrade script and specify your previous ThingsBoard version:

1
sudo /usr/share/thingsboard/bin/install/upgrade.sh --fromVersion=2.4.3

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Windows

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.1.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please note that upgrading ThingsBoard from 2.4.3 to 2.5 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.

  • Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=2.4.3

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
net start thingsboard

Upgrading to 2.5.2

Ubuntu/CentOS

NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.1. In order to upgrade to 2.5.2 you need to upgrade to 2.5.1 first.

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.2/thingsboard-2.5.2.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.2/thingsboard-2.5.2.rpm

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
1
sudo dpkg -i thingsboard-2.5.2.deb
1
sudo rpm -Uvh thingsboard-2.5.2.rpm

NOTE: Upgrading ThingsBoard to 2.5.2 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.

Please refer to the guides below that will describe how to upgrade your PostgreSQL service on:

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Windows

NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.1. In order to upgrade to 2.5.2 you need to upgrade to 2.5.1 first.

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.2.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).

  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.
  • Please note that upgrading ThingsBoard from 2.4.3 to 2.5 version in case of using PostgreSQL database require to upgrade the PostgreSQL service to 11.x version.

  • Finally, run upgrade.bat script to upgrade ThingsBoard to the new version.

NOTE Scripts listed above should be executed using Administrator Role.

1
C:\thingsboard>upgrade.bat --fromVersion=2.4.3

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
net start thingsboard

Upgrading to 2.5.3

Ubuntu/CentOS

NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.2. In order to upgrade to 2.5.3 you need to upgrade to 2.5.2 first.

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.3/thingsboard-2.5.3.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.3/thingsboard-2.5.3.rpm

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
1
sudo dpkg -i thingsboard-2.5.3.deb
1
sudo rpm -Uvh thingsboard-2.5.3.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Windows

NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.2. In order to upgrade to 2.5.3 you need to upgrade to 2.5.2 first.

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.3.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).

  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
net start thingsboard

Upgrading to 2.5.4

Ubuntu/CentOS

NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.3. In order to upgrade to 2.5.4 you need to upgrade to 2.5.3 first.

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.4/thingsboard-2.5.4.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.4/thingsboard-2.5.4.rpm

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
1
sudo dpkg -i thingsboard-2.5.4.deb
1
sudo rpm -Uvh thingsboard-2.5.4.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Windows

NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.3. In order to upgrade to 2.5.4 you need to upgrade to 2.5.3 first.

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.4.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).

  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
net start thingsboard

Upgrading to 2.5.5

Ubuntu/CentOS

NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.4. In order to upgrade to 2.5.5 you need to upgrade to 2.5.4 first.

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.5/thingsboard-2.5.5.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.5/thingsboard-2.5.5.rpm

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
1
sudo dpkg -i thingsboard-2.5.5.deb
1
sudo rpm -Uvh thingsboard-2.5.5.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Windows

NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.4. In order to upgrade to 2.5.5 you need to upgrade to 2.5.4 first.

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.5.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).
  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
net start thingsboard

Upgrading to 2.5.6

Ubuntu/CentOS

NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.5. In order to upgrade to 2.5.6 you need to upgrade to 2.5.5 first.

ThingsBoard package download

1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.6/thingsboard-2.5.6.deb
1
wget https://github.com/thingsboard/thingsboard/releases/download/v2.5.6/thingsboard-2.5.6.rpm

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
$ sudo service thingsboard stop
1
sudo dpkg -i thingsboard-2.5.6.deb
1
sudo rpm -Uvh thingsboard-2.5.6.rpm

NOTE: Package installer will ask you to merge your thingsboard configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
sudo service thingsboard start

Windows

NOTE: These upgrade steps are applicable for ThingsBoard version 2.5.5. In order to upgrade to 2.5.6 you need to upgrade to 2.5.5 first.

ThingsBoard package download

Download ThingsBoard installation archive for Windows: thingsboard-windows-2.5.6.zip.

ThingsBoard service upgrade

  • Stop ThingsBoard service if it is running.
1
net stop thingsboard
  • Make a backup of previous ThingsBoard configuration located in <ThingsBoard install dir>\conf (for ex. C:\thingsboard\conf).

  • Remove ThingsBoard install dir.
  • Unzip installation archive to ThingsBoard install dir.
  • Compare your old ThingsBoard configuration files (from the backup you made in the first step) with new ones.

Start the service

Doc info icon

If you use Redis for caching, you need to flush all stored keys before starting the ThingsBoard.

Connect to your Redis instance (or container/pod, depending on your setup) and run the command:

redis-cli flushall

Please note that this command is applicable only if you use Redis exclusively for ThingsBoard. If other applications use Redis, you need to locate the ThingsBoard database and flush only that. The default database index is 0, configurable with REDIS_DB ThingsBoard environment value.

redis-cli

select 0

flushdb

1
net start thingsboard

Next steps