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 the Database Server
-
- 17.3.1. Server Start-up Failures
- 17.3.2. 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.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.