Shipping PostgreSQL logs to Grafana Cloud with Grafana Agent
This guide will show you how to push logs from a PostgreSQL instance to Grafana Cloud using the Grafana Agent. It will also show you how to search, explore, and view those logs.
Before you begin, you should have the following available:
- A Grafana Cloud account, as shown in Quickstarts
- 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
The Agent configuration should look like this:
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](/docs/grafana-cloud/monitor-infrastructure/agent/static/configuration/logs-config/).
Make sure that the
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
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:
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.