Crunchy Data

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

    • Navigation
    • Home

    Navigation :
    PostgreSQL 9.6.10 Documentation > Server Setup and Operation

    Server Setup and Operation

    PostgreSQL 9.6.10 Documentation
    Prev Up 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. 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
    Building libpq with Visual C++ or Borland C++ Up The PostgreSQL User Account