The DevOps philosophy has been widely adapted by software developers and sysadmins, but DBAs have not been an active part of the movement yet. The Trusted Postgres Architect (TPA) attempts to change that by helping to deploy Postgres architectures with infrastructure as code.

TPA is an open source orchestration tool that uses Ansible to deploy Postgres clusters according to our best practices. These recommendations are as applicable to quick testbed setups as to production environments. We will see how TPA can deploy PostgreSQL to bare metal, AWS and docker containers, using different replication manager tools such as repmgr and Patroni, and backup and recovery solutions such as Barman.

TPA has been released as open source this year, and it accumulates several years of experience from our engagements with customers, therefore, it is nowadays being used in production by several projects.

More information can be found here: https://www.enterprisedb.com/products/trusted-postgres-architect-tpa