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 Postgres-XL Cluster
18.3.1. Creating Databases
18.3.2. Starting a GTM
18.3.3. Starting a GTM-Proxy
18.3.4. Configuring Datanodes
18.3.5. Configuring Coordinators
18.3.6. Starting Datanodes
18.3.7. Starting Coordinators
18.3.8. Server Start-up Failures
18.3.9. 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.5.1. Shutting Down Coordinators and Datanodes
18.5.2. Shutting Down GTM-Proxies
18.5.3. Shutting Down GTM
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. Using Client Certificates
18.9.2. SSL Server File Usage
18.9.3. Creating Certificates
18.10. Secure TCP/IP Connections with SSH Tunnels
18.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.