Crunchy Data

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

    • Navigation
    • Home

    Navigation :
    PostgreSQL 9.5.3 Documentation > Server Setup and Operation

    Server Setup and Operation

    PostgreSQL 9.5.3 Documentation
    Prev Up Next

    Table of Contents
    17.1. The PostgreSQL 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. Resource Limits
    17.4.3. Linux Memory Overcommit
    17.4.4. Linux huge pages
    17.5. Shutting Down the Server
    17.6. Upgrading a PostgreSQL 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 a Self-signed Certificate
    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 Home Next
    Building libpq with Visual C++ or Borland C++ Up The PostgreSQL User Account