September 26, 2024: PostgreSQL 17 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 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 the current version, or one of the other supported versions listed above instead.
PostgreSQL 8.4.22 Documentation
Prev Fast Backward Fast Forward Next

Chapter 18. Server Configuration

Table of Contents
18.1. Setting Parameters
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. Kernel Resource Usage
18.4.3. Cost-Based Vacuum Delay
18.4.4. Background Writer
18.4.5. Asynchronous Behavior
18.5. Write Ahead Log
18.5.1. Settings
18.5.2. Checkpoints
18.5.3. Archiving
18.6. Query Planning
18.6.1. Planner Method Configuration
18.6.2. Planner Cost Constants
18.6.3. Genetic Query Optimizer
18.6.4. Other Planner Options
18.7. Error Reporting and Logging
18.7.1. Where To Log
18.7.2. When To Log
18.7.3. What To Log
18.7.4. Using CSV-Format Log Output
18.8. Run-Time Statistics
18.8.1. Query and Index Statistics Collector
18.8.2. Statistics Monitoring
18.9. Automatic Vacuuming
18.10. Client Connection Defaults
18.10.1. Statement Behavior
18.10.2. Locale and Formatting
18.10.3. Other Defaults
18.11. Lock Management
18.12. Version and Platform Compatibility
18.12.1. Previous PostgreSQL Versions
18.12.2. Platform and Client Compatibility
18.13. Preset Options
18.14. Customized Options
18.15. Developer Options
18.16. 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 set configuration parameters. The subsequent sections discuss each parameter in detail.

Prev Home Next
Secure TCP/IP Connections with SSH Tunnels Up Setting Parameters