Documentation Grafana Cloud Instrument and send data Logs Shipping PostgreSQL logs to Grafana Cloud with Grafana Agent

Shipping PostgreSQL logs to Grafana Cloud with Grafana Agent

This guide shows you how to push logs from a PostgreSQL instance to Grafana Cloud using Grafana Agent. It also shows you how to search, explore, and view those logs.

Prerequisites

Before you begin, you should have the following available:

• A Grafana Cloud account, as shown in Get started
• A Linux machine
• PostgreSQL installed on your machine
• Grafana Agent installed on your Linux machine, as shown in the PostgreSQL integration for Grafana Cloud quickstart

Once you have these installed, you’re ready to begin with this guide.

Configure the agent to collect and send PostgreSQL logs

Since your Linux machine is already running the agent, configuring it to send logs is accomplished by modifying the agent configuration YAML file.

The agent configuration is stored in /etc/grafana-agent.yaml by default. Open the file and add a logs section. The Agent configuration should look like this:

yaml Copy

integrations:
  prometheus_remote_write:
    - basic_auth:
        password: <password>
        username: <username>
      url: https://<cloud-endpoint>/api/prom/push
  postgres_exporter:
    data_source_names:
      - postgresql://<postgres-username>:<postgres-password>@localhost:5432
    enabled: true
    instance: postgresql-01
    relabel_configs:
      - source_labels: [__address__]
        target_label: job
        replacement: 'integrations/postgresql'
logs:
  configs:
    - name: agent
      clients:
        - basic_auth:
            password: <logs-password>
            username: <logs-username>
          url: https://<cloud-logs-endpoint>/loki/api/v1/push
      positions:
        filename: /tmp/positions.yaml
      target_config:
        sync_period: 10s
      scrape_configs:
        - job_name: integrations/postgresql
          static_configs:
            - labels:
                instance: postgresql-01
                job: integrations/postgresql
                __path__: /var/log/postgresql/*log
metrics:
  wal_directory: /tmp/grafana-agent-wal

The configuration above locates and parses PostgresSQL server logs by using an embedded [Promtail](/404/).

Make sure that the job and instance labels match for logs and metrics. This ensures that we can quickly dive from metrics graphs to corresponding logs for more details on what actually happened.

You can find more information on configuring the PostgreSQL integration in our PostgreSQL integration documentation.

Check that logs are being ingested into Grafana Cloud

Logs should soon become available in Grafana Cloud. To test this, use the Explore feature. Click the Explore icon (looks like a compass) in the sidebar.

At the top of the page, use the dropdown menu to select your Loki logs data source. In the Log Browser, Run the query {job="integrations/postgresql"}.

If no log lines appear, logs are not being collected. If you see log lines, this confirms that logs are being received.

If you can’t see logs after several minutes, check your steps for typos and check whether the agent is running on the Linux machine.

If everything is working correctly, you should see the following:

Conclusion

Complete instructions for creating a dashboard panel (indeed, multiple panels to create a dashboard) are available in the Grafana Add a panel documentation.

You can also use Pipelines to transform log lines, labels and timestamps.