Chapter 17. Server Setup and Operation

Table of Contents
17.1. The PostgreSQL User Account
17.2. Creating a Database Cluster
17.2.1. Use of Secondary File Systems
17.2.2. Use of Network File Systems
17.3. Starting the Database Server
17.3.1. Server Start-up Failures
17.3.2. Client Connection Problems
17.4. Managing Kernel Resources
17.4.1. Shared Memory and Semaphores
17.4.2. systemd RemoveIPC
17.4.3. Resource Limits
17.4.4. Linux Memory Overcommit
17.4.5. Linux Huge Pages
17.5. Shutting Down the Server
17.6. Upgrading a PostgreSQL Cluster
17.6.1. Upgrading Data via pg_dumpall
17.6.2. Upgrading Data via pg_upgrade
17.6.3. Upgrading Data via Replication
17.7. Preventing Server Spoofing
17.8. Encryption Options
17.9. Secure TCP/IP Connections with SSL
17.9.1. Using Client Certificates
17.9.2. SSL Server File Usage
17.9.3. Creating Certificates
17.10. Secure TCP/IP Connections with SSH Tunnels
17.11. Registering Event Log on Windows

This chapter discusses how to set up and run the database server and its interactions with the operating system.