Manual deployment and configuration of PGD

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

• Deploying manually works through the steps needed to: - Provision hosts - Install Postgres - Configure repositories - Install the PGD software - Create a cluster - Check a cluster - Configure PGD proxies - Install and use PGD CLI

• Deploying PGD manually
  • Step 1 - Provisioning hosts
    • Provisioning hosts
    • Worked example
  • Step 2 - Installing Postgres
    • Installing Postgres
    • Worked example
  • Step 3 - Configuring PGD repositories
    • Configuring PGD repositories
  • Step 5 - Creating the PGD cluster
    • Creating the PGD cluster
    • Worked example
  • Step 4 - Installing the PGD software
    • Installing the PGD software
    • Worked example
    • Summaries
  • Step 6 - Checking the cluster
    • Checking the cluster
    • Worked example
  • Step 7 - Configure proxies
    • Configure proxies
    • Worked example
    • Preparing for proxies
    • Create a pgdproxy user on the database
    • Configure proxy routes to each node
    • Create a pgdproxy user on each host
    • Configure the systemd service on each host
    • Create a proxy config file for each host
    • Install a PGD proxy configuration on each host
    • Restart the service
    • Test the proxy
  • Step 8 - Using PGD CLI
    • Using PGD CLI
    • Worked example