Postgres Pro Enterprise : Documentation: 11: Chapter 18. Server Setup and Operation : Postgres Professional

Download:

epub
pdf

This page in other versions:
Postgres Pro Standard

13
12
11
10
9.6
9.5
( current )

Postgres Pro Enterprise

13
12
11
10
9.6

PostgreSQL

13
12
11
10
9.6
9.5
9.4

Chapter 18. Server Setup and Operation
Prev	Up	Part III. Server Administration	Home	Next

Chapter 18. Server Setup and Operation

Table of Contents

18.1. The Postgres Pro 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. systemd RemoveIPC
18.4.3. Resource Limits
18.4.4. Linux Memory Overcommit
18.4.5. Linux Huge Pages
18.4.6. Resource Prioritization

18.5. Shutting Down the Server

18.6. Upgrading a Postgres Pro 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. Basic Setup
18.9.2. OpenSSL Configuration
18.9.3. Using Client Certificates
18.9.4. SSL Server File Usage
18.9.5. Creating Certificates

18.10. Secure TCP/IP Connections with SSH Tunnels

18.11. RDMA Connections

18.11.1. Enabling Postgres Pro Enterprise Client/Server RDMA Connections
18.11.2. Using RDMA with pg_dump
18.11.3. Using RDMA for Master-Standby Replication

18.12. Registering Event Log on Windows

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

Prev	Up	Next
17.4. Migrating to Postgres Pro	Home	18.1. The Postgres Pro User Account