Server Setup and Operation
- Table of Contents
- 18.1. The PostgreSQL User Account
- 18.2. Creating a Database Cluster
-
- 18.2.1. Use of Secondary File Systems
- 18.2.2. Use of Network File Systems
- 18.3. Starting the Database Server
-
- 18.3.1. Server Start-up Failures
- 18.3.2. Client Connection Problems
- 18.4. Managing Kernel Resources
-
- 18.4.1. Shared Memory and Semaphores
- 18.4.2. Resource Limits
- 18.4.3. Linux Memory Overcommit
- 18.4.4. Linux Huge Pages
- 18.5. Shutting Down the Server
- 18.6. Upgrading a PostgreSQL Cluster
-
- 18.6.1. Upgrading Data via pg_dumpall
- 18.6.2. Upgrading Data via pg_upgrade
- 18.6.3. Upgrading Data via Replication
- 18.7. Preventing Server Spoofing
- 18.8. Encryption Options
- 18.9. Secure TCP/IP Connections with SSL
-
- 18.9.1. Using Client Certificates
- 18.9.2. SSL Server File Usage
- 18.9.3. Creating a Self-signed Certificate
- 18.10. Secure TCP/IP Connections with SSH Tunnels
- 18.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.