You use Timescale Console to create and manage Timescale services. Each service is a single 100% PostgreSQL database with usage-based storage.

Timescale offers the following PostgreSQL service types:

  • Time-series and Analytics: a Timescale DB instance optimized for your time-series and analytics workloads.
  • All other workloads: a Dynamic PostgreSQL instance with a Dynamic Compute range aligned to your business needs. For this Early Access product, you only pay the base. If your workload demands it, we dynamically scale CPU use between your min and max limits.

This section shows you how to create a Timescale service using Timescale Console, then connect to your service using PopSQL or the command line.

To set up Timescale:

  1. Sign up for a 30 day free trial.

    You receive a confirmation email in your inbox.

  2. In the confirmation email, click the link supplied and sign in to Timescale Console.

    Answer the requirements questions, they help us optimize the Timescale service for your use case. You can now create a Timescale service.

Now that you have an active Timescale account, you can create and manage your services in Timescale Console:

  1. In the service creation page, choose Time Series and Analytics or Dynamic PostgreSQL.

  2. Configure your service, then click Create service.

  3. In the Service Information page:

    1. Click Download the config and store your configuration information in a secure location.

      This page contains all you need to connect to your service. Spoiler alert, you need the config page to complete this Get Started process.

    2. Either:

      • Follow the instructions and connect to your service.
      • Click I stored my password, go to service overview.

If you choose to go to the service overview, Check your service and connect to it shows you how to connect.

To ensure a Timescale service is running correctly:

  1. In the Services section in Timescale Console, check that your service is marked as Running.

  2. Use PopSQL or psql to connect to your service:

    • Setup PopSQL: Follow the instructions to easily connect to your service in the UI.

    • psql: Connect to your service with the value of Service URL from the config file you just saved.

      psql "postgres://tsdbadmin:<PASSWORD>@<HOST>:<PORT>/tsdb?sslmode=require"

    You are connected to your service and are now able to issue commands.

  3. Create a PostgreSQL table, copy the following into PopSQL or psql, then run your query:

    CREATE TABLE stocks_real_time (
    symbol TEXT NOT NULL,
    day_volume INT NULL
  4. Check that the table exists.

    • In PopSQL, you see the table in the UI.
    • In psql, run the \dt command, You see the table listing in your service. To disconnect, type exit.

Quick recap, you find configuration information about your services in Services section in Timescale Console, you find configuration and security information in your config file.

And that is it, you are up and running. Enjoy developing with Timescale.

Found an issue on this page?Report an issue or Edit this page in GitHub.