sudo su -l postgres psql
CREATE database test_db; #change into the test_db: \c test_db Output: You are now connected to database "test_db" as user "postgres". #create TimescaleDB extension: CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;