Configuring an external TimescaleDB

You can configure External Reports to use an external deployment of TimescaleDB. You can use this as an alternative to the default deployment.

To enable an external deployment, you must complete the following tasks:

• Deploy or access an external TimescaleDB instance. This instance is a PostgreSQL server with the TimescaleDB extension installed. The DB server must be deployed in a way that is accessible to your installation of Turbonomic. It can be deployed on the cloud or in an on-prem VM. As of Turbonomic 8.14.2, the embedded reports feature currently supports PostgreSQL 15.x and TimescaleDB 2.17.1. Prior to Turbonomic 8.14.2, the embedded reports feature supported PostgreSQL 12.x and TimescaleDB 2.10.2. For more information, see the following resources:

  • Creating an External TimescaleDB

  • Install TimescaleDB

• Provision users, databases, and schemas on the TimescaleDB instance. To provision these database objects, you can manually provision or enable Turbonomic to automatically provision. For more information, see:

  • Manual provisioning of users and databases

  • Automatic provisioning of users and databases

• Edit properties in the Turbonomic charts_v1alpha1_xl_cr.yaml file. The location of the charts_v1alpha1_xl_cr.yaml file depends on whether you are configuring an OVA installation or a Kubernetes Node installation of Turbonomic.

• Optionally, enable secure connections between Turbonomic and the TimescaleDB instance. For information about enabling TLS/SSL for database connections, see the PostgreSQL documentation Secure TCP/IP Connections with SSL.

  This link provides steps to create a self-signed certificate that works with embedded reporting. However, self-signed certificates are not recommended for production instances.