跳至主要內容

KlustronDB小于 1 分钟

Chapter 18. 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](creating-cluster.md#CREATING-CLUSTER-NFS)

18.3. Starting the Database Server : 18.3.1. Server Start-up Failures

[18.3.2. Client Connection Problems](server-start.md#CLIENT-CONNECTION-PROBLEMS)

18.4. Managing Kernel Resources : 18.4.1. Shared Memory and Semaphores

[18.4.2. systemd RemoveIPC](kernel-resources.md#SYSTEMD-REMOVEIPC)

[18.4.3. Resource Limits](kernel-resources.md#id-1.6.5.6.5)

[18.4.4. Linux Memory Overcommit](kernel-resources.md#LINUX-MEMORY-OVERCOMMIT)

[18.4.5. Linux Huge Pages](kernel-resources.md#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](upgrading.md#UPGRADING-VIA-PG-UPGRADE)

[18.6.3. Upgrading Data via Replication](upgrading.md#UPGRADING-VIA-REPLICATION)

18.7. Preventing Server Spoofing

18.8. Encryption Options

18.9. Secure TCP/IP Connections with SSL : 18.9.1. Basic Setup

[18.9.2. OpenSSL Configuration](ssl-tcp.md#SSL-OPENSSL-CONFIG)

[18.9.3. Using Client Certificates](ssl-tcp.md#SSL-CLIENT-CERTIFICATES)

[18.9.4. SSL Server File Usage](ssl-tcp.md#SSL-SERVER-FILES)

[18.9.5. Creating Certificates](ssl-tcp.md#SSL-CERTIFICATE-CREATION)

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.