Each Timescale Cloud service is a single 100% PostgreSQL database with usage-based storage. You manage your services and interact with your data in Timescale Console using the following modes:

Ops modeData mode
Timescale Console ops mode
Timescale Console data mode
You use the ops mode to:
  • Ensure data security with high availability and read replicas
  • Save money using compressed and tiered storage
  • Enable PostgreSQL extensions to add extra functionality
  • Increase security using VPCs
  • Perform day-to-day administration
Powered by PopSQL, you use the data mode to:
  • Write queries with autocomplete
  • Visualize data with charts and dashboards
  • Schedule queries and dashboards for alerts or recurring reports
  • Share queries and dashboards

When you log into your Timescale account, you see the Project overview. Click a service to view run-time data and connection information. Click Operations to configure your service.

Select a query to edit

Each service hosts a single database managed for you by Timescale in the cloud. If you need more than one database, create a new service.

By default, when you create a new service, a new tsdbadmin user is created. This is the user that you use to connect to your new service.

Important

The tsdbadmin user is the owner of the database, but is not a superuser. You cannot access the postgres user. There is no superuser access to Timescale Cloud databases.

On Timescale services, the tsdbadmin user can create another user with any other roles. For a complete list of roles available, see the PostgreSQL role attributes documentation.

You cannot create multiple databases on a single Timescale service. If you need data isolation, use schemas or create additional services.

Keywords

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