PostgreSQL: The definitive guide
PrevNext

I. Installation, Configuration and Management

Table of Contents
2. Getting Started
2.1. Choosing the right hardware
2.1.1. Choosing the right CPU
2.1.2. How much physical memory do I need?
2.1.3. Choosing the right hard drive system
2.1.4. RAID types
2.2. Preparing for Source Installation
2.2.1. Required Software Packages
2.2.2. Optional Packages
2.2.3. Disk Space
2.3. 7 Steps to Installing PostgreSQL from source on Linux
2.3.1. Step 1: Creating the “postgres” User
2.3.2. Step 2: Installing the PostgreSQL Source Package
2.3.3. Step 3: Configuring the Source Tree
2.3.4. Step 4: Compiling the Source
2.3.5. Step 5: Regression Testing
2.3.6. Step 6: Installing Compiled Programs and Libraries
2.3.7. Step 7: Setting Environment Variables
2.4. Starting and Stopping PostgreSQL
2.4.1. Using pg_ctl
2.4.2. Configuring the PostgreSQL SysV Script
2.4.3. Calling postmaster Directly
2.5. Initializing the Filesystem
2.5.1. Initializing a Database Cluster
2.5.2. Table spaces
2.6. Creating and Removing a Database
2.6.1. Creating a Database
2.6.2. Removing a Database
3. Configuration of PostgreSQL
3.1. The postgresql.conf
3.1.1. File locations
3.1.2. Connections and Authentication
3.1.3. Resource utilization
3.1.4. Write Ahead Log
3.1.5. Query tuning
3.1.6. Genetic Estimate Query Optimizer (GEQO)
3.1.7. Other Query Modifiers
3.1.8. Logging and Debugging Options
3.1.9. Statistics Logging
3.1.10. Autovacuum parameters
3.1.11. Client Connection Defaults
3.1.12. Locale and Formatting
3.1.13. Lock Management
3.1.14. Version Platform Compatibility
3.1.15. PostgreSQL.Conf quick reference
3.2. Authentication and Encryption
3.2.1. Password Authentication
3.2.2. The pg_hba.conf file
3.3. The pg_ident.conf file
3.4. Encrypting sessions
3.4.1. Built-in SSL
3.4.2. SSH/OpenSSH
4. Database Management
4.1. Maintaining a Database
4.1.1. Using VACUUM
4.1.2. Using vacuumdb
4.1.3. Using the new integrated autovacuum
4.1.4. Documenting a Database
4.2. Backing Up and Restoring Data
4.2.1. Using pg_dump
4.2.2. Using pg_dumpall
4.2.3. Restoring a Database
4.2.4. When to Backup and Restore Data
4.2.5. Backing Up the Filesystem
PrevHomeNext
PostgreSQL Feature Set Getting Started