Navigation :

PostgreSQL 12.19 Documentation > Chapter 18. Server Setup and Operation

Chapter 18. Server Setup and Operation

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

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. 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 GSSAPI Encryption

18.10.1. Basic Setup

18.11. Secure TCP/IP Connections with SSH Tunnels

18.12. Registering Event Log on Windows

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

Prev	Up	Next
17.1. Building with Visual C++ or the Microsoft Windows SDK	Home	18.1. The PostgreSQL User Account