Check out http://www.pgconf.us/2015/event/97/ for the full talk details.
In this talk I'm going to touch different techniques and tools for managing changes inside PostgreSQL databases, including schema deployments, data changes and usage of stored procedures as a versioned API layer. Based on my experience of no-downtime deployments at Zalando SE, one of the biggest European fashion retailers, I'm going to highlight different approaches to database deployments and introduce some open-source tools used and developed by the Database Team at Zalando.
About the Speaker
Alexey started with PostgreSQL at 2003 as a C programmer. He learned how to debug the backend code before learning SQL, but caught up on the latter pretty quickly. He is now using both of those skills and years of experience as a database consultant to help his employer manage a growing number of PostgreSQL database clusters and deal with hundreds of database changes during weekly deployments. A native of Simferopol, Ukraine, he lives in Berlin and works as a Database Engineer at Zalando SE. Over the years, he contributed code and documentation to the PostgreSQL project.