III. Server Administration

This part covers topics that are of interest to a PostgreSQL database administrator. This includes installation of the software, set up and configuration of the server, management of users and databases, and maintenance tasks. Anyone who runs a PostgreSQL server, either for personal use, but especially in production, should be familiar with the topics covered in this part.

The information in this part is arranged approximately in the order in which a new user should read it. But the chapters are self-contained and can be read individually as desired. The information in this part is presented in a narrative fashion in topical units. Readers looking for a complete description of a particular command should look into Part VI.

The first few chapters are written so that they can be understood without prerequisite knowledge, so that new users who need to set up their own server can begin their exploration with this part. The rest of this part which is about tuning and management presupposes that the reader is familiar with the general use of the PostgreSQL database system. Readers are encouraged to look at Part I and Part II for additional information.

Table of Contents
14. Installation Instructions
14.1. Short Version
14.2. Requirements
14.3. Getting The Source
14.4. If You Are Upgrading
14.5. Installation Procedure
14.6. Post-Installation Setup
14.7. Supported Platforms
15. Installation on Windows
16. Server Run-time Environment
16.1. The PostgreSQL User Account
16.2. Creating a Database Cluster
16.3. Starting the Database Server
16.4. Run-time Configuration
16.5. Managing Kernel Resources
16.6. Shutting Down the Server
16.7. Secure TCP/IP Connections with SSL
16.8. Secure TCP/IP Connections with SSH Tunnels
17. Database Users and Privileges
17.1. Database Users
17.2. User Attributes
17.3. Groups
17.4. Privileges
17.5. Functions and Triggers
18. Managing Databases
18.1. Overview
18.2. Creating a Database
18.3. Template Databases
18.4. Database Configuration
18.5. Alternative Locations
18.6. Destroying a Database
19. Client Authentication
19.1. The pg_hba.conf file
19.2. Authentication methods
19.3. Authentication problems
20. Localization
20.1. Locale Support
20.2. Character Set Support
21. Routine Database Maintenance Tasks
21.1. Routine Vacuuming
21.2. Routine Reindexing
21.3. Log File Maintenance
22. Backup and Restore
22.1. SQL Dump
22.2. File system level backup
22.3. Migration Between Releases
23. Monitoring Database Activity
23.1. Standard Unix Tools
23.2. The Statistics Collector
23.3. Viewing Locks
24. Monitoring Disk Usage
24.1. Determining Disk Usage
24.2. Disk Full Failure
25. Write-Ahead Logging (WAL)
25.1. Benefits of WAL
25.2. Future Benefits
25.3. WAL Configuration
25.4. Internals
26. Regression Tests
26.1. Running the Tests
26.2. Test Evaluation
26.3. Platform-specific comparison files