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 Postgres-XL Cluster
17.3.1. Creating Databases
17.3.2. Starting a GTM
17.3.3. Starting a GTM-Proxy
17.3.4. Configuring Datanodes
17.3.5. Configuring Coordinators
17.3.6. Starting Datanodes
17.3.7. Starting Coordinators
17.3.8. Server Start-up Failures
17.3.9. Client Connection Problems
17.4. Managing Kernel Resources
17.4.1. Shared Memory and Semaphores
17.4.2. Resource Limits
17.4.3. Linux Memory Overcommit
17.4.4. Linux Huge Pages
17.5. Shutting Down the Server
17.5.1. Shutting Down Coordinators and Datanodes
17.5.2. Shutting Down GTM-Proxies
17.5.3. Shutting Down GTM
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 a Self-signed Certificate
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.