Crunchy Data

    • PostgreSQL: The World's Most Advanced Open Source Relational Database
      Available Formats

    • Navigation
    • Home

    Navigation :
    PostgreSQL 11.17 Documentation > Chapter 18. Server Setup and Operation

    Chapter 18. Server Setup and Operation

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

    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
    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 PostgreSQL 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. 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.1. Building with Visual C++ or the Microsoft Windows SDK Home 18.1. The PostgreSQL User Account