Prepare for upgrading Trendz Analytics
Stop Trendz Analytics Check if Trendz and database services are stopped.
1
sudo systemctl stop trendz
1
sudo systemctl status trendz
Backup Database
Make a backup of the database before upgrading.
Check PostgreSQL status. It is unnecessary to stop PostgreSQL for the backup.
1
sudo systemctl status postgresql
Make sure you have enough space to place a backup of the database
Check database size
1
sudo -u postgres psql -c "SELECT pg_size_pretty( pg_database_size('trendz') );"
Check free space
1
df -h /
If there is enough free space - make a backup.
1
sudo -Hiu postgres pg_dump trendz > trendz.sql.bak
Check backup file being created.
Upgrading Trendz Analytics to latest 1.15.0 (1.15.0.4)
NOTE:
Prepare for upgrading Trendz Analytics.
NOTE:
If you are using Trendz behind HAProxy, make sure that the paths /trendz/ and /apiTrendz/ are routed to the Trendz backend instead of /trendz and /apiTrendz. NOTE:
Additionally, we highly recommend adding Trendz to the ThingsBoard HAProxy configuration so that Trendz is accessible from the same domain as ThingsBoard.
Trendz Analytics package download
1
wget https://dist.thingsboard.io/trendz-1.15.0.4.rpm
Trendz Analytics service upgrade
- Install latest Trendz Analytics service
1
sudo rpm -Uvh trendz-1.15.0.4.rpm
NOTE: Package installer will ask you to merge your Trendz configuration. It is preferred to use merge option to make sure that all your previous parameters will not be overwritten.
Execute regular upgrade script:
1
sudo /usr/share/trendz/bin/install/upgrade.sh
Start the service
1
sudo service trendz start
Sync Trendz with ThingsBoard
After upgrade, it’s necessary to sync Trendz with ThingsBoard. You can find out how to do it here.