Automated installation and administration with TPA

TPA (Trusted Postgres Architect) is a standard automated way of installing PGD and Postgres on physical and virtual machines, both self-hosted and in the cloud (with AWS EC2).

If you want to run on your own Linux systems or VMs, you can use also use TPA to deploy EDB Postgres Distributed directly to your own Linux hosts

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

• Installing xpanes works through the steps needed to:

• Installing TPA

• Using TPA to create a configuration

• Deploying the configuration with TPA

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

You can also perform a rolling major version upgrade with PGD administered by TPA.

• Deploying EDB Postgres Distributed using Trusted Postgres Architect
  • Prerequisite: Install TPA
  • Configure
    • Common configuration options
    • Owner
    • Platform options
    • Subnet selection
    • Disk space
    • Distribution
    • Repositories
    • Software versions
    • Hostnames
    • Locations
  • Provision
  • Deploy
  • Test
• Performing a Postgres major version rolling upgrade on a PGD cluster built with TPA
  • Upgrading Postgres major versions
    • Prepare the upgrade
    • Perform the upgrade on each node
  • Worked example
    • Confirm the current Postgres version
    • Verify that the target node isn’t the write leader
    • Perform a planned switchover
    • Stop Postgres on the target node
    • Install PGD and utilities
    • Initialize the new Postgres instance
    • Migrate configuration to the new Postgres version
    • Verify the Postgres service is inactive
    • Swap PGDATA directories for version upgrade
    • Update the Postgres service configuration
    • Restart Postgres
    • Validate the new Postgres version
    • Clean up post-upgrade
    • Next steps
    • Check Postgres versions across the cluster
    • Reconcile with TPA