Djangocon 2013

September 2-7, 2013

PostgreSQL Replication Tutorial

Josh Berkus

Audience level:
Intermediate

Description

Want to provide some redundancy and availability to your Django application? PostgreSQL's built-in Replication feature has you covered. Learn what you need to know to deploy and administer it.

Abstract

PostgreSQL's built-in replication is conceptually simple, but the devil is in the details, and this tutorial is all about the details. We will cover all of the essentials of how to set up and configure binary replication, using hands-on exercises for some elements, including:

  • setup & configuration
  • replication security
  • backup archiving
  • cascading replication
  • synchronous replication
  • failover and failback
  • load-balancing options
  • replication mangement tools
  • Postgres 9.3's logical changeset replication

Materials and vagrant test environment will be posted to the pgExperts Tutorial Page before DjangoCon. Attendees are strongly encouraged to download it and set up the learning environment before the tutorial; time will not be given during the tutorial to do so.

Attendees will leave knowing how to set up a simple replication cluster, and about the options for more complex configurations.