Introduction to PostgreSQL monitoring with NRDOT

Monitor your PostgreSQL database performance using New Relic Distribution of OpenTelemetry (NRDOT) with comprehensive insights into database metrics, query performance, and system health.

This NRDOT-based approach complements our existing On-Host Integration (OHI) by leveraging OpenTelemetry standards for database monitoring, making it easier to integrate with your existing observability stack.

Unlike On-Host Integrations, NRDOT operates independently of the Infrastructure agent. It doesn't require the Infrastructure agent to collect database telemetry. NRDOT also includes native host monitoring capabilities, so you can choose to:

• Use the Infrastructure agent for host monitoring alongside NRDOT for database monitoring, or
• Use NRDOT to monitor both the database and the host.

Choose your installation method

You can install the NRDOT Collector for PostgreSQL monitoring in the following ways:

• Manual install: Set up the collector yourself on your own infrastructure
  • Self-hosted setup
  • AWS RDS or Aurora setup
• New Relic CLI: Install and configure the collector with a single command
• Ansible: Install and configure the collector at scale using the newrelic.newrelic_install Ansible role
• Chef: Install and configure the collector at scale using the newrelic-install Chef cookbook
• Helm chart: Install and configure PostgreSQL monitoring on Kubernetes using the postgresql-otel Helm chart
• Docker: Run the collector as a sibling container to a PostgreSQL instance already running in Docker

Installation at a glance

1. Check compatibility and gather prerequisites.
2. Install the NRDOT Collector.
3. Configure the monitoring user.
4. Configure the NRDOT Collector.
5. Restart the NRDOT Collector.
6. Verify data is flowing to New Relic.

Next: install and configure

• Self-hosted setup
• AWS RDS or Aurora setup
• New Relic CLI: Install and configure the collector with a single command
• Ansible: Install and configure the collector at scale using the newrelic.newrelic_install Ansible role
• Chef: Install and configure the collector at scale using the newrelic-install Chef cookbook
• Helm chart: Install and configure PostgreSQL monitoring on Kubernetes using the postgresql-otel Helm chart
• Docker: Run the collector as a sibling container to a PostgreSQL instance already running in Docker