![](/uploads/1/2/7/3/127342314/167989138.png)
ThingsBoard team recommends to use PostgreSQL for development and production environments with reasonable load (. ThingsBoard team recommends to use Hybrid database approach if you do plan to have 1M+ devices in production or high data ingestion rate ( 5000 msg/sec).
In this case, ThingsBoard will be storing timeseries data in Cassandra while continue to use PostgreSQL for main entities (devices/assets/dashboards/customers). PostgreSQL InstallationDownload the installation file (PostgreSQL 9.6+ or newer releases) and follow the installation instructions.During PostgreSQL installation, you will be prompted for superuser (postgres) password.Don’t forget this password. It will be used later. For simplicity, we will substitute it with “postgres”.
Create ThingsBoard DatabaseOnce installed, launch the “pgAdmin” software and login as superuser (postgres).Open your server and create database “thingsboard” with owner “postgres”. Cassandra InstallationInstructions listed below will help you to install Cassandra. Download DataStax Community Edition v3.0.9. Run downloaded MSI package. Xms256m -Xmx256m Step 5. Run installation scriptLaunch windows shell (Command Prompt) as Administrator. Change directory to your ThingsBoard installation directory.Execute install.bat script to install ThingsBoard as a Windows service (or run “install.bat –loadDemo” to install and add demo data).This means it will be automatically started on system startup.Similar, uninstall.bat will remove ThingsBoard from Windows services.The output should be similar to this one.
Aug 23, 2018 HYDROCOR by Shell Global Soultions. Versions: 6.0. File name: HYDROCOR.exe.
YYYY-MM-DD HH:mm:ss,sss main INFO o.t.s.ThingsboardServerApplication - Started ThingsboardServerApplication in x.xxx seconds (JVM running for x.xxx)In case of any unclear errors, use general. Windows firewall settingsIn order to have external access to ThingsBoard Web UI and device connectivity (HTTP, MQTT, CoAP)you need to create a new inbound rule with Windows Firewall with Advanced Security. Open “Windows Firewall” from “Control Panel”:. Click “Advanced settings” on the left panel:. Select “Inbound Rules” on the left panel, then click “New Rule” on the right “Actions” panel:. Now new “New Inbound Rule Wizard” window will open. On the first step “Rule Type” select “Port” option:.
On the “Protocol and Ports” step select “TCP” protocol and enter port list 8080, 1883, 5683 in the “Specific local ports” field:. On the “Action” step leave “Allow the connection” option selected:. On the “Profile” step select Windows network profiles when to apply this rule:. Finally, give the name to this rule (for ex. “ThingsBoard Service Networking”) and click “Finish”.Next steps.- These guides provide quick overview of main ThingsBoard features.
Designed to be completed in 15-30 minutes.- Learn how to connect devices based on your connectivity technology or solution.- These guides contain instructions how to configure complex ThingsBoard dashboards.- Learn how to use ThingsBoard Rule Engine.- Learn how to use rule engine to perform basic analytics tasks.- Learn how to connect various hardware platforms to ThingsBoard.- Learn about advanced ThingsBoard features.- Learn about contribution and development in ThingsBoard.
![](/uploads/1/2/7/3/127342314/167989138.png)