Server Configuration (original) (raw)

Documentation → PostgreSQL 9.4

Supported Versions:Current (17) / 16 / 15 / 14 / 13

Development Versions:18 / devel

Unsupported versions:12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for thecurrent version, or one of the other supported versions listed above instead.

Chapter 18. Server Configuration

Table of Contents

18.1. Setting Parameters

18.1.1. Parameter Names and Values

18.1.2. Parameter Interaction via the Configuration File

18.1.3. Parameter Interaction via SQL

18.1.4. Parameter Interaction via the Shell

18.1.5. Managing Configuration File Contents

18.2. File Locations

18.3. Connections and Authentication

18.3.1. Connection Settings

18.3.2. Security and Authentication

18.4. Resource Consumption

18.4.1. Memory

18.4.2. Disk

18.4.3. Kernel Resource Usage

18.4.4. Cost-based Vacuum Delay

18.4.5. Background Writer

18.4.6. Asynchronous Behavior

18.5. Write Ahead Log

18.5.1. Settings

18.5.2. Checkpoints

18.5.3. Archiving

18.6. Replication

18.6.1. Sending Server(s)

18.6.2. Master Server

18.6.3. Standby Servers

18.7. Query Planning

18.7.1. Planner Method Configuration

18.7.2. Planner Cost Constants

18.7.3. Genetic Query Optimizer

18.7.4. Other Planner Options

18.8. Error Reporting and Logging

18.8.1. Where To Log

18.8.2. When To Log

18.8.3. What To Log

18.8.4. Using CSV-Format Log Output

18.9. Run-time Statistics

18.9.1. Query and Index Statistics Collector

18.9.2. Statistics Monitoring

18.10. Automatic Vacuuming

18.11. Client Connection Defaults

18.11.1. Statement Behavior

18.11.2. Locale and Formatting

18.11.3. Shared Library Preloading

18.11.4. Other Defaults

18.12. Lock Management

18.13. Version and Platform Compatibility

18.13.1. Previous PostgreSQL Versions

18.13.2. Platform and Client Compatibility

18.14. Error Handling

18.15. Preset Options

18.16. Customized Options

18.17. Developer Options

18.18. Short Options

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.