PostgreSQL environments can quickly become very complex. Master/slave replication for disaster recovery. Barman to manage backups and WAL archiving. PGBouncer for load balancing and reduce downtime during upgrades and migrations. The list can go on and on.
Ansible is a very simple and powerful open source configuration management tool distributed under the GNU General Public License that allows us to deploy and manage our PostgresQL environments as a complete stack. Using Ansible's built in PostgreSQL modules we are able to define our database infrastructure as code. We also use Ansible to orchestrate the installation and configuration of all the other components we need for our PostgreSQL environment.