PostgreSQL: Documentation: 11: Chapter 18. Server Setup and Operation

Documentation → PostgreSQL 11

Supported Versions: Current (18) / 17 / 16 / 15 / 14

Development Versions: 19 / devel

Unsupported versions: 13 / 12 / 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.

Chapter 18. Server Setup and Operation
Prev	Up	Part III. Server Administration	Home	Next

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