PostgreSQL

Ent+

This feature is available as an add-on for the Honeycomb Enterprise plan. Please contact your Honeycomb account team for details.

Supported Platforms

Platform	Metrics	Logs
Linux	✓	✓
Windows	✓	✓
macOS	✓	✓

This source supports PostgreSQL versions 10.18 and higher. The monitoring user must be granted SELECT on pg_stat_database.

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.