Reference v23

Installation

Running TPA in a Docker container

How to run TPA itself from within a Docker container, for systems where TPA is not supported natively.

Managing clusters in a disconnected or air-gapped environment

How to manage clusters in a disconnected or air-gapped environment

Distribution support

Which Linux distributions are supported by TPA.

TPA capabilities and supported software

What software can be installed and configured by TPA.

Administration

Reconciling changes made outside of TPA

How to reconcile changes made outside of TPA with the configuration in `config.yml`.

Services

EDB Postgres Distributed configuration

How to configure and deploy EDB Postgres Distributed (PGD) with TPA.

Barman

Configuring Barman for backup and recovery with TPA.

Configuring EFM

How to install and configure EFM with TPA.

Configuring haproxy

How to install and configure haproxy with TPA.

Configuring HARP

Configuring HARP for BDR-Always-ON clusters.

Configuring Postgres Enterprise Manager (PEM)

Installing and configuring Postgres Enterprise Manager (PEM) with TPA.

Configuring pgbouncer

Adding pgbouncer to your Postgres cluster.

Configuring pgd-proxy

Incorporating pgd-proxy into your TPA deployed PGD 5 cluster.

pglogical configuration

Configuring pglogical replication with TPA.

Configuring repmgr

How to install and configure repmgr with TPA.

Configuration

How TPA uses 2ndQuadrant and EDB repositories

How TPA uses 2ndQuadrant and EDB repositories.

Configuring EDB Repos 2.0 repositories

How to configure EDB Repos 2.0 package repositories on any system.

Configuring 2ndQuadrant repositories

How to configure 2ndQuadrant package repositories on any system.

Configuring APT repositories

Configuring APT repositories for Debian and Ubuntu systems.

Configuring YUM repositories

Configuring YUM package repositories on RedHat systems.

Creating and using a local repository

Creating and using a local repository with TPA.

Installing from source

Building and installing Postgres extensions from source.

Git credentials

How to authenticate to Git repositories during deployment.

Environment

Controlling the target instances environment during deployment.

Python environment

The Python environment used by TPA and how to configure it.

Configuring /etc/hosts

Configuring /etc/hosts on instances with TPA

Filesystem configuration

Configuring volumes for instances in a TPA cluster.

Uploading artifacts

Uploading files and directories to target instances with TPA.

ssh_key_file

About the ssh_key_file setting in config.yml and how to use an existing SSH keypair for a cluster.

Managing SSH host keys

Managing a cluster's SSH host keys with TPA.

Postgres source installation

Building Postgres from source using TPA.

Installing packages

Installing packages on target instances with TPA.

Running initdb

Running initdb to initialise a Postgres data directory on a target instance.

Installing Postgres-related packages

Adding extra packages that depend on Postgres to your cluster.

SSL Certificates

Enabling the pg-backup-api and configuring client cert authentication.

Setting sysctl values

Setting sysctl values for target instances.

Postgres configuration

Creating Postgres databases

Creating Postgres databases during deployment.

Creating Postgres tablespaces

Tablespaces in Postgres and how to configure them with TPA.

postgresql.conf

Modifying postgresql.conf on a TPA-managed Postgres cluster.

pg_hba.conf

Customizing the pg_hba.conf file for your Postgres cluster.

pg_ident.conf

Working with pg_ident.conf.

Configuring .pgpass

Defining the generated .pgpass file with TPA.

The postgres Unix user

How TPA configures the Postgres system user

Creating Postgres users

Creating Postgres users during deployment.

Commands

tpaexec archive-logs

How to archive logs from a TPA cluster.

tpaexec download-packages

The command that downloads packages for a TPA cluster.

TPA custom commands

Creating custom commands for TPA to perform tasks specific to your environment.

TPA custom tests

How to write custom tests for TPA clusters.

Configuring the beacon agent

Integrating TPA deployments with EDB Postgres AI using the agent

Locale

Setting the locale for the target instance.

Patroni cluster management commands

Using Patroni as a failover manager with TPA.

Adding Postgres extensions

Postgres extensions and how to configure them with TPA.

tpaexec deprovision

The command that destroys a cluster and associated resources.

tpaexec info

A command to output information about the TPA installation.

tpaexec reconfigure

The command that reads config.yml, changes the cluster in various ways and outputs a new config.yml.