A service in $CLOUD_LONG is a cloud instance which contains your database.
Each service contains a single database, named tsdb.
You can connect to a service from your local system using the psql
command-line utility. If you've used $PG before, you might already have
psql installed. If not, check out the installing psql section.
-
In the $CONSOLE, click
Create service. -
Click
Download the cheatsheetto download an SQL file that contains the login details for your new service. You can also copy the details directly from this page. When you have copied your password, clickI stored my password, go to service overviewat the bottom of the page.When your service is ready to use, is shows a green
Runninglabel in theService Overview. You also receive an email confirming that your service is ready to use. -
On your local system, at the command prompt, connect to the service using the
Service URLfrom the SQL file that you downloaded. When you are prompted, enter the password:psql -x "<SERVICE_URL>" Password for user tsdbadmin:
If your connection is successful, you'll see a message like this, followed by the
psqlprompt:psql (13.3, server 12.8 (Ubuntu 12.8-1.pgdg21.04+1)) SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off) Type "help" for help. tsdb=>