Postgres Pro Standard : Documentation: 10: Chapter 17. 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 17. Server Setup and Operation
Prev	Up	Part III. Server Administration	Home	Next

Chapter 17. Server Setup and Operation

Table of Contents

17.1. The Postgres Pro 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. systemd RemoveIPC
17.4.3. Resource Limits
17.4.4. Linux Memory Overcommit
17.4.5. Linux Huge Pages

17.5. Shutting Down the Server

17.6. Upgrading a Postgres Pro 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 Certificates

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.

Prev	Up	Next
16.4. Migrating to Postgres Pro	Home	17.1. The Postgres Pro User Account