Chapter 18. Server Setup and Operation

Table of Contents

18.1. The PostgreSQL User Account

18.2. Creating a Database Cluster

18.2.1. Use of Secondary File Systems

18.2.2. Use of Network File Systems

18.3. Starting the Database Server

18.3.1. Server Start-up Failures

18.3.2. Client Connection Problems

18.4. Managing Kernel Resources

18.4.1. Shared Memory and Semaphores

18.4.2. systemd RemoveIPC

18.4.3. Resource Limits

18.4.4. Linux Memory Overcommit

18.4.5. Linux Huge Pages

18.5. Shutting Down the Server

18.6. Upgrading a PostgreSQL Cluster

18.6.1. Upgrading Data via pg_dumpall

18.6.2. Upgrading Data via pg_upgrade

18.6.3. Upgrading Data via Replication

18.7. Preventing Server Spoofing

18.8. Encryption Options

18.9. Secure TCP/IP Connections with SSL

18.9.1. Basic Setup

18.9.2. OpenSSL Configuration

18.9.3. Using Client Certificates

18.9.4. SSL Server File Usage

18.9.5. Creating Certificates

18.10. Secure TCP/IP Connections with SSH Tunnels

18.11. Registering Event Log on Windows