Connect to Timescale using pgAdmin

Sign in to the Timescale portal.

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

Click the name of the service you want to connect to, and take a note of the Host, Port, Database name, and Username.

Navigate to the Operations tab, and click Reset password. You can choose your own password for the service, or allow Timescale to generate a secure password for you. Take a note of your new password.

Start pgAdmin.

In the Quick Links section of the Dashboard tab, click Add New Server.

In the Register - Server page go to the General tab.

In the Name field, type a name for the server, and the description in the Comments field.

In the Connection tab, fill in the fields using the server name, database, user name, port, and password for your Timescale service. For more information about these settings, see the connection section.

Click Save to save the configuratiosn that you set.

Note

If you configured your Timescale service to connect using SSL mode, in the Parameters tab, set SSL mode to Verify-Full, and set the location of the SSL root CA certificate to use.

Click Save.

Expand image