TimescaleDB

A Postgres extension for time series databases. May be useful for logging sensor data.

apt install postgresql-18-timescaledb

Add to /etc/postgresql/18/main/postgresql.conf - shared_preload_libraries = 'timescaledb'

CREATE EXTENSION IF NOT EXISTS timescaledb;