Chapter 16. Server Setup and Operation

Table of Contents
16.1. The Postgres-XC User Account
16.2. Creating a Database Cluster
16.3. Starting Postgres-XC Cluster
16.3.1. Creating Databases
16.3.2. Starting GTM
16.3.3. Starting GTM-Proxy
16.3.4. Configuring Datanode
16.3.5. Configuring Coordinator
16.3.6. Starting Datanodes
16.3.7. Starting Coordinators
16.3.8. Server Start-up Failures
16.3.9. Client Connection Problems
16.4. Managing Kernel Resources
16.4.1. Shared Memory and Semaphores
16.4.2. Resource Limits
16.4.3. Linux Memory Overcommit
16.5. Shutting Down the Server
16.5.1. Shutting Down Coordinators and Datanodes
16.5.2. Shutting Down GTM-Proxies
16.5.3. Shutting Down GTM
16.6. Upgrading a PostgreSQL Cluster
16.6.1. Upgrading Data via pg_dump
16.6.2. Non-Dump Upgrade Methods
16.7. Preventing Coordinator/Datanode Spoofing
16.8. Encryption Options
16.9. Secure TCP/IP Connections with SSL
16.9.1. Using Client Certificates
16.9.2. SSL Server File Usage
16.9.3. Creating a Self-signed Certificate
16.10. Secure TCP/IP Connections with SSH Tunnels
16.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.