TPAexec is an orchestration tool that uses Ansible to build Postgres clusters that follow Trusted Postgres Architecture (TPA).
TPA basically includes a set of recommendations from 2ndQuadrant about how to set up a Postgres cluster in various scenarios. These represent the best practices followed by 2ndQuadrant, and are as applicable to quick testbed setups as it is to production environments.
This topic was further explored in the live webinar, “PostgreSQL deployments & TPAexec” hosted by Muhammad Haroon (PostgreSQL Consultant at 2ndQuadrant).
In this webinar, we discussed how TPAexec is designed to make life simpler in terms of PostgreSQL cluster deployments.
Those who weren’t able to attend the live webinar can now view the recording here.
Due to limited time, some of the questions were not answered during the live webinar, so answers by the host are provided below:
Question: Is replication possible with TPAexec?
Answer: Yes, TPAexec helps you create High-Availability clusters using both physical replication and barman for backup and recovery management. You can even add logical replication nodes.
Question: Can TPAexec be used where we need to change database technology? For example, from Oracle to Postgres, sometimes it’s necessary to work with a hybrid database until the porting of applications is complete.
Answer: TPAexec is designed to work with PostgreSQL deployments. It does not work with Oracle but it can happily take care of the Postgres part.
Question: How is cluster monitoring maintained in TPAexec?
Answer: As mentioned during the talk, TPAexec maintains cluster inventory to make sure your cluster specification/description matches the deployed cluster.
To be the first to know about upcoming PostgreSQL webinars by 2ndQuadrant, visit our Webinars page.
For any questions, comments, or feedback, please visit our website or send an email to [email protected].