Connecting to TimescaleDB

Regardless of the tool you use to connect to your database, you need to make sure you have these details:

  • Hostname
  • Port
  • Username
  • Password
  • Database name

For more information about using these details to connect with psql, see the About psql section.

Find connection details in Timescale Cloud

To retrieve your connection details from a running Timescale Cloud service:

Finding connection details in Timescale Cloud

  1. Sign in to the Timescale Cloud 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 to see its connection information. Copy the Service URL, which you will need when connecting.
  4. If you don’t know the password for the service, navigate to the Operations tab, and click Reset password. You can choose your own password or allow Timescale Cloud to generate a secure password for you. Keep a copy of your new password, which you will need when connecting.

View Timescale Cloud connection info

Find connection details in Managed Service for TimescaleDB

To retrieve your connection details from a running Managed Service for TimescaleDB service:

Finding connection details in Managed Service for TimescaleDB

  1. Sign in to the 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 to see its connection information. Copy the host, port, and password. You need these to connect.

View Managed Service for TimescaleDB connection info

Find connection details in self-hosted TimescaleDB

If you have installed your database on your local system, you can use the localhost hostname to log in as the PostgreSQL root user postgres. When you have connected using these details, we strongly recommend that you set up an additional user for accessing your database, and add additional authentication requirements.