Ok, you have installed TimescaleDB, and now you are ready to work with some data. The first thing to do is to create a new empty database or convert an existing PostgreSQL database to use TimescaleDB.
First connect to the PostgreSQL instance:
# Connect to PostgreSQL, using a superuser named 'postgres' psql -U postgres -h localhost
Now create a new empty database (skip this if you already have a database):
-- Create the database, let's call it 'tutorial' CREATE database tutorial;
Lastly add TimescaleDB:
-- Connect to the database \c tutorial -- Extend the database with TimescaleDB CREATE EXTENSION IF NOT EXISTS timescaledb;
CREATE EXTENSION timescaledb VERSION '2.1.0';
That's it! Connecting to the new database is as simple as:
psql -U postgres -h localhost -d tutorial
Now that you have a new TimescaleDB database setup, start by inserting or creating data to learn more about the features and superpowers we add to time-series data:
Found an issue on this page?Report an issue!