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
- Sign in to the Timescale Cloud portal.
- In the
Services
tab, find the service you want to connect to, and check it is marked asRunning
. - Click the name of the service to see its connection information. Copy the
Service URL
, which you will need when connecting. - If you don’t know the password for the service, navigate to the
Operations
tab, and clickReset 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.
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
- Sign in to the Managed Service for TimescaleDB portal.
- In the
Services
tab, find the service you want to connect to, and check it is marked asRunning
. - Click the name of the service to see its connection information. Copy the
host
,port
, andpassword
. You need these to connect.
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.