Set up the TimescaleDB extension

When you have Postgres and TimescaleDB installed, connect to your instance and set up the TimescaleDB extension.

1. On your instance, at the command prompt, connect to the Postgres instance as the postgres superuser:

2. At the prompt, create an empty database. For example, to create a database called tsdb:

3. Connect to the database you created:

4. Add the TimescaleDB extension:

You can check that the TimescaleDB extension is installed by using the \dx command at the command prompt. It looks like this:

What next? [Try the key features offered by Tiger Data][try-timescale-features], see the [tutorials][tutorials], interact with the data in your Tiger Cloud service using [your favorite programming language][connect-with-code], integrate your Tiger Cloud service with a range of [third-party tools][integrations], plain old [Use Tiger Data products][use-timescale], or dive into the [API reference][use-the-api].

===== PAGE: https://docs.tigerdata.com/self-hosted/install/installation-macos/ =====

Examples:

Example 1 (bash):

sudo -u postgres psql

Example 2 (sql):

CREATE database tsdb;

Example 3 (sql):

\c tsdb

Example 4 (sql):

CREATE EXTENSION IF NOT EXISTS timescaledb;