Managing PostgreSQL with Ansible in EC2

Jay Edwards (Meangrape, Inc.)
Operations, Ballroom EF
Tutorial Please note: to attend, your registration must include Tutorials on Tuesday.
Average rating: ***..
(3.53, 15 ratings)

Chef and Puppet get significant gameplay in the configuration management world, yet both have specific levels of complexity. Ansible is a next generation configuration management system that includes deployment and ad hoc support as well. Language independent, with SSH as it’s underlying communications, there is minimal installation overhead, with any languages that can return JSON being supported. This is ideal for complex, cloud environments such as replication based Postgres deploys. In this presentation, we will show you how quickly Ansible can be used to set up a PostgreSQL deployment using master, streaming replication, backups and monitoring agents rapidly.

Specific topics we will cover are:

  1. An overview of Ansible’s architecture and framework.
  2. Transport methods
  3. Basic commands in Ansible
  4. Components of an operationally successful Postgres installation.
  5. Reviewing Postgres playbooks
  6. Live build of the cluster in EC2
  7. Additional resources for Ansible
Photo of Jay Edwards

Jay Edwards

Meangrape, Inc.

Jay Edwards is self-employed. As the first database administrator at Twitter he experienced a gamut of growth ranging from a handful of servers to thousands. While the Lead Database Engineer for President Obama’s 2012 reelection campaign, Jay did a lot of things that are still covered by an NDA; we can say that he managed a large number of disparate data sources and provided a high degree of technically focused management.


Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Gloria Lombardo at (203) 381-9245 or

Media Partner Opportunities

For media partnerships, contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

Contact Us

View a complete list of Velocity contacts