syslog_facility

syslog_facility is the PostgreSQL setting that defines the syslog “facility” to be used when syslog enabled.

Note

Fact — official short description: “Sets the syslog “facility” to be used when syslog enabled.”

Identity

Type , Valueenum: Upstream pg_settings type
Context , Valuesighup: Takes effect after configuration reload
Unit , Value—: Raw unit
Range , Value—: Raw limits in the last observed version
Enum values , Valuelocal0, local1, local2, local3, local4, local5, local6, local7: — for non-enum types
Category , ValueReporting and Logging / Where to Log: Upstream classification
Latest boot value , Valuelocal0: local0

Lifecycle

Fact	Value
First observed	PG9.0 (research boundary)
Present in	PG9.0–19 Beta 3
Removed in	No
Introduction commit	Not asserted: predates the PG9.0 research boundary
Commit date	—
Discussion	—

Default history

Measured PG9.0–19 Beta 3 boot defaults
Versions	Raw `boot_val`	Unit	Human value
PG9.0–19 Beta 3	`local0`	—	local0

How it works

syslog_facility sets the syslog “facility” to be used when syslog enabled. It selects the syslog routing facility only when syslog is listed in log_destination; the system logger maps that facility to storage or forwarding rules.

syslog_facility is a SIGHUP-context setting: a configuration reload activates the new server value without a restart; subsequent operations that consult it use the refreshed value.

It is active only when syslog appears in log_destination, after which the facility, ident, sequence, splitting, host daemon, and remote receiver jointly define record delivery.

Tuning advice

Tip

Advice. These are workload-specific starting points and must be validated with measurements.

Workload	Guidance
OLTP	Set syslog_facility to match the receiving syslog daemon’s routing, framing, deduplication, and message-size contract; validate failover and backpressure with the real collector.
OLAP	Test syslog_facility under bursty analytical messages and multiline plans so splitting or receiver limits do not destroy record boundaries.
Small nodes	Prefer the host’s established syslog convention for syslog_facility; avoid parallel local-file retention unless it has an explicit purpose and size limit.

Pigsty

Values use the fixed 8-vCPU, 32-GiB, 100-GiB SSD fixture and render the current Pigsty templates for PG19 Beta 3; this does not assert current Pigsty support for that historical or beta release.

Template	Effective value	Versus upstream boot	Source expression
OLTP	Unmodified	—	—
OLAP	Unmodified	—	—
CRIT	Unmodified	—	—
TINY	Unmodified	—	—

Caution

Advice — pending human review. Fact from the current Pigsty template projection: OLTP: PG9.0–19 Beta 3 unmodified; OLAP: PG9.0–19 Beta 3 unmodified; CRIT: PG9.0–19 Beta 3 unmodified; TINY: PG9.0–19 Beta 3 unmodified. No Pigsty-specific rationale is inferred from an absent override.

Common pitfalls

Editing syslog_facility without reloading configuration and verifying the effective value and subsequent behavior.
Changing PostgreSQL framing or identifiers without testing the host daemon and remote receiver as one pipeline.
Assuming syslog preserves unlimited message size, multiline boundaries, ordering, or repeated records by default.
Changing syslog_facility globally without a rollback plan and a client or operational compatibility test.

log_destination · syslog_ident · syslog_sequence_numbers · syslog_split_messages · logging_collector