Postgres Pro Standard : Documentation: 9.6: Chapter 19. Server Setup and Operation : Postgres Professional

Русский

Русский

This page in other versions:
Postgres Pro Standard
10
/
9.6
/
9.5
( current )
|
Postgres Pro Enterprise
10
/
9.6
|
PostgreSQL
10
/
9.6
/
9.5
/
9.4

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

Chapter 19. Server Setup and Operation

Table of Contents

19.1. The Postgres Pro User Account

19.2. Creating a Database Cluster

19.2.1. Use of Secondary File Systems
19.2.2. Use of Network File Systems

19.3. Starting the Database Server

19.3.1. Server Start-up Failures
19.3.2. Client Connection Problems

19.4. Managing Kernel Resources

19.4.1. Shared Memory and Semaphores
19.4.2. systemd RemoveIPC
19.4.3. Resource Limits
19.4.4. Linux Memory Overcommit
19.4.5. Linux Huge Pages

19.5. Shutting Down the Server

19.6. Upgrading a Postgres Pro Cluster

19.6.1. Upgrading Data via pg_dumpall
19.6.2. Upgrading Data via pg_upgrade
19.6.3. Upgrading Data via Replication

19.7. Preventing Server Spoofing

19.8. Encryption Options

19.9. Secure TCP/IP Connections with SSL

19.9.1. Using Client Certificates
19.9.2. SSL Server File Usage
19.9.3. Creating Certificates

19.10. Secure TCP/IP Connections with SSH Tunnels

19.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
18.2. Building libpq with Visual C++ or Borland C++	Up	19.1. The Postgres Pro User Account