Managed Service for TimescaleDB (MST) is TimescaleDB hosted on Azure and GCP. MST is offered in partnership with Aiven.

Timescale Cloud or MST?

Timescale Cloud is a high-performance developer focused cloud that provides PostgreSQL services enhanced with our blazing fast vector search. You can securely integrate Timescale Cloud with your AWS, GCS or Azure infrastructure. Create a Timescale Cloud service and try for free.

If you need to run TimescaleDB on GCP or Azure, you're in the right place — keep reading.

A service in Managed Service for TimescaleDB is a cloud instance on your chosen cloud provider, which you can install your database on.

  1. Sign in to your Managed Service for TimescaleDB portal.

  2. Click Create service and choose TimescaleDB, and update your preferences:

    Create a new service in the Managed Service for TimescaleDB portal
    • In the Select Your Cloud Service Provider field, click your preferred provider.
    • In the Select Your Cloud Service Region field, click your preferred server location. This is often the server that's physically closest to you.
    • In the Select Your Service Plan field, click your preferred plan, based on the hardware configuration you require. If you are in your trial period, and just want to try the service out, or develop a proof of concept, we recommend the Dev plan, because it is the most cost-effective during your trial period.
  3. In the information bar on the right of the screen, review the settings you have selected for your service, and click Create Service. The service takes a few minutes to provision.

When you have a service up and running, you can connect to it from your local system using the psql command-line utility. This is the same tool you might have used to connect to PostgreSQL before, but if you haven't installed it yet, check out the installing psql section.

  1. Sign in to your Managed Service for TimescaleDB portal.

  2. In the Services tab, find the service you want to connect to, and check it is marked as Running.

  3. Click the name of the service you want to connect to see the connection information. Take a note of the host, port, and password.

  4. On your local system, at the command prompt, connect to the service, using your own service details:

    psql -x "postgres://tsdbadmin:<PASSWORD>@<HOSTNAME>:<PORT>/defaultdb?sslmode=require"

    If your connection is successful, you'll see a message like this, followed by the psql prompt:

    psql (13.3, server 13.4)
    SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
    Type "help" for help.
    defaultdb=>

TimescaleDB is provided as an extension to your PostgreSQL database, and it is enabled by default when you create a new service on Managed Service for TimescaleDB. You can check that the TimescaleDB extension is installed by using the \dx command at the psql prompt. It looks like this:

defaultdb=> \dx
List of installed extensions
-[ RECORD 1 ]------------------------------------------------------------------
Name | plpgsql
Version | 1.0
Schema | pg_catalog
Description | PL/pgSQL procedural language
-[ RECORD 2 ]------------------------------------------------------------------
Name | timescaledb
Version | 2.5.1
Schema | public
Description | Enables scalable inserts and complex queries for time-series data
defaultdb=>

Now that you have your first service up and running, you can check out the Managed Service for TimescaleDB section in the documentation, and find out what you can do with it.

If you want to work through some tutorials to help you get up and running with TimescaleDB and time-series data, check out the tutorials section.

You can always contact us if you need help working something out, or if you want to have a chat.

Keywords

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