← Directory

thingsboard-postgres

ThingsBoard is an open-source IoT platform for data collection, processing, visualization, and device management.

  • Home Automation
  • Network Services
  • Tools & Utilities
ThingsBoard is an open-source IoT platform for data collection, processing, visualization, and device management. Default Creds: System Administrator: [email protected] / sysadmin Tenant Administrator: [email protected] / tenant Customer User: [email protected] / customer Initial setup: Run the container once so it creates the directories, it won't start due to permission issues, stop it Run "chown -R 799:799 /mnt/user/appdata/thingsboard-postgres" (adapt as appropriate if you changed defaults) in Unraid terminal Start container again, it should now be good after a couple of minutes needed for initial setup.

Platform availability

Available on 2 of 6 install platforms

  • Unraid
  • TrueNAS (not listed)
  • Umbrel (not listed)
  • ZimaOS (not listed)
  • Proxmox
  • Helm (not listed)

Also on Docker Hub

Health score

54/100 Fair

Maintained
No data
Popular
No data
Easy to install
351 install platform, install notes, Docker image
Light to run
801 GB minimum RAM, runs on ARM

Based on 2 of 4 factors.

How is this calculated?

A 0-100 score computed nightly from four factors: maintained (40%: recent commits and steady activity), popular (25%: GitHub stars, log scale), easy to install (20%: platforms, install notes, setup guides, Docker image) and light to run (15%: minimum RAM, ARM support). Factors without data are left out and the rest are rescaled.

Availability: platform listings confirmed today, links checked 9 days ago

No GitHub repository data collected yet.

Resources & Compatibility

Minimum requirements: 1 GB RAM. ARM (e.g. Raspberry Pi) is supported.

Checked 10 days ago - source: Docker Hub image tags and published docs

First-install notes

  • Install PostgreSQL 16 and initialize it On CentOS, disable the older PostgreSQL module first, install PostgreSQL 16, the database ThingsBoard uses, and run initdb to create the empty database files; without the right version and initialized database, ThingsBoard can't save data. source
  • Make PostgreSQL start after reboot Enable the postgresql-16 service (the background program that keeps the database running) so the database comes back automatically after a reboot; otherwise ThingsBoard may work at first but fail after the machine restarts. source
  • Install PostgreSQL 16 on Ubuntu On Ubuntu, add the PostgreSQL repository (where Ubuntu downloads PostgreSQL from), install PostgreSQL 16, and start the service so the database is ready before installing ThingsBoard; if the database isn't running, ThingsBoard can't save or load its data. source

Fetched 10 days ago - each note links to its source

Alternatives (7)

  • Firebird - Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms.
  • Microsoft SQL Server - SQL Server delivers on Microsoft’s Data Platform vision by helping your organization manage your data by enabling you to store data from st…
  • MongoDB - MongoDB is a cross-platform, open-source document-oriented NoSQL database that stores data in flexible, JSON-like BSON documents instead of…
  • MySQL Community Edition - Free GPL database platform supporting SQL and NoSQL applications with InnoDB storage, replication, clustering, connectors, and cross-platfo…
  • SQLite - SQLite is a compact, built-in filing system for your data.
  • SurrealDB - SurrealDB is a modern "all-in-one" database that stores and organises your app's information.
  • postgres - PostgreSQL is an advanced open-source relational database management system that stores structured data in tables and serves it to applicat…

Checked 7 days ago - source: AlternativeTo

Common questions

Does the thingsboard/tb-postgres container include a psql client?

Only what was installed by the image maintainer is available inside the container, so a psql client is not guaranteed.

Can ThingsBoard be pointed at an external RDS PostgreSQL instead of the local tb-postgres container?

Yes, the tb-postgres image is normally local, but connection parameters in your .yml or .env files can point to RDS. Verify the host can reach RDS.

How can I make the PostgreSQL database start automatically after reboot during a ThingsBoard edge install?

Enable the postgresql-16 service on CentOS. If it is not enabled, ThingsBoard may work at first but fail after the machine restarts.

Does the ThingsBoard troubleshooting documentation cover OAuth2 configuration?

Yes, OAuth2 configuration is listed among common issues to diagnose and resolve.

Answers sourced from forums.docker.com, github.com, github.com, thingsboard.io

Community

Collected 5 days ago - public community threads