How to send Data generated on PSQL server to Azure Dashboard?

Question

I am creating a metrics in PSQL server, now I have some data (a table), and I would like to send that data to azure dashboard.

Can anyone assist me with your insights into this issue, by providing any documentation or information on how can I achieve this?

Answer 1

@newposter Welcome to Microsoft Q&A and thank you for posting your question.

You can use Azure Monitor Logs Analytics to create a custom dashboard for Azure Database for PostgreSQL. You can create a dashboard and monitor your Azure Database for Postgres. Please find more details and step by step in this blog. Create a Monitoring Dashboard for Azure Database for PostgreSQL.

Regards,
Oury

Answer 2

Hi @newposter

Steps explaining how this can be achieved.

1. Navigate to Metrics of the Coordinator Node and Select the Metric required.

2. On the Right hand side, you have an option to Pin to Dashboard. Select another Dashboard and create a new dashboard.

3. Once you create a new Dashboard, search for shared dashboards in Azure Portal. You will find the Dashboard you just created.
   
4. Click on Go to Dashboard and you will be able to see the metric that you just pinned.

5. Similarly, you can add other nodes but from the second Node of the cluster, you have to select as “Pin to current Dashboard” and select the existing you created.

6. The newly added Metric will be pinned beside the previous metric chart on the dashboard.

7. Similarly, we add as many metrics required and also make changes on the UI and set filters.
   

Hope that helps

Regards
Oury