Chapter 17. Server Setup and Operation

Table of Contents

17.1. The Postgres Pro Shardman User Account
17.2. Creating a Database Cluster
17.2.1. Use of Secondary File Systems
17.2.2. File Systems
17.3. Starting the Database Server
17.3.1. shardmand Examples
17.3.2. Server Start-up Failures
17.3.3. Client Connection Problems
17.4. Managing Kernel Resources
17.4.1. Shared Memory and Semaphores
17.4.2. systemd RemoveIPC
17.4.3. Resource Limits
17.4.4. Linux Memory Overcommit
17.4.5. Linux Huge Pages
17.4.6. Resource Prioritization
17.5. Shutting Down the Server
17.6. Upgrading a Postgres Pro Shardman Cluster
17.6.1. Upgrade Packages
17.6.2. Restart Postgres Pro Shardman Services and Database Instances
17.6.3. Upgrade the Extension
17.6.4. Upgrading Data via Replication
17.7. Preventing Server Spoofing
17.8. Encryption Options
17.9. Secure TCP/IP Connections with SSL
17.9.1. Basic Setup
17.9.2. OpenSSL Configuration
17.9.3. Using Client Certificates
17.9.4. SSL Server File Usage
17.9.5. Creating Certificates
17.10. Secure TCP/IP Connections with GSSAPI Encryption
17.11. Secure TCP/IP Connections with SSH Tunnels
17.12. Multi-Segment Insertion

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

The directions in this chapter assume that you are working with plain PostgreSQL without any additional infrastructure, for example a copy that you built from source according to the directions in the preceding chapters. If you are working with a pre-packaged or vendor-supplied version of PostgreSQL, it is likely that the packager has made special provisions for installing and starting the database server according to your system's conventions. Consult the package-level documentation for details.