Hologres:Grafana

Procedure

1. Install Grafana

   Install Grafana. For more information, see the official Grafana documentation.

2. Connect to Hologres

   1. Log on to Grafana. In the navigation pane on the left, click Add new connection, select Data Source, and then click PostgreSQL.

   2. On the PostgreSQL Connection page, enter the required connection information.

      The following table describes the parameters.

      Parameter	Description
      Host URL	The public endpoint of the Hologres instance. Go to the instance details page in the Hologres console and obtain the endpoint from the Network Information section.
      Database name	The name of the Hologres database.
      Username	The AccessKey ID of your Alibaba Cloud account. For more information about how to obtain an AccessKey ID, see Create an AccessKey pair.
      Password	The AccessKey secret of your Alibaba Cloud account.
      TLS/SSL Mode	Configure this parameter as needed. The setting depends on whether SSL is enabled for your endpoint.
      Version	Set the PostgreSQL version to 11.
      More parameters	For more information about the other parameters, see the official Grafana documentation.

   3. After you enter the parameters, click Save & Test at the bottom of the page. If the Database Connection OK message is displayed, the connection is successful.

3. Analyze data

   After the configuration is complete, you can analyze data from this data source. For more information about data analytics operations, see the official Grafana documentation.