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

Download:

epub
pdf

This page in other versions:
Postgres Pro Standard

12
11
10
9.6
9.5
( current )

Postgres Pro Enterprise

12
11
10
9.6

PostgreSQL

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.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. Using Client Certificates
18.9.2. SSL Server File Usage
18.9.3. Creating Certificates

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.

Prev	Home	Next
17.3. Installing Additional Supplied Modules	Up	18.1. The Postgres Pro User Account