Chapter 21. Server Configuration
Prev UpPart III. Server AdministrationHome Next

Chapter 21. Server Configuration

Table of Contents

21.1. Setting Parameters
21.1.1. Parameter Names and Values
21.1.2. Parameter Interaction via the Configuration File
21.1.3. Parameter Interaction via SQL
21.1.4. Parameter Interaction via the Shell
21.1.5. Managing Configuration File Contents
21.2. File Locations
21.3. Connections and Authentication
21.3.1. Connection Settings
21.3.2. Authentication
21.3.3. SSL
21.4. Resource Consumption
21.4.1. Memory
21.4.2. Disk
21.4.3. Kernel Resource Usage
21.4.4. Cost-based Vacuum Delay
21.4.5. Background Writer
21.4.6. Asynchronous Behavior
21.5. Write Ahead Log
21.5.1. Settings
21.5.2. Checkpoints
21.5.3. Archiving
21.5.4. Recovery
21.5.5. Archive Recovery
21.5.6. Recovery Target
21.6. Replication
21.6.1. Sending Servers
21.6.2. Primary Server
21.6.3. Standby Servers
21.6.4. Subscribers
21.7. Query Planning
21.7.1. Planner Method Configuration
21.7.2. Planner Cost Constants
21.7.3. Genetic Query Optimizer
21.7.4. Other Planner Options
21.8. Error Reporting and Logging
21.8.1. Where to Log
21.8.2. When to Log
21.8.3. What to Log
21.8.4. Using CSV-Format Log Output
21.8.5. Using JSON-Format Log Output
21.8.6. Process Title
21.9. Run-time Statistics
21.9.1. Cumulative Query and Index Statistics
21.9.2. Statistics Monitoring
21.10. Automatic Vacuuming
21.11. Client Connection Defaults
21.11.1. Statement Behavior
21.11.2. Locale and Formatting
21.11.3. Shared Library Preloading
21.11.4. Other Defaults
21.12. Lock Management
21.13. Version and Platform Compatibility
21.13.1. Previous PostgreSQL Versions
21.13.2. Platform and Client Compatibility
21.14. Error Handling
21.15. Preset Options
21.16. Customized Options
21.17. Developer Options
21.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.

Prev Up Next
20.12. Registering Event Log on Windows Home 21.1. Setting Parameters