Create your first Timescale service

To setup 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"

     Copy

   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 (
     time TIMESTAMPTZ NOT NULL,
     symbol TEXT NOT NULL,
     price DOUBLE PRECISION NULL,
     day_volume INT NULL
   );

   Copy

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.