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 the 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.6. Upgrading a Postgre-XC Cluster
16.6.1. Upgrading Data via pg_dump
16.6.2. Non-Dump Upgrade Methods
16.7. Preventing Server 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.