---
title: "Server Configuration"
id: runtime-config
pg_version: "20devel"
---

<a id="runtime-config"></a>

# Server Configuration

## Table of Contents

- [19.1. Setting Parameters](config-setting.md)
  - [19.1.1. Parameter Names and Values](config-setting.md#config-setting-names-values)
  - [19.1.2. Parameter Interaction via the Configuration File](config-setting.md#config-setting-configuration-file)
  - [19.1.3. Parameter Interaction via SQL](config-setting.md#config-setting-sql)
  - [19.1.4. Parameter Interaction via the Shell](config-setting.md#config-setting-shell)
  - [19.1.5. Managing Configuration File Contents](config-setting.md#config-includes)
- [19.2. File Locations](runtime-config-file-locations.md)
- [19.3. Connections and Authentication](runtime-config-connection.md)
  - [19.3.1. Connection Settings](runtime-config-connection.md#runtime-config-connection-settings)
  - [19.3.2. TCP Settings](runtime-config-connection.md#runtime-config-tcp-settings)
  - [19.3.3. Authentication](runtime-config-connection.md#runtime-config-connection-authentication)
  - [19.3.4. SSL](runtime-config-connection.md#runtime-config-connection-ssl)
- [19.4. Resource Consumption](runtime-config-resource.md)
  - [19.4.1. Memory](runtime-config-resource.md#runtime-config-resource-memory)
  - [19.4.2. Disk](runtime-config-resource.md#runtime-config-resource-disk)
  - [19.4.3. Kernel Resource Usage](runtime-config-resource.md#runtime-config-resource-kernel)
  - [19.4.4. Timing](runtime-config-resource.md#runtime-config-resource-time)
  - [19.4.5. Background Writer](runtime-config-resource.md#runtime-config-resource-background-writer)
  - [19.4.6. I/O](runtime-config-resource.md#runtime-config-resource-io)
  - [19.4.7. Worker Processes](runtime-config-resource.md#runtime-config-resource-worker-processes)
- [19.5. Write Ahead Log](runtime-config-wal.md)
  - [19.5.1. Settings](runtime-config-wal.md#runtime-config-wal-settings)
  - [19.5.2. Checkpoints](runtime-config-wal.md#runtime-config-wal-checkpoints)
  - [19.5.3. Archiving](runtime-config-wal.md#runtime-config-wal-archiving)
  - [19.5.4. Recovery](runtime-config-wal.md#runtime-config-wal-recovery)
  - [19.5.5. Archive Recovery](runtime-config-wal.md#runtime-config-wal-archive-recovery)
  - [19.5.6. Recovery Target](runtime-config-wal.md#runtime-config-wal-recovery-target)
  - [19.5.7. WAL Summarization](runtime-config-wal.md#runtime-config-wal-summarization)
- [19.6. Replication](runtime-config-replication.md)
  - [19.6.1. Sending Servers](runtime-config-replication.md#runtime-config-replication-sender)
  - [19.6.2. Primary Server](runtime-config-replication.md#runtime-config-replication-primary)
  - [19.6.3. Standby Servers](runtime-config-replication.md#runtime-config-replication-standby)
  - [19.6.4. Subscribers](runtime-config-replication.md#runtime-config-replication-subscriber)
- [19.7. Query Planning](runtime-config-query.md)
  - [19.7.1. Planner Method Configuration](runtime-config-query.md#runtime-config-query-enable)
  - [19.7.2. Planner Cost Constants](runtime-config-query.md#runtime-config-query-constants)
  - [19.7.3. Genetic Query Optimizer](runtime-config-query.md#runtime-config-query-geqo)
  - [19.7.4. Other Planner Options](runtime-config-query.md#runtime-config-query-other)
- [19.8. Error Reporting and Logging](runtime-config-logging.md)
  - [19.8.1. Where to Log](runtime-config-logging.md#runtime-config-logging-where)
  - [19.8.2. When to Log](runtime-config-logging.md#runtime-config-logging-when)
  - [19.8.3. What to Log](runtime-config-logging.md#runtime-config-logging-what)
  - [19.8.4. Using CSV-Format Log Output](runtime-config-logging.md#runtime-config-logging-csvlog)
  - [19.8.5. Using JSON-Format Log Output](runtime-config-logging.md#runtime-config-logging-jsonlog)
  - [19.8.6. Process Title](runtime-config-logging.md#runtime-config-logging-proc-title)
- [19.9. Run-time Statistics](runtime-config-statistics.md)
  - [19.9.1. Cumulative Query and Index Statistics](runtime-config-statistics.md#runtime-config-cumulative-statistics)
  - [19.9.2. Statistics Monitoring](runtime-config-statistics.md#runtime-config-statistics-monitor)
- [19.10. Vacuuming](runtime-config-vacuum.md)
  - [19.10.1. Automatic Vacuuming](runtime-config-vacuum.md#runtime-config-autovacuum)
  - [19.10.2. Cost-based Vacuum Delay](runtime-config-vacuum.md#runtime-config-resource-vacuum-cost)
  - [19.10.3. Default Behavior](runtime-config-vacuum.md#runtime-config-vacuum-default)
  - [19.10.4. Freezing](runtime-config-vacuum.md#runtime-config-vacuum-freezing)
- [19.11. Client Connection Defaults](runtime-config-client.md)
  - [19.11.1. Statement Behavior](runtime-config-client.md#runtime-config-client-statement)
  - [19.11.2. Locale and Formatting](runtime-config-client.md#runtime-config-client-format)
  - [19.11.3. Shared Library Preloading](runtime-config-client.md#runtime-config-client-preload)
  - [19.11.4. Other Defaults](runtime-config-client.md#runtime-config-client-other)
- [19.12. Lock Management](runtime-config-locks.md)
- [19.13. Version and Platform Compatibility](runtime-config-compatible.md)
  - [19.13.1. Previous PostgreSQL Versions](runtime-config-compatible.md#runtime-config-compatible-version)
  - [19.13.2. Platform and Client Compatibility](runtime-config-compatible.md#runtime-config-compatible-clients)
- [19.14. Error Handling](runtime-config-error-handling.md)
- [19.15. Preset Options](runtime-config-preset.md)
- [19.16. Customized Options](runtime-config-custom.md)
- [19.17. Developer Options](runtime-config-developer.md)
- [19.18. Short Options](runtime-config-short.md)

There are many configuration parameters that affect the behavior of the database system. In the first section of this chapter we describe how to interact with configuration parameters. The subsequent sections discuss each parameter in detail.