O'Reilly Open Source Convention
Books Safari Bookshelf Conferences O'Reilly Network

Arrow Home
Arrow Registration
Arrow Speakers
Arrow Keynotes
Arrow Tutorials
Arrow Sessions
Arrow At-a-Glance
Arrow Wiki
Arrow BOFs
Arrow Events
Arrow Exhibitors
Arrow Sponsors
Arrow Hotel/Travel
Arrow Venue Map
Arrow See & Do
Arrow Tips for
Arrow Press
Arrow Mail List



PostgreSQL Replication Panel
Jan Wieck, PostgreSQL Project
Robert Kaye, Mayhem and Chaos Coordinator, MusicBrainz
Andrew Sullivan, Afilias

Track: PostgreSQL
Date: Thursday, July 29
Time: 4:30pm - 6:05pm
Location: Salon G


Up until a couple of years ago, PostgreSQL had little to offer in the way of database replication. Now there is a selection of solutions, with more on the way. How do you choose between them? What problems does replication solve? (And which doesn't it?) Join us and find out!

Andrew Sullivan covers the use of erserver for load reduction, data merging, data warehousing, and warm failover. We'll discuss the limitations of the software, what you can do to work around those limitations, and then talk about some example applications.

Lazy Replication
Robert Kaye talks about lazy replication, which offers a flexible solution for mirroring a database in a read-only fashion using a loose network of database servers. He presents a case study that outlines what applications are suited to lazy replication, and how to avoid the pitfalls that MusicBrainz encountered while developing this system.

Jan Wieck explains his project, Slony-I, which will be a new enterprise level replication solution for the PostgreSQL database system. The design goals contain all the key features required by data centers for failover, backup and recovery purposes, that an asynchronous replication system can offer.

A Q&A session follows the presentations.

Download presentation file

O'Reilly Home | Privacy Policy

© 2004, O'Reilly Media, Inc.