How to

• Essential How-To
  • Overview
  • Essential features
  • Essential How-To Guides
    • PGD Essential architectures
      • Choosing an architecture
      • Standard architecture - Ideal for a highly available single location
      • Near/far architecture - Ideal for disaster recovery
        • Standard PGD architecture
        • Near/far architecture
    • Installing and configuring EDB Postgres Distributed 6
      • 1 - Prerequisites for Essential installation
        • Provisioning hosts
        • Worked example
      • Step 2 - Configure repositories
        • Configure repositories
        • Install the repositories
        • Worked example
      • Step 3 - Installing the database and pgd
        • Install the database and PGD software
        • Worked example
      • Step 4 - Configuring the cluster
        • Configuring the cluster
        • Cluster name
        • Group names
        • Node names
        • Paths and users
        • On each host
        • Worked example
      • Step 5 - Checking the cluster
        • Checking the cluster
        • Worked example
    • Connections
      • Connecting through the connection manager
      • Connecting directly to a data node
    • Using PGD CLI
      • Using PGD CLI
        • Configuring and connecting PGD CLI
        • Use PGD CLI to explore the cluster
      • Worked example
        • Ensure PGD CLI is installed
        • (Optionally) Create a configuration file
        • Running PGD CLI
        • Using PGD CLI to explore the cluster
        • Check the health of the cluster
        • Show the nodes in the cluster
        • Show the groups in the cluster
        • Set a group option
        • Set the write leader
      • PGD Essential constraints
        • Verify cluster architecture
        • PGD compatibility assessment
        • Commit Scope management commands
        • Set group options
        • PGD node setup
    • Durability in PGD Essential
      • Commit Scopes
        • local protect
        • lag protect
        • majority protect
        • adaptive protect
      • Using Commit Scopes
        • Within a transaction
        • For a session
        • For a group
    • Autopartitioning
      • Autopartitioning and replication
      • Range partitioning
    • Production Best Practices
      • Sizing
        • CPU/Core sizing
      • Time and PGD
        • Clocks and timezones
      • Security Best Practices
• Expanded How-to
  • Overview
  • Expanded Features
    • PGD Architectures
      • Always-On Architecture
        • Standard EDB Always-on architectures
        • Architecture details
        • Choosing your architecture
        • Adding flexibility to the standard architectures
      • Essential Architectures
      • Multi-Location Architectures
      • Geo-Distributed Architectures
    • Installing and configuring EDB Postgres Distributed 6
      • 1 - Prerequisites for Expanded installation
        • Provisioning hosts
        • Worked example
      • Step 2 - Configure repositories
        • Configure repositories
        • Install the repository/repositories
        • Worked example
      • Step 3 - Installing the database and pgd
        • Install the database and PGD software
        • Worked example
      • Step 4 - Configuring the cluster
        • Configuring the cluster
        • Cluster name
        • Group names
        • Node names
        • Paths and users
        • On each host
        • Worked example
      • Step 5 - Checking the cluster
        • Checking the cluster
        • Worked example