Manual Installation and Administration

This section of the manual covers how to manually deploy and administer EDB Postgres Distributed.

• Installing xpanes 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

The installing section provides an example cluster which will be used in future examples.

• Deploying 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 4 - Installing the PGD software
    • Installing the PGD software
    • Worked example
    • Summaries
  • Step 5 - Creating the PGD cluster
    • Creating the PGD cluster
    • Worked example
  • 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 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