Installing and configuring EDB Postgres Distributed 6

This section covers how to manually deploy and configure EDB Postgres Distributed 6.

• 1 - Prerequisites for Essential installation

• Step 2 - Configure repositories

• Step 3 - Installing the database and pgd

• Step 4 - Configuring the cluster

• Step 5 - Checking the cluster

• 1 - Prerequisites for Essential installation
  • Provisioning hosts
    • Create an admin user
    • Ensure networking connectivity
  • Worked example
• Step 2 - Configure repositories
  • Configure repositories
    • EDB_SUBSCRIPTION_TOKEN
    • EDB_REPO_TYPE
  • Install the repositories
  • Worked example
    • Set the environment variables
• Step 3 - Installing the database and pgd
  • Install the database and PGD software
    • Set the Postgres version
    • Set the package names
    • Run the installation command
  • Worked example
• Step 4 - Configuring the cluster
  • Configuring the cluster
  • Cluster name
  • Group names
  • Node names
  • Paths and users
  • On each host
    • On the first host
    • On the second host
    • On the third host
  • Worked example
    • On the first host
    • On the second host
    • On the third host
• Step 5 - Checking the cluster
  • Checking the cluster
  • Worked example
    • Preparation
    • Ensure the cluster is ready
    • Create data
    • On node-1, create a table
    • On node-1, populate the table
    • On node-1, monitor performance
    • On node-1 get a checksum
    • Check data
    • Log in to host-2’s Postgres server
    • On node-2, get a checksum
    • Compare with the result from node-one
    • Log in to host-3’s Postgres server
    • On node-3, get a checksum
    • Compare with the result from node-one and node-two