> ## Documentation Index
> Fetch the complete documentation index at: https://docs.honeycomb.io/llms.txt
> Use this file to discover all available pages before exploring further.

# PostgreSQL

<Badge className="hny-badge-enterprise-addon" stroke>Ent+</Badge>

<Note>
  This feature is available as an add-on for the [Honeycomb Enterprise plan](https://www.honeycomb.io/pricing/).
  Please contact your Honeycomb account team for details.
</Note>

## Supported Platforms

| Platform | Metrics | Logs | Traces |
| :------- | :------ | :--- | :----- |
| Linux    | ✓       | ✓    |        |
| Windows  | ✓       | ✓    |        |
| macOS    | ✓       | ✓    |        |

## Prerequisites

This source supports PostgreSQL versions 10.18 and higher.

The monitoring user must be granted `SELECT` on `pg_stat_database`.

## Configuration Table

| Parameter                         | Type                | Default                                                                                                                                                                                             | Description                                                                                                                                                                       |
| :-------------------------------- | :------------------ | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| telemetry\_types                  | `telemetrySelector` | `["Logs", "Metrics"]`                                                                                                                                                                               | Choose Telemetry Type.                                                                                                                                                            |
| postgresql\_log\_path             | `strings`           | For CentOS / RHEL: `- \"/var/log/postgresql/postgresql_.log\"` \nFor SLES: `- \"/var/lib/pgsql/data/log/postgresql_.log\"` \nFor Debian / Ubuntu: `- \"/var/lib/pgsql/_/data/log/postgresql_.log\"` | Path to Postgres log file(s).                                                                                                                                                     |
| start\_at                         | `enum`              | end                                                                                                                                                                                                 | Start reading the file from the 'beginning' or 'end'.                                                                                                                             |
| username\*                        | `string`            |                                                                                                                                                                                                     | Username used to authenticate.                                                                                                                                                    |
| password\*                        | `string`            |                                                                                                                                                                                                     | Password used to authenticate.                                                                                                                                                    |
| endpoint                          | `string`            | localhost:5432                                                                                                                                                                                      | The endpoint of the Postgres server. If transport is set to unix, the endpoint will internally be translated from host:port to /host.s.PGSQL.port.                                |
| transport                         | `enum`              | tcp                                                                                                                                                                                                 | The transport protocol used to connect to Postgres. Valid values are `tcp`, or `unix`.                                                                                            |
| databases                         | `strings`           |                                                                                                                                                                                                     | The list of databases for which the receiver will attempt to collect statistics. If an empty list is provided, the receiver will attempt to collect statistics for all databases. |
| collection\_interval              | `int`               | 60                                                                                                                                                                                                  | Sets how often (seconds) to scrape for metrics.                                                                                                                                   |
| enable\_tls                       | `bool`              | false                                                                                                                                                                                               | Whether or not to use TLS.                                                                                                                                                        |
| enable\_tlsinsecure\_skip\_verify | `bool`              | false                                                                                                                                                                                               | Enable to skip TLS certificate verification.                                                                                                                                      |
| ca\_file                          | `string`            |                                                                                                                                                                                                     | Certificate authority used to validate the database server's TLS certificate.                                                                                                     |
| cert\_file                        | `string`            |                                                                                                                                                                                                     | A TLS certificate used for client authentication, if mutual TLS is enabled.                                                                                                       |
| key\_file                         | `string`            |                                                                                                                                                                                                     | A TLS private key used for client authentication, if mutual TLS is enabled.                                                                                                       |